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
                      Please          

Note

Use with Other Software, automatically loads into Excel, OpenOffice.org Calc

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

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

Statistics Videos
Statistics    
Behavioral Sciences Statistics  Software  Excel   Minitab     SPSS     TI-84   

Statistics One-Page Schamatics
1. Micro Statistics Taxonomies
Descriptive    Probability    Parametric    Nonparametric    Relational Statistics

2. Macro Statistics Taxonomies Statistics   Inferential
3. Choosing from appropriate statistics   Formulas   Distinguishing Statistics Tests   
Practice

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 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.