SAM - A STATISTICAL ADD-IN FOR MICROSOFT EXCEL

SAM adds one-button statistical functionality to Excel that greatly streamlines various standard statistical functions. Example menu items include:

Descriptive statistics for a sample that provides sample mean, standard deviation, median, minimum, maximum, count, standard error plus a sequence plot, normal plot, and a default histogram.

Hypothesis tests from a sample including one- and two-tail t-tests (equivalent to z-tests for large samples) for both one and two samples, runs test, and Wilcoxon signed-rank test.

Estimation from a sample that provides point estimates and 95% and 99% confidence and prediction intervals, corrected for sample size.

Regression modeling capability that allows addition and removal of independent variables (that need not be in contiguous columns) and provides full regression output including analysis of variance, F- and t-statistics and P-values, residuals, standardized residuals, Durbin-Watson statistic, runs-test on regression residuals, and plots of residuals, y vs fitted-y, and a normal plot of residuals.

Probability calculations for normal, t- and binomial probabilities.

SAM is used at several major business schools to facilitate the teaching of business statistics.

Some student comments on SAM:

"One of the most amazing programs I've ever used"
"Cool!"
"Useful, works well"
"SAM is great! - use it!"
"SAM is very visual and easy to use"
"SAM saves time for important applications"
"Great tool! User-friendly"
"That is an amazing program"

For further details, contact SAM@StrategicManagementScience.com.