Microsoft Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 training 
 Home Programs Meet Dawn Free E-zine Contact What's New Site Map 
Excel 2007: Analysis Toolpak  

Services
Tips & Tricks
The Pro Shop
How-To Lessons
Free Articles
Newsletter
Resources

 
Dawn Bjork Buzbee
The Software Pro
®

Microsoft Certified Application Specialist (MCAS) Instructor

Certified Microsoft Office Specialist Master Instructor

Certified Microsoft Office Expert

Certified Women's Business Enterprise (WBE)

(303) 699-6868
Dawn@SoftwarePro.com

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 Microsoft Office Button, Microsoft Office 2007, and then click Excel Options.

excel 2007 options, customize excel 2007, excel options

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

excel 2007 add-ins, addins, analysis toolpak, analyses, statistical, engineering

  1. 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.

Analysis ToolPak, add-ins available, addins, statistical, engineering, analyses, functions

Go To Top of Page
Once it is installed, to access the Analysis ToolPak tools:

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

Analysis ToolPak, Excel 2007 data analysis, engineering, statistical, analysis tools

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.

Go To Top of Page


Hot Tip
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.
Did You Know?
Excel 2007 now supports up to 64 nested levels in formulas.


Tips, Tricks, Secrets that you need to know now!

Discover the secrets that you wish you knew before...all of this plus 15 BONUS SHORTCUTS when you sign-up for the Smart & Easy Software Tips & Tricks Newsletter!
Start Being More Productive Today!
CLICK HERE to sign-up directly via e-mail.
Home for Dawn Bjork Buzbee, The Software Pro Contact Dawn Bjork Buzbee, The Software Pro
 
www.SoftwarePro.com
HomeServices | Tips & Tricks | The Pro Shop | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

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