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)
WOSB (Women-Owned Small Business) Certified
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
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.