screening regression analysis in Excel
I would like to do screening regression analysis in Excel. Can this be done
and how ? Do I need an add-in of some kind ?
Any help appreciated.
Within limits, you can do it. Help for LINEST is extremely misleading,
it fits general linear models, not just straight lines.
shows how to fit a polynomial. In general, you just have to pass the X
matrix (less the initial column of 1's for the grand mean). If you
request statistics (TRUE as 4th argument), then the second output line
will be the standard errors of t...Investment analysis template
Hi, is there such a thing? I want to put some property info in and analyse
the figures. Thanks. Jazz. I am using Excel 2000.
I'm not aware of any property analysis templates, however, when I purchased
and sold homes, I often used the regression analysis functions in Excel
(e.g., trend) to normalize the values of a group of houses to assist in
determining whether they were under or over valued.
> Hi, is there such a thing? I want to put some property info in and analyse
> the figures. Thanks. Jazz. I am using E...Montly Reports
I am tring to make a report that with take 3 fields from my table and make a
monthly report. The fields are Date, Violation and Fine. I know I have to
base the table off of a Query but I do not know how to do that. Can someone
First, change the name of the field Date. It is a reserved workd and will
definitely cause you problems in this case. Even if you enclose it in
brackets, it can become a problem since you have to use the Date() function
in conjunction with it. For example purposes, I will call it ViolationDate.
Do not put any criteria in the query. Use the Where...Analysis Service Not Working
We are having an issue getting the analysis service working in our
environment. We are running Project Server 2007 with SP2 and all
subsequent CUs. We have SQL Server 2000 installed on the same
server. When I try to create the Data Analysis view, I receive the
"Failed to connect to the Analysis Services server. Verify the server
name and try again."
I have it set to the default server. I can also successfully build
the OLAP cubes and access them through an Excel data connection. We
have gone through the entire TechNet article and followed it...calculate 18 monts from a date
Hi I need to calculate from une date if 18 monts has past, if is false put a
"X" on if is true livet in blank (no 0 )
Kevin start on 06 mai 2007 still no 18 monts = "X"
Tony start on 03 fev 2007 hi pas 18 monts = " "
"Centauro" <Centauro@discussions.microsoft.com> wrote in message
> Hi I need to calculate from une date if 18 monts has past, if is false put
Hello, I am fairly new to this but need some help. I have just moved to
college and my new class requires me to install this "Analysis Tolpak"
so that I can do my homeowrk. My Office is at my home and this
homework is due tomorrow 0.o. I am wondering if there is a place and
perhaps some instructions on where I might find this said toolpak.
Thanks in advance all!! Your help is much appreciated.
Message posted from http://www.ExcelForum.com/
It was probably installed but not activated when Office was installed.
If so, Tools|Add-Ins and check "Analysis Toolpak&quo...Automatically send email montly
I'm setting up scheduling on all the workstations to run cleanmgr.exe
and AutoDeFrag.exe every month.
When this task is complete I want the stations to e-mail the Log file
(SchedLgU.txt) to me so I can check that the tasks ran properly.
Is there a way I can automatically schedule the same e-mail &
attachment to be sent each month?
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all ...Montly Query
I need your help in constructing a query that reads the data field in the
table, so it only returns the dates asked.
What i need now (and i hope to start gainning enough knowhow to do it miself)
it to bild a query (12 of them) for 1 month.
January of instance, displaying all the entries betwen 01-01-2007 and 31-01-
This should be simple, but iam still learning, so sorry for being a noob ;D
Message posted via http://www.accessmonster.com
How about one query where you specify the date range?
In the criteria "cell" under your Date fields enter the foll...Monte Carlo Analysis
Ok, I've searched Google and could not find information on the famous IMHO
Monte Carlo simulation thing for MS Project. Quick confirmation question: if
I simply write the 3 point estimating in MS-Excel, I would be able to derive
at a simulation of my own right (a manual one)....Thanks for your comments,
IMHO is the acronym that people use when they want to share their humble
opinion with you. IMHO stands for In My Humble Opinion. There is NO
company called IMHO! Re-read the original post when the responder told you
this. ...Excel Solution for Data Analysis
I hope someone can give me some tips as to how I can best develop an
analysis for 5 different worksheets. Basically, each worksheet is for
a different store location, under each worksheet are a number of items
that are ordered like flour, sugar and salt. Under each material
ordered are details on the price, i.e. price purchased at vendor, price
from vendor to warehouse, price from warehouse to us, and a total.
Now, I need to analyze all this data in one worksheet using drop down
lists. For example, I wanted to find out how much I've spent on flour
at Location 1 last year, this ...Analysis ToolPak installed but no Data Analysis option
I have installed the Analysis ToolPak successfully (and have used the Data
Analysis tools many times before), but sometimes the Data Analysis option
simply fails to appear in the menu. What could be causing this?
Sorry I can't help, but it seems that would be a useful tool. How do you get
it? I went to Excel add-ins online MS and it doesn't seem to be available
"Eric Stephens" wrote:
> I have installed the Analysis ToolPak successfully (and have used the Data
> Analysis tools many times before), but sometimes the Data Analy...how do I report data of court cases ,results,analysis,.....
please provide guidance ,advise to report court decisions,case summury
,analysis and lessons learned for 150 cases .Including numbers, dates,parties
involved,brief description,main issue and relavant legal opinion after the
fact.I 'd like to use excel 2002 or earlier. I appreciate it and thank you in
advance. Please feel free to send to
Are you sure you don't want us to FedEx it overnight to you? Frankly your
post doesn't make any sense, what's your question? You post a question,
someone here tries to answer it, don't expect us to research court c...Register Analysis or EOD Report
Does anyone have a custom EOD or register analysis report that they would
like to share? I cannot understand the register analysis report that was
sent with RMS. Does anyone have a custom one that offers more clarity that
they would like to share?
I sent a custom Register Analysis active report to Nick on 3/4/2005.
> Does anyone have a custom EOD or register analysis report that they would
> like to share? I cannot understand the register analysis report that was
> sent with RMS. Does anyone have a custo...Separate data and analysis
hope you can help me with this question.
I have an excel file which has 35 sheets, 1-31 sheets represent days of a
month , 32-35 sheets are analysis and charts
Ideally, I like to have 2 excel files, one with data only (for user to input
data) and another one contains only chart and analysis (for manager)
How can I do it?
Select sheets 32-35. Right click and select move or copy, then select new
book, click ok.
"L.Peter" <firstname.lastname@example.org> wrote in message
> Hi Group,
> hope you can help me with this q...Changing VAT Analysis to GST Analysis
I am in Australia, and we dont have the VAT....How do you change the
Scripting to say GST instead of VAT?
Call POSPartners Mr Richad Ranson ( email@example.com ) they have
the Australian modifications.
= = =
"Michael Thomas" <MichaelThomas@discussions.microsoft.com> wrote in message
> I am in Australia, and we dont have the VAT....How do you change the
> Scripting to say GST instead of VAT?
You can call me too. I have a major installation running i...Advanced Analysis Cubes and Multicurrency
We are considersing purchasing the Advanced Analysis Cubes when we upgrade to
GP 9.0. We don't use POP, SOP, or inventory but have over 50 entities on GP.
Can it pull multicurrency information? At this point I don't know exactly
what we would want to pull, possibly look at data in both originating and
...DDE Data analysis
I have a sheet which is connected via DDE, i.e. some cells get updated via
I would like to analyse this data for high and low values.
How can I save this data in other cells or print a chart (dynamicly).
To use =MAX() or =MIN() is not good as it is overwritten with new data.
Any ideas, links, etc. are welcome.
...How do I track montly paycheck advances in Money?
Let's say I make 5,000 in gross earnings a month. My
company's electronic paystub only breaks out the taxes
and deductions on the monthly earnings, including 401k
transfers, which are made on the last day of each month.
The paystub shows the payment to my checking account made
on the 15th of each month as an "advance", and only shows
the net amount.
I've been only tracking net pay in Money for a few years
now, but I'd like to know of a way to track all the taxes
and 401k transfers as well. The only way I can think of
doing it is to input the paycheck for ...Concentration Analysis
I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:
My output should be:
Range No. Value
0 - 25,000 4 30,000
25, 001- 50,000 10 275,000
you might look for FREQUENCY function in Help
On 16 Kwi, 08:44, Phillip Olan&...Windows server 2008 R2 DEFRAG analysis every afternoon? Automatic...
I am seeing event log event 258 every afternoon at 2pm Defrag analysis
on every drive on this W2K8 R2 box.
The event is:
"event 258" "The disk defragmenter successfully completed analysis on
This is not the Defrag scheduled task, which I have running on the
This is a File Server and the time that this runs does not seem good
to me since there are many users with open files at this time.
I cannot find where to disable or reschedule this event. Does Anyone
knbow about this?
Thanks in advance!
Is there a tool to tell how fragmented an Exchange 2003 database is without
taking it off-line?
On Thu, 9 Nov 2006 10:29:33 -0800, "Zack"
>Is there a tool to tell how fragmented an Exchange 2003 database is without
>taking it off-line?
Events 1221 in the app log will tell you how much free space is avail
in the databases.
...Viewing the montly report
so i get this notification that the montly report is ready to be viewed,
which is great... i view it.. and i expect the little reminder note on the
main page to vanish.
how do i get that reminder to go away?
Wait a day or two or open the report again.
"Justin Rich" <firstname.lastname@example.org> wrote in message
> how do i get that reminder to go away?
...What If Analysis
Wandering what would be the best way to plug in percentages on financials?
Sales xxx 100%
COGS= xxx 70%
Gross Margin xxx 30%
The actual numbers(xxx) and percentages are 2 separate columns. All numbers
are calculated through formulas.
I want to be able to punch in for example, 40% for COGS and automatically
calculate the number? Not sure how to approach this.
Here's a simple example set-up of a 1-variable data table
to illustrate what-if analysis:
Assuming you have in A2:B4
Sale...How can i made a monte Carlo simulation with Excel ?
Do I need some additional stuff ?
You could use only Excel features, like the worksheet function RAND() to
generate random numbers, the Data Table command to repeatedly recalculate
and collect values, the worksheet function FREQUENCY() to summarize results,
and the Chart Wizard.
Or, you could use an add-in, like my RiskSim at www.treeplan.com, @RISK at
www.palisade.com, or Crystal Ball at www.decisioneering.com.
"Bberni" <Bberni@discussions.microsoft.com> wrote in message
news:515AE599-7F1C-...What's a a good cheap Monte Carlo add-in for Excel?
I am looking for an inexpensive add-in to Excell that will allow me to do
simple Monte Carlo analysis. Commercial applications are too expensive and
unnecessarily advanced for my needs.
Don't know how good it is, but there is a 30-day trial product at
If you do a Google with 'Excel add-in Monte Carlo', there will be plenty to
(remove nothere from the email address if mailing direct)
"Gus" <Gus@discussions.microsoft.com> wrote in message