ExcelStats.XLS Basic Statistics on a Microsoft Excel Spreadsheet
by John O. McClain

New Version 5/8/08

This workbook tells you how to do a bunch of Statistics calculations using Microsoft Excel. Excel has an Add-In called the Analysis ToolPak. It appears under the Tools menu.

Menu: Tools, Data Analysis

Excel has two ways to do almost every statistical analysis, and in many cases this workbook illustrates both. There are separate sheets for each topic listed below.

Contents: Introduction; Sorting; Frequencies & Graphs; Histogram; ScatterPlot; Descriptive Stats; Rank & Percentile; Covariance; Correlation; Sampling; ConfidenceIntervals; One-Sample t-test; Two-Sample t-test; Regression.

This is a very simple spreadsheet, intended for teaching purposes. You are welcome to use it in any manner, and change it as you see fit. It comes without any guarantee whatsoever, and is distributed free of charge.

Click Here for the Excel 2003 version.

Click Here for the Excel 2007 version.

Back to: [ Free Software | John McClain's Page ]

---