Excel's Analysis ToolPak gives you a whole range of new statistical analysis tools. These are the tools in Excel's Analysis ToolPak. You load them as add-ins.

Tool What it Does
Anova: Single Factor Analysis of variance for two or more samples
Anova: Two Factor with Replication Analysis of variance with two independent variables, and multiple observations in each combination of the levels of the variables.
Anova: Two Factor without Replication Analysis of variance with two independent variables, and one observation in each combination of the levels of the variables.
Correlation With more than two measurements on a sample of individuals, calculates a matrix of correlation coefficients for all possible pairs of the measurements
Covariance With more than two measurements on a sample of individuals, calculates a matrix of covariances for all possible pairs of the measurements
Descriptive Statistics Generates a report of central tendency, variability, and other characteristics of values in the selected range of cells
Exponential Smoothing In a sequence of values, calculates a prediction based on a preceding set of values, and on a prior prediction for those values
F-Test Two Sample for Variances Performs an F-test to compare two variances
Histogram Tabulates individual and cumulative frequencies for values in the selected range of cells
Moving Average In a sequence of values, calculates a prediction which is the average of a specified number of preceding values
Random Number Generation Provides a specified amount of random numbers generated from one of seven possible distributions
Rank and Percentile Creates a table that shows the ordinal rank and the percentage rank of each value in a set of values
Regression Creates a report of the regression statistics based on linear regression through a set of data containing one dependent variable and one or more independent variables
Sampling Creates a sample from the values in a specified range of cells
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
Statistical Analysis with Excel For Dummies Cheat Sheet

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.