Microsoft Office 2010 Expert, 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 trainingSoftware Tips & Tricks, Expert Speaker, Microsoft Office 2010 Training, Microsoft Certified Trainer, Microsoft Office Consultant, Books, Videos, Web Training  
 Home Products Programs Meet Dawn Free E-zine Media Room Contact 
Excel 2007: Analysis Toolpak  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus Resources

 
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)
WBENC Certified

WOSB (Women-Owned Small Business) Certified

(303) 699-6868
Dawn@TheSoftwarePro.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.


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

Go To Top of Page



Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
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.

 
www.TheSoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

Copyright 2015 The Software Pro & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
Dawn@TheSoftwarePro.com www.TheSoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2013 Specialist (MOS 2013) Master
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE) WBENC Certified
WOSB (Women-Owned Small Business) Certified
The Software Pro
is a registered trademark
Terms & Conditions       Privacy Policy