Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Problem with Regression function in 2007, Analysis Tool Pak

Hi. I need to perform the regression function for a class project...we are
building asset portfolios. I watched my professor do it in class, and it
seemed so easy.
I downloaded the add-in, "Analysis Tool Pak." From there, I do the
regression:

Y Values: individual stock returns-RFR (200 values).
X Values: S&P returns-RFR (200 values).

95% Confidence Intervals

I click residuals, plots, and line fit plots. After I click "OK" Excel says
that it stopped working, then it restarts, and it provides the data on a
seperate sheet, however, there is only one empty chart provided. I am
supposed to get TWO scatter-plot charts.

Do I need to add in more features? What is wrong here?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default Problem with Regression function in 2007, Analysis Tool Pak

Hi Lauren,

First take a look at this:
http://support.microsoft.com/kb/942430/en-us

On my machine I get all three plots. In the past, using versions earlier
than 2007, I did have problems from time to time. Unfortunately I was never
able to identify the problem. Try doing it on another machine. (I'm running
2007 SP 1 and under Vista SP 1).

You might check to see if Service Pack 1 is installed - File (Office
Button), Excel Options, Resources, about Microsoft Office Excel 2007 (on the
line just below that title is should have SP1 listed.

--
Cheers,
Shane Devenshire


"Lauren273" wrote:

Hi. I need to perform the regression function for a class project...we are
building asset portfolios. I watched my professor do it in class, and it
seemed so easy.
I downloaded the add-in, "Analysis Tool Pak." From there, I do the
regression:

Y Values: individual stock returns-RFR (200 values).
X Values: S&P returns-RFR (200 values).

95% Confidence Intervals

I click residuals, plots, and line fit plots. After I click "OK" Excel says
that it stopped working, then it restarts, and it provides the data on a
seperate sheet, however, there is only one empty chart provided. I am
supposed to get TWO scatter-plot charts.

Do I need to add in more features? What is wrong here?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Problem with Regression function in 2007, Analysis Tool Pak

Thanks for the quick response! Also, thank you for the hotfix info...that
would have been impossible to find. I checked, and I am running under SP1,
so I assume that my computer is just one of those "special cases" that needs
the hotfix. I've sent a request to Microsoft; I will update this when I
download the hotfix...until then...the homework remains undone (which is ok,
because it is 75 and sunny out :)...

-Lauren

"ShaneDevenshire" wrote:

Hi Lauren,

First take a look at this:
http://support.microsoft.com/kb/942430/en-us

On my machine I get all three plots. In the past, using versions earlier
than 2007, I did have problems from time to time. Unfortunately I was never
able to identify the problem. Try doing it on another machine. (I'm running
2007 SP 1 and under Vista SP 1).

You might check to see if Service Pack 1 is installed - File (Office
Button), Excel Options, Resources, about Microsoft Office Excel 2007 (on the
line just below that title is should have SP1 listed.

--
Cheers,
Shane Devenshire


"Lauren273" wrote:

Hi. I need to perform the regression function for a class project...we are
building asset portfolios. I watched my professor do it in class, and it
seemed so easy.
I downloaded the add-in, "Analysis Tool Pak." From there, I do the
regression:

Y Values: individual stock returns-RFR (200 values).
X Values: S&P returns-RFR (200 values).

95% Confidence Intervals

I click residuals, plots, and line fit plots. After I click "OK" Excel says
that it stopped working, then it restarts, and it provides the data on a
seperate sheet, however, there is only one empty chart provided. I am
supposed to get TWO scatter-plot charts.

Do I need to add in more features? What is wrong here?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The multiple regression tool - linear or non-linear regression? Statistical interest Excel Discussion (Misc queries) 2 February 7th 08 12:01 AM
regression analysis in excel 2007? nassema Excel Discussion (Misc queries) 1 January 29th 07 02:23 PM
How can I add data analysis function in tool? Michiko Excel Worksheet Functions 1 November 8th 05 10:26 AM
After adding Analysis Tool Pack, still no PRICE function, why? mtburdett Excel Worksheet Functions 1 November 5th 05 10:43 AM


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"