Excel Statistics Lab Manual
Problems, test and reviews  from our free Internet book 

Please  
Updated 10/09/16

 

Note to Users

This manual is good for those using Excel 2000 and 2007.
Those using 2010 and 2013 should use
Excel 2013 for Statistics.
Excel 2016 Professional is extensive.
for the basics. Excel Fun Statistics is much more expensive.
Problems, answers and explanation provide here will still very helpful.

 

Step 1  Use aprilblackie to open Quick Statistics Using Microsoft (TM) Excel.
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 A Sample Research Project shows how to calculates 
descriptive statistics, a t-test, and correlation using Excel.

Help from the Internet

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.