power4XL Complete Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

    Analysis ToolPak    

    power4XL Home    

    Contact Us    

 

What functions are included in the Analysis ToolPak?

Related Topics

The Analysis ToolPak includes many functions for advanced use of Microsoft Excel.

These functions include:

  • Anova

    • Single Factor

    • Two-Factor with Replication

    • Two-Factor without Replication

  • Correlation

  • Covariance

  • Descriptive statistics

  • Exponential smoothing

  • F-Test Two-Sample for Variances

  • Fourier Analysis

  • Histogram

  • Moving Average

  • Random Number Generation

  • Rank and Percentile

  • Regression

  • Sampling

  • t-Test

  • z-Test

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.