Excel 2007: Analysis ToolPak

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:

1. Click the Microsoft Office Button , and then click Excel Options.

2. Click Add-ins, and then in the Manage box, select Excel Add-ins. Click Go.

3. 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:

1. Go to the Data Tab.
2. Click Data Analysis in the Analysis Group.

Available tools include:

• Anova

• Correlation

• Covariance

• Descriptive Statistics

• Exponential Smoothing

• F-Text Two-Sample for Variances

• Fourier Analysis

• Histogram

• Moving Average

• Random Number Generation

• Rank and Percentile

• Regression

• Sampling

• t-Test

• z-Test

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.

Copyright 1995-2008 The Software Pro^® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868 § Dawn@SoftwarePro.com § 11675 Bent Oaks Street, Suite 200; Parker, Colorado 80138 USA § www.SoftwarePro.com
Geek Speak Becomes People Friendly™
Microsoft Certified Application Specialist (MCAS) Instructor (Office 2007 & Windows Vista)
Certified Microsoft Office Specialist Master Instructor § Certified Microsoft Office Expert § Certified Women's Business Enterprise (WBE)
The Software Pro^® is a registered trademark