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)

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

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


Tips, Tricks, Secrets you need to know now!
Discover the secrets you wish you knew before...all of this plus 15 BONUS SHORTCUTS and access to handouts with 477+ MORE SHORTCUTS AND TIPS when you
sign-up for the Smart & Easy Software Tips & Tricks eMagazine!

Start Being More Productive Today!
CLICK HERE to
sign-up by email.
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.SoftwarePro.com
Home | Contact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 1995-2013 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 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 Specialist (MOS) Master Instructor § Certified Microsoft Office Expert § Certified Women's Business Enterprise (WBE)
The Software Pro® is a registered trademark
 Terms & Conditions       Privacy Policy