Home | About | Books | Contact | Statistics Resources
Statistics Help Pages
Statistics Resources from TwoPaces
I recommend the use of Microsoft Excel for basic data entry, data management, and teaching and learning basic statistics. However, Excel's abilities as a statistics package are limited, even with add-ins. I have written a series of tutorials on the use of SPSS, a full-featured statistics package. Here are some links to other helpful resources.
Instructional Videos
Here are instructional videos I have made. Many of these make use of Excel 2003, but will eventually be updated to the newer versions. You may still find them helpful!
Excel Tutorials
Microsoft improved the statistical capabilities of Excel with Excel 2010, and the newest version of Excel, which is Excel 2013, will be released at the beginning of 2013. Excel 2013 is in preview mode at the moment if you want to give it a spin. Excel 2013 has all the statistical functionality of Excel 2010. If you are using a Mac, Excel 2011 for Mac also has these enhanced statistical features. If you are new to Excel, here are some free web-based tutorials to help you get started.
Worksheet Templates
The following worksheet templates are compatible with earlier versions of Excel. You can click on the link to launch Excel and open the template or you can right-click to download the file to your computer. When you open the worksheet, you may have to maximize the view of the work area to locate the worksheet tabs at the bottom of the screen. The templates make no use of macros or third party add-ins. You are free to download and modify these worksheets for educational or personal use. If you would like to use these worksheet models for commercial purposes, please contact the author.
Most of these worksheets are "protected" to keep users from accidentally changing the formulas. The templates also make use of color-coded formatting. The green-shaded data entry areas are where you put your raw data or test values.
You can simply type in your data values, or you can paste data from another worksheet into the the blank templates. Please read and follow the instructions for each template. In particular, note that with Excel 2007 pasting data from another worksheet can change cell protection from unlocked to locked, so you should follow the instructions to "Paste Special" and paste only the data values into these templates. If you find a worksheet unusable because of worksheet protection, you can select Review, Unprotect Sheet (from the Changes group) to unprotect the sheet. Or simply download a "clean" copy of the template from this web site.
Templates for Discrete Probability Distributions
- Binomial Probability Calculator - Supply the probability of success (p) and the number of trials (N)
Templates for Scale Data (Interval or Ratio) When Distributional Assumptions are Met
- Descriptive statistics - Use this template to calculate and display various summary statistics for raw data.
- ANOVA (one-way) - Use this template to compare three or more means from independent groups (between-groups designs).
- ANOVA (repeated measures) - Use this template to compare three or more measures for the same subjects (within-subjects designs).
- ANOVA (two-way) - Use this template for a balanced design with two factors, A and B.
- Confidence interval for a mean (normal distribution) - Appropriate for large sample sizes. Displays the 95% and 99% confidence intervals for the population mean.
- Confidence interval for a mean (t distribution) - Appropriate for small and large samples. Displays the 95% and 99% confidence intervals for the population mean.
- Correlation and regression - Conduct a correlation and regression analysis for one predictor (X) and one criterion (Y).
- Independent-samples t test - Compare the means for two independent samples.
- One-sample t test for a population mean - Compare the sample mean to a known or hypothesized population mean.
- Paired-samples t test - Compare the means for two related or paired samples.
Nonparametric Tests (Use When Data are Nominal or Ordinal or When Distributional Assumptions are Violated)
- Chi-square goodness of fit (equal expected frequencies only) - Use this template to compare the observed frequencies in two or more categories of a qualitative variable to the expected frequencies under the null hypothesis.
- Chi-square goodness of fit (equal or unequal expected frequencies) - Use this template to compare the observed fequencies in two or more categories of a qualitative variable to the expected frequencies under the null hpothesis when the expected frequencies could be unequal.
- Chi-square test of independence - Use this template to test the hypothesis that the observed frequencies in two or more categories for each of two qualitative variables are independent.
- Friedman test - nonparametric alternative to repeated-measures ANOVA for three or more ranks per subject.
- Kruskal-Wallis test - nonparametric alternative to one-way ANOVA for three or more independent groups.
- Mann-Whitney U Test for Independent Groups - Compare the ranks for two independent groups.
- Wilcoxon Matched-Pairs Signed-Ranks Test - Compare the ranks for related or paired samples.
If you make use of these templates for your statistics classes as either an instructor or a student, I would appreciate hearing from you. Any ideas you might have for additional templates or for improvements to the current ones will be very welcome. You can reach me at larry@twopaces.com.
Statistics Links
Online Journals
Online Statistics Texts and Tutorials
Datasets and Other Resources
Copyright © 2013 Larry A. Pace, Ph.D.