 Excel Statistics Videos Lectures Thanks! Walter suggestions to antonw@ix.netcom.com Updated 7/1/21  Please link to, use to educate and Share Related Statistics Stuff   1. Research Project Help   2. Statistics Internet Library  3. Free Statistics Textbook   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.
 Index Descriptive Statistics Probability Confidence Intervals Hypothesis Testing Videos Tips and Tricks 4 min Improve Efficiency 13 min Experimental Design 6 min Bad Data 35 min Appropriate Application Choosing Appropriate Test  Application Tools Projects Research Project Stastistics Lab Manuel Practice  Tests & Answers Exam Help 1. 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.  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 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 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) Probability is the mathematical basis for inferential statistics. Excel Statistics 50: Probability I Excel Statistics 59: Discrete Probability Mean & Standard Excel Statistics 60: Budget Income Statement (Probability) Excel Statistics 61: Stock Expected Return & Standard Deviation Excel Statistics 72: Find X Given Normal Probabilities NORMINV Excel Statistics 73: Exponential Probability EXPONDIST function Confidence Intervals provide the logic for inferential statistics. 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 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 is a logical approach to inferential statistics. Excel Statistics 88: Confidence Interval & Hypothesis Tests (38:41) Excel Statistics 89: Hypothesis Testing With Critical Value & p-value (36:22) 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. Line of Best Fit and Correlation Coefficient using Excel (2:22) Limits of correlation (9:39) Spearman's Rank Correlation (6:29)