Below you'll find a number of templates I created to make working with statistics in Excel a bit easier.  You're welcome to keep copies of them and use them as you wish.  Some of them perform tasks that can be carried out by PHStat2, others address additional needs.  I ask that you not remove my name from the files, since it took a bit of time to create them.

Using Stevens' Excel Templates:  Useful Information

Hypothesis Test for One Mean

Frequency Distribution, Histogram,
and Box and Whisker Plot

Hypothesis Test for One Proportion

Common Frequency Polygons and Ogives

Hypothesis Test for Difference of Two Means

Pareto Diagram

Hypothesis Test for Difference of Two Proportions

Dot Plot and Empirical Rule

Hypothesis Test for Equality of Two Variances

Confidence Interval for the Population Mean

One Way ANOVA

Confidence Interval for the Population Proportion

Demonstration of Bias of Using Sigma Squared for Samples

Return to 191 Page