Excel Statistics
Videos Lectures

Thanks! Walter
suggestions to antonw@ix.netcom.com

Updated 10/2/18 
Please link to, use to educate and Share

Related Statistics Stuff  

1. Research Project Help  

2. Statistics Internet Library 

3. Free Statistics Textbook  

4. Behavioral Science  

5. Statistics Internet Library 

Many students are also using our
Free Excel Statistics Lab Manual
and other spreadsheets.
It is really a Quick way to learn.

It is a stand alone but was designed to use with our free Quick Notes Statistics textbooks. The textbook had 90,000 free pdf  downloads during December of 2019. Hopefully, users did not have to buy a
traditional high-price book.

Descriptive Statistics
Confidence Intervals
Hypothesis Testing

Tips and Tricks 4 min

Improve Efficiency 13 min

Experimental Design 6 min

Bad Data 35 min

Appropriate Application
Choosing Appropriate Test 
Application Tools


Research Project
Stastistics Lab Manuel

 Tests & Answers

Exam Help
. Problems & Solutions
2. Statistics Reviews
3. Test Prep strategy


Statistics, Tests and Measurement, 4 Videos 
Each lasts about 15 minutes and provide a subjective overview. 

Descriptive Statistics
Excel Statistics 01: Intro To Excel 2007 for Statistics (10:09)
Excel Statistics 02: Calculations, Operators, Formulas 10:13
Excel Statistics 03: Data Analysis Sorting & Pivot Tables 9:55
Excel Statistics 04: Frequency Pivot Table Chart Basics (10:13)
Excel Statistics 05: Cell References in Formulas (9:35)
Excel Statistics 03: Data Analysis Sorting & Pivot Tables (9:55)
Excel Statistics 08: Install Excel 2007 Data Analysis Add-in 2:44
Excel Statistics 09: What Is Statistics? (10:28)
Excel Statistics 10: Data & Scales/Levels of Measurement (10:22)
Excel Statistics 11: Descriptive & Inferential Statistics (9:59)

Excel Statistics 12: Categorical Frequency Distribution w Formulas (10:36)
Excel Statistics 13: Column Chart From Frequency Distribution 7:20
Excel Statistics 14: Categorical Relative & Percent Freq. Dist. w Formulas (8:16)
Excel Statistics 17: Categorical Cross Tabulation with Formulas (9:49)
Excel Statistics 18: Pareto Chart for Categorical Data See how to create (8:25)
Excel Statistics 24: Quantitative Freq. Dist. w Pivot Table (10:04)
Excel Statistics 25: % Freq. Dist.& Histogram w Pivot Table (10:02)
Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running (8:29)
Excel Statistics 27: Dot Plot Chart w REPT & COUNTIF functions (8:58)
Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions (7:27)
Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table (5:43)
Excel Statistics 30: Scatter Diagram for 2 Quantitative Variables (7:02) 
Probability is the mathematical basis for inferential statistics.
Excel Statistics 50: Probability I

 Please Share 

Hypothesis Testing is a logical approach to inferential statistics.
Excel Statistics 88: Confidence Interval & Hypothesis Tests (38:41)

Excel Statistics 92: Hypothesis Test T Distribution (6:46)
Excel Statistics 93: Hypothesis Test Proportions (7:18)

Regression is a special application of inferential statistics.

Correlation is an extension of regression.