Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
For Microsoft Office Excel 2007
How To Perform Statistical and Engineering Analysis
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.
To access these tools, you will need to load the Analysis ToolPak add-in program:
- Click the Microsoft Office Button , and then click Excel Options.
Click Add-ins, and then in the Manage box, select Excel Add-ins. Click Go.
In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
Tip: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. If prompted, click Yes, to install the Analysis ToolPak.
Once it is installed, to access the Analysis ToolPak tools:
- Go to the Data Tab.
- Click Data Analysis in the Analysis Group.
Available tools include:
The data analysis functions can be used on only one worksheet at a time. When you perform data analysis on grouped worksheets, results will appear on the first worksheet and empty formatted tables will appear on the remaining worksheets. To perform data analysis on the remainder of the worksheets, recalculate the analysis tool for each worksheet. Some tools generate charts in addition to output tables.
To learn more about any of the above tools, enter the tool name into Excel 2007 Help.
Be an Excel Expert!
How effectively are you using Excel to create, format,
and analyze your important data?
Become an Excel expert with the
Excel with Excel
Learning Series. Master functions, filtering,
linking, PivotTables, charts and graphics, macros, and more!
Click Here to
Choose Your Excel Training
Tips, Tricks, Secrets you need to know now!
|To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you can load the Analysis ToolPak - VBA Add-in the same way that you load the Analysis ToolPak.|
|Excel 2007 now supports up to 64 nested levels in formulas.|