Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KA
 
Posts: n/a
Default Multiple Regression in Excel 2002 SP3 (Office XP)?

Where do I find the Multiple Regression add-in for data analysis in Excel
2002 (Office XP) ?
  #2   Report Post  
Mike Middleton
 
Posts: n/a
Default

KA -

Where do I find the Multiple Regression add-in for data analysis in Excel
2002 (Office XP) ? <


Tools | Data Analysis | Regression.

Here's an excerpt from my book "Data Analysis Using Microsoft Excel: Updated
for Office XP":

"If the Data Analysis command doesn't appear on the Tools menu, choose the
Add-Ins command from the Tools menu; in the Add-Ins Available list box,
check the box next to Analysis Tools. If Analysis Tools doesn't appear in
the Add-Ins Available list box, you may need to add the Analysis ToolPak
through a custom installation using the Microsoft Excel Setup program."

- Mike

www.mikemiddleton.com


  #3   Report Post  
KP
 
Posts: n/a
Default

Dear Mike, I am having the same problem, even though Data Analysis ToolPak
appears in my Add-Ins Available and I check it and click okay still I do not
see Data Analysis appear in my Tools menu. What can I do?

"Mike Middleton" wrote:

KA -

Where do I find the Multiple Regression add-in for data analysis in Excel
2002 (Office XP) ? <


Tools | Data Analysis | Regression.

Here's an excerpt from my book "Data Analysis Using Microsoft Excel: Updated
for Office XP":

"If the Data Analysis command doesn't appear on the Tools menu, choose the
Add-Ins command from the Tools menu; in the Add-Ins Available list box,
check the box next to Analysis Tools. If Analysis Tools doesn't appear in
the Add-Ins Available list box, you may need to add the Analysis ToolPak
through a custom installation using the Microsoft Excel Setup program."

- Mike

www.mikemiddleton.com



  #4   Report Post  
Mike Middleton
 
Posts: n/a
Default

KP -

Maybe you could try uninstalling/reinstalling the Analysis ToolPak or
repairing the installation:

Start | Control Panel | Add or remove programs | Microsoft Office | Change |
....

If you uninstall, it might be a good idea to reboot before reinstalling.

Also, choose "Analysis ToolPak," not "Analysis ToolPak - VBA."

- Mike
www.mikemiddleton.com


"KP" wrote in message
...
Dear Mike, I am having the same problem, even though Data Analysis ToolPak
appears in my Add-Ins Available and I check it and click okay still I do
not
see Data Analysis appear in my Tools menu. What can I do?

"Mike Middleton" wrote:

KA -

Where do I find the Multiple Regression add-in for data analysis in
Excel
2002 (Office XP) ? <


Tools | Data Analysis | Regression.

Here's an excerpt from my book "Data Analysis Using Microsoft Excel:
Updated
for Office XP":

"If the Data Analysis command doesn't appear on the Tools menu, choose
the
Add-Ins command from the Tools menu; in the Add-Ins Available list box,
check the box next to Analysis Tools. If Analysis Tools doesn't appear in
the Add-Ins Available list box, you may need to add the Analysis ToolPak
through a custom installation using the Microsoft Excel Setup program."

- Mike
www.mikemiddleton.com



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
Office XP: Excel only opens in one window. OfficeXPUser Excel Discussion (Misc queries) 5 October 13th 08 04:17 AM
Excel OLE objects crashing in other Office applications Hari Prasadh Excel Discussion (Misc queries) 4 August 31st 05 11:49 AM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
Excel 2003 formats different that excel 2002 Rich Excel Discussion (Misc queries) 0 April 22nd 05 05:43 PM
Excel XP 2002 Vs. Excel 2000 Samantha Excel Discussion (Misc queries) 0 April 18th 05 03:54 PM


All times are GMT +1. The time now is 01:19 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"