Stats.xls – David Hartvigsen

Stats.xls is an Excel workbook for doing basic statistics calculations and charting at the level of a typical introductory course.

Stats.xls is an ordinary Excel file; it is not an add-in; no macros are used; no “installation” is required. It works on stand-alone and networked PCs and Macs (dating back to Excel versions circa 2003).

Stats.xls should be easier to use than most statistics packages or Excel add-ins for statistics. With Stats.xls, you simply enter your raw data or summary statistics directly into the specified cells and all calculations and charts are instantly displayed. There is no need to navigate a menu structure. Instructions appear on each worksheet.

Unlike most stats packages, you can customize Stats.xls to your heart’s content.

Here is what Stats.xls does:

Plots histograms based on interval and categorical data.
Performs interval estimation for means and proportions for one and two populations.
Computes samples sizes for interval estimation for means and proportions for one population.
Performs hypothesis tests for means and proportions for one and two populations.
Plots process control charts.
Performs simple linear regression and scatter plots. Calculates confidence and prediction intervals.
Performs multiple linear regression.