Statistics
Excel Videos Lectures

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

 Please link to, use to educate and Share 11/30/22

Students are also using our Free Excel Statistics Lab Manual
It is really a Quick way to learn.

It is a stand alone but
was designed to use with our free

Quick Notes Statistics

Index
 Descriptive Statistics
 Probability
 Confidence Intervals
 Hypothesis Testing
 Regression
 Correlation

 

 

 

Tips and Tricks 4 min
 Improve Efficiency 13 min
Experimental Design 6 min
 Bad Data 35 min

 

Practice
  Tests & Answers

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

 

Appropriate Application
Choosing Appropriate Test 
 Application Tools
Projects
 Research Project
 Stastistics Lab Manuel

 

Related Statistics Stuff

1. Research Project Help
2. Statistics Internet Library 
 3. Free Statistics Textbook
4. Behavioral Science
5. Statistics Internet Library 

 

 

Statistics, Tests and Measurement, 4 Videos

Each lasts about 15 minutes and provide a subjective overview. 

 

Descriptive Statistics Topic Videos

01: Intro To Excel 2007 for Statistics (10:09)
02: Calculations, Operators, Formulas (10:13)
03: Data Analysis Sorting & Pivot Tables 9:55
04: Frequency Pivot Table Chart Basics (10:13)
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 15: Category Frequency Distribution w Pivot Table & (10:09)
Excel Statistics 16: Categorical Cross Tabulation with Pivot Table (7:50)
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 19: Grouping Categories w Formula & Pivot Table (6:35)
Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas (10:17)
Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas (10:04)
Excel Statistics 22: Histogram & Ogive Charts & % Cumulative (7:36)
Excel Statistics 23: Skew in Histograms (4:00)
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) 
Excel Statistics 31: Histogram using Data Analysis Add-in (8:53)
Excel Statistics 32: Frequency Distribution Summary (Pivot Table & (23:00)
Excel Statistics 33: Measures Of Location (15:37)
Excel Statistics 34: MEAN, MEDIAN, MODE (Averages) (10:52)
Excel Statistics 35: Weighted Mean & Geometric Mean
 Excel Statistics 35.2: Geometric Average V Arithmetic Mean -
Excel Statistics 36: Trimmed Mean (4:36)
Excel Statistics 37: PERCENTILE & QUARTILE
Excel Statistics 38: Data Analysis Add-in Rank & Percentile (8:06)
Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion (7:25)
Excel & Statistics 40: Range & Interquartile Range (Variability) (5:05)
Excel & Statistics 41: Sample Standard Deviation (Variability) (17:49)
Excel & Statistics 42: Coefficient of Variation (4:49)
Excel & Statistics 43: Data Analysis Add-in Descriptive Statistics (1:49)
Excel & Statistics 44: Skew & SKEW function (9:23)
Excel & Statistics 45: Z-Score (# Standard Deviations From Mean) (5:56)
 Excel & Statistics 46: Chebyshev's Theorem (9:33)
Excel & Statistics 47: Empirical Rule (Bell Shaped Curve) (16:44)
Excel & Statistics 48: Empirical Rule vs. Chebyshev's Theorem (3:23)
Excel & Statistics 49: Outliers & Box Plot with Median and Mean (21:46)

 
Probability the basis for inferential statistics.
Excel Statistics 50: Probability I
Excel Statistics 51: Probability II
Excel Statistics 53: Probability Laws
Excel Statistics 54: Joint Probability Table and More!
Excel Statistics 55: Probability Pivot Table
Excel Statistics 55.5: Bayes Theorem Posterior Probabilities
Excel Statistics 56: Discrete Probability Distributions (Basics)
Excel Statistics 57: Build Discrete Probability Distribution & Chart
Excel Statistics 58: Discrete Probability Chart with 2 Data Sets
Excel Statistics 59: Discrete Probability Mean & Standard
Excel Statistics 60: Budget Income Statement (Probability)
Excel Statistics 61: Stock Expected Return & Standard Deviation
Excel Statistics 62: Binomial Experiments & Probabilities
Excel Statistics 63: BINOMDIST & Mean & Standard Deviation
Excel Statistics 64: Cumulative BINOMDIST with IF Function
Excel Statistics 65: POISSON function Poisson Probability
Excel Statistics 66: Continuous Probability Distributions (Normal,
Excel Statistics 67: Uniform Probability Distributions
Excel Statistics 68: Normal (Bell) & Standard Normal
Excel Statistics 69: #1 Normal Probability Excel Functions &
Excel Statistics 70:cs 71: #3 Normal Probability Excel Functions & Area Charts" rel="nofollow" href="http://www.youtube.com/watch?v=E3qy9lahlv0"> Excel Statistics 71: #3 Normal Probability Excel Functions
Excel Statistics 72: Find X Given Normal Probabilities NORMINV
Excel Statistics 73: Exponential Probability EXPONDIST function
Excel Statistics 74: Taking a Sample with RAND & VLOOKUP
Excel Statistics 75: Point Estimates & Sample Error
Excel Statistics 76: Sampling Distribution Of Sample Mean
Excel Statistics 76: Sampling Distribution Of Sample Mean
Excel Statistics 77: Probabilities for Sampling Dist. Of the Sample Mean
Excel Statistics 78 Relationship Standard Error & Sample Size
Excel Statistics 79:

 
Confidence Intervals, a logical approach to inference
Excel Statistics 80: Confidence Interval Sigma Known (25:4 8)
Excel Statistics 81 Confidence Interval Sigma Known From Raw Data (8:36)
Excel Statistics 82: Confidence Interval Sigma Not Known TINV (11:41)
Excel Statistics 83: Confidence Interval For Advertising TINV function (5:14)
Excel Statistics 83: Confidence Interval For Advertising TINV
Excel Statistics 84 Confidence Interval Data Analysis Add-in (5:43)
Excel Statistics 85: Confidence Intervals for Proportions #1 (8:34)
Excel Statistics 86: Confidence Intervals for Proportions #2 (4:52)
 Excel Statistics 87: Sample Size for Confidence Intervals (7:55)

Please Share 

Hypothesis Testing, a logical approach to inference
Excel Statistics 88: Confidence Interval & Hypothesis Tests (38:41)
Excel Statistics 89: Hypothesis Testing With Critical Value & p-value (36:22)
Excel Statistics 90: NORMSINV for Critical Value NORMSDIST for P-value 6 examples (7:41)

Excel Statistics 91: TINV & TDIST functions for Critical Value and P-value 6 examples (10:59)

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.

Regression #1: Sample regression function (SRF) (7:30)
Regression #2: Ordinary Least Squares (OLS) (9:28)
Regression #3: Standard Error in Linear Regression (9:56)
Regression #4: ANOVA table in regression (9:13)

Correlation is an extension of regression.

Line of Best Fit and Correlation Coefficient using Excel (2:22)
Limits of correlation (9:39)
Spearman's Rank Correlation (6:29)