MS Excel Toolpak

MS Excel Data Analysis ToolPak Add-In Help

(excel spreadsheet support for college students)

Excel Topics

Descriptive Statisics
Histogram- graph cumulative frequencies
Descriptives- mean, median, mode, standard deviation, range, skewness and kurtosis
Rank and Percentile— ordinal and percentage rank table

Hypothesis Testing
T-Test: Two Sample Assuming Unequal Variances
T-Test: Two Sample Assuming Equal Variances
Z-Test: Two Sample for Means
T-Test: Paired Two Sample for Means
F-Test: Two-Sample for Variances

Regresion and Correlation
Correlation— table of correlation coefficients
Covariance— table of covariance values
Regression— simple or multiple linear regression analysis

Time Series Forecasting
Moving Average— time series based on moving averages smoothing
Exponential Smoothing— time series based on simple exponential smoothing

Alternatives Supported

Alternative Formats
SPSS Statistical Package for the Social Sciences (IBM PASW)
R Rstudio
Manual Calculations Available
(Other Software: Ask Me)

How It Works?

Get Help, Contact Me !

(excel spreadsheet support for college students)