The Analysis ToolPak is an Excel add-in that provides data analysis tools for financial, statistical and engineering data. It includes the following features:

• Anova: Single Factor and Two-Factor with Replication
• t-Tests: Paired Two Sample for Means, Two Sample assuming Equal Variances, Two Sample assuming Unequal Variances, One Sample
• F-Test Two-Sample for Variances
• Exponential Smoothing
• Moving Average
• Weighted Moving Average
• Macroeconomic Modeling Tools
• Regression
• Correlation and Covariance
• Descriptive Statistics
• Histograms
• Pareto Charts
• Scatter Plots
• Box Plots

Installing the Analysis ToolPak

Using the Analysis ToolPak

References