Excel Statistics Lab Manual
Directions, Problems, Test and Answers Load Into Spreadsheets
Use with our free Quick Notes Statistics textbook, as a stand alone, or with other software. Updated 8/4/17

Note to Users:
This manual is good for those using Excel 2000, 2007, and 2010. Data sets may be used with any software.
I would love for a someone to come out with update so my data and new directions appropriate for
use with
Excel 2013 for Statistics,  Excel 2016 Professional and Excel Fun Statistics.

Contact antonw@ix.netcom.com with questions


Step 1  Click on Quick Statistics Using Microsoft (TM) Excel and use password  aprilblackie to open .
This is where you will learn to do statistics with Excel.  
Problems are from Quick Notes Statistics, a free complete course outline.
Save as a Microsoft Excel Workbook to use in Excel!

Step 2
Look at all the tabs before working your way through the workbook.

Step 3  There are additional practice problems.  

Additional Practice Problems 1     Additional Practice Problems 2  

Step 4 Three tests designed as an example of how statistics can be used to do research.

Descriptive Statistics     Test Answers   

Probability     Test Answers 

Hypothesis Testing     Test Answers

Step 5

Excel Sample Statistics Research Project shows how to calculates 
descriptive statistics, a t-test, and correlation using Excel.

Help from the Internet

Quick Statistics Cheat Sheets for those in a hurry.

Statistics Video Lectures Using Excel

Improve your excel has over 1000 free Excel tutorials and tips.

Basic Statistics Review Problems with answers are designed to emphasize the basics.

Research Project is similar to the above tests only directions are provided.

Research Project Help By Academic Discipline
contains links to sites designed to help you do a research project.

Statistics Internet Library has free Internet Statistics books and much more.

Excel Internet Library
Excel For Statistical Data Analysis from Professor Hossein Arsham 
is an excellent  static presentation of the material found in our Excel 
Statistics Lab Manual.


Free Internet Libraries for Students, Teachers, and Professionals

Please Blog People About these Sites.