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.
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!
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.
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.
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 email@example.com.
Copyright © 2013 Larry A. Pace, Ph.D.