This activity uses Microsoft Excel to estimate the population variance of grouped data two ways: the variance within a group and the variance between groups. This activity accompanies Section 7.3 of Data Matters.
This collection of calculators allows users to perform a number of statistical applications. Each provides background on the procedure and an example. Users can compute Descriptive Statistics and perform t-tests, Chi-square tests, Kolmogorov-Smirnov tests, Fisher's Exact Test, contingency tables, ANOVA, and regression.