Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jana
 
Posts: n/a
Default Excel 95 had a "data analysis" option, how can I access on XP?

In Windows 95 version of Excel, if you select the "Tools" option at the top
of the page, it offers you a "Data Analysis" selection. Once at the Data
analysis selection, the program will run tests such as ANOVA, regression, and
best fit - among others. How can I find/use/download/access this option on
Windows XP version of Excel? I require statistical analysis for my research,
but the machines only export to Excel and this was a fabulous option that I
can no longer find since the university has updated my Windows format.
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default Excel 95 had a "data analysis" option, how can I access on XP?

Jana -

Check Tools | Add-Ins to see if Analysis ToolPak is listed. If it is, check
the box, and it'll appear on the Tools menu. If it's not listed, use the
Office/Excel installation CD to add Analysis ToolPak to your hard drive. The
Analysis ToolPak must be installed from the Office/Excel CD. It cannot be
downloaded.

- Mike
www.mikemiddleton.com

"Jana" wrote in message
...
In Windows 95 version of Excel, if you select the "Tools" option at the
top
of the page, it offers you a "Data Analysis" selection. Once at the Data
analysis selection, the program will run tests such as ANOVA, regression,
and
best fit - among others. How can I find/use/download/access this option
on
Windows XP version of Excel? I require statistical analysis for my
research,
but the machines only export to Excel and this was a fabulous option that
I
can no longer find since the university has updated my Windows format.



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
Financial modelling from Excel to Access Huyeote Excel Discussion (Misc queries) 3 March 9th 11 03:59 PM
Excel to Access... mseifert_99 New Users to Excel 3 January 18th 06 05:06 PM
Access Excel Linked Text and Number Issues Scott Excel Discussion (Misc queries) 2 October 4th 05 09:24 PM
MS Access in Excel Jackie Excel Worksheet Functions 4 February 11th 05 02:21 PM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 02:32 AM


All times are GMT +1. The time now is 11:29 AM.

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"