Statistics Using Spreadsheets

Directions, Problems with Answers,
Test With Complete Solutions
Load Into Most Software
 Use with our free Quick Notes Statistics textbook New
pdf version 

1. Using the Manual

2. Three Tests

3. Supplements

Contact antonw@ix.netcom.com with questions

Return to Excel Internet Library  
 1/27/21
         Please Share          

 

1. Using the manual will  help you learn statistics.
Problems and answers in the spread sheets are from our free
 lecture notes
Quick Notes Statistics, and with a
pdf version
 

Be sure to save Worksheets

Click on Quick Statistics Using Microsoft (TM) Excel and use password  aprilblackie to open .

Look at all the tabs before working your way through the workbook.
Note the many problems with complete solutions.
You may begin anywhere.
Reviewing complete solutions is a great review

 

Additional Practice Problems 1

Additional Practice Problems 2  

 

 

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

3. Supplements

Determine Appropriate Application
Choosing Appropriate Statistics Test 
Statistics Application Tools

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.