Statistical Spreadsheets

 

Just the Basics

I created these spreadsheets for students who have difficulty installing Java and running the Stats Homework package.  This ensures that all students have free, user-friendly software for double-checking their hand-written work.  Each present cells where the student enters a very small data set, and a table that displays the results of the statistical analysis.  For example, here is the spreadsheet that computes descriptive statistics:

One of the benefits of this approach is that students can investigate the formulas used to compute the statistics and get an appreciation for how easy it is to do basic statistics with a spreadsheet.  Students and instructors are free to modify these sheets.

This archive includes spreadsheets for descriptive statistics, T tests, one-factor ANOVAs, correlation and regression, goodness-of-fit tests, and contingency table tests.


Return to the Main Page