CHAPTER VIDEOS MUST BE COPIED INTO EXCEL

CHAPTER 5: A SURVEY OF PROBABILITY CONCEPTS

Video #29: How to build a contingency table with Pivot table (Length: 3:40)

Video #30: How to use Permut and Combin formulas (3:47)

Video #31: How to apply Bayes Theorem (Length: 4:33)

CHAPTER 6: DISCRETE PROBABILITY DISTRIBUTIONS

Video #32: How to build and graph discrete probability distribution (Length: 3:36)

Video #33: How to apply binomial distribution (Length: 4:48)

Video #34: How to apply hypergeometric distribution (Length: 4:41)

Video #35: How to apply Poisson.dist (Length: 3:31)

CHAPTER 7: CONTINUOUS PROBABILITY DISTRIBUTIONS

Video #36: Transforming continuous distribution to standard normal distribution (Length: 5:05)

Video #37: Using Norm.Dist to find probability in a normal distribution (Length: 5:21)

Video #38: How to apply norm.inv (Length: 2:52)

Video #39: How to apply norm.s.inv and norm.s.dist3 (Length: 4:36)

Video #40: How to use expondist and gammainv (Length: 5:28)

CHAPTER 8: SAMPLING METHODS AND THE CENTRAL LIMIT THEOREM

Video #46: Building a sampling distribution (Length: 5:43)

Video #47: Finding probability of a sample mean with normdist (Length: 3:31)

CHAPTER 9: ESTIMATION AND CONFIDENCE INTERVALS

Video #48: Confidence interval with Descriptive Statistics (Length: 2:46)

Video #49: Simulation of confidence intervals sigma known (Length: 4:01)

Video #50: Computing a confidence interval with confidence-t (Length: 2:04)

CHAPTER 10: ONE-SAMPLE TESTS OF HYPOTHESIS

Video #51: Conducting a one sample z test of the mean (Length: 4:27)

Video #52: Conducting a one sample t test of the mean (Length: 3:18)

Video #53: Computing beta and power (Length: 3:24)

CHAPTER 11: TWO-SAMPLE TESTS OF HYPOTHESIS

Video #54: Conducting a two sample t test assuming equal variance (Length: 5:49)

Video #55: Conducting a two sample z test independent populations (Length: 5:33)

Video #56: Conducting a two sample t test assuming unequal variance (Length: 5:57)

Video #57: Conducting a paired t test for two dependent samples (Length: 1:56)

CHAPTER 12: ANALYSIS OF VARIANCE

Video #58: Conducting an F test two sample for variances (Length: 4:04)

Video #59: Conducting a single factor ANOVA (Length: 3:30)

Video #60: Conducting ANOVA two factor with replication (Length: 3:57)

Video #61: Conducting ANOVA two factor without replication (Length: 3:56)

CHAPTER 13: CORRELATION AND LINEAR REGRESSION

Video #62: Computing correlation (Length: 2:50)

Video #63: How to run regression (Length: 4:55)

Video #64: How to transform data (Length: 4:36)

CHAPTER 14: MULTIPLE REGRESSION ANALYSIS

Video #65: How to build a multiple regression model (Length: 5:46)

CHAPTER 15: NONPARAMETRIC METHODS: NOMINAL LEVEL HYPOTHESIS TESTS

Video #66: Conducting a chi square test for observed vs. expected frequencies (Length: 5:11)

Video #67: Conducting a chi square test of independence for a contingency table (Length: 4:08)

CHAPTER 18: TIME SERIES AND FORECASTING

Video #68: Using least squares method to generate a trend line for a forecast (Length: 5:09)

Video #69: How to conduct a test for autocorrelation using Durbin Watson statistic (Length: 5:45)

Video #70: How to deseasonalize data to generate a trend adjusted equation (Length: 5:39)

CHAPTER 19: STASTISTICAL PROCESS CONTROL AND QUALITY MANAGEMENT

Video #71: How to build a Pareto chart (Length: 1:10)