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

Please  
Updated 3/22/17

 

Note to Users:

This manual is good for those using Excel 2000 and 2007.
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  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

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.