Hướng dẫn sử dụng Excel trong thống kê

CHAPTER 2: DESCRIBING DATA: FREQUENCY TABLES, FREQUENCY DISTRIBUTIONS, AND GRAPHIC PRESENTATIONS

VideoTopic
Video #01How to build a frequency table (Length: 5:13)
Video #02How to build horizontal bar chart (Length: 5:08)
Video #03How to build vertical bar chart (Length: 4:24)
Video #04How to build pie chart (Length: 4:11)
Video #05How to build line chart (Length: 1:59)
Video #06How to build joint frequency distribution-pivot table (Length: 4:51)
Video #07How to build frequency table using pivot table (Length: 4:05)
Video #08How to build frequency distribution using pivot (Length: 5:35)
Video #09How to build relative and cumulative frequency distribution (Length: 4:59)
Video #10How to build frequency polygon with pivot table (Length: 4:28)
Video #11How to build frequency polygon from frequency distribution (Length: 3:45)
Video #12How to build a histogram with Histogram chart feature (Length: 3:52)
Video #13How to build a cumulative frequency polygon with pivot table (Length: 5:29)

CHAPTER 3: DESCRIBING DATA: NUMERICAL MEASURES

VideoTopic
Video #14How to compute measures of central tendency (Length: 3:53)
Video #15How to compute weighted average (Length: 5:13)
Video #16How to calculate geometric mean (Length: 4:33)
Video #17How to calculate range (Length: 2:42)
Video #18How to calculate population variance and SD (Length: 3:51)
Video #19How to calculate variance and SD for a sample (Length: 2:13)
Video #20Using Descriptive Statistics to find measures of central tendency and dispersion (Length: 3:26)
Video #21How to compute arithmetic mean and SD for grouped data (Length: 4:05)
Video #22How to apply the Empirical Rule using Descriptive Statistics (Length: 4:16)

CHAPTER 4: DESCRIBING DATA: DISPLAYING AND EXPLORING DATA

VideoTopic
Video #23Building a Dot Plot (Length: 4:24)
Video #24How to build a scatter diagram (Length: 5:22)
Video #25How to build a stem-and-leaf display (Length: 5:09)
Video #26How to compute quartiles and percentiles (Length: 5:09)
Video #27How to build a boxplot in Excel (Length: 3:47)
Video #28How to use Descriptive Statistics to evaluate skewness (Length: 2:54)

CHAPTER 5: A SURVEY OF PROBABILITY CONCEPTS

VideoTopic
Video #29How to build a contingency table with Pivot table (Length: 3:40)
Video #30How to use Permut and Combin formulas (Length: 3:47)
Video #31How to apply Bayes Theorem (Length: 4:33)

CHAPTER 6: DISCRETE PROBABILITY DISTRIBUTIONS

VideoTopic
Video #32How to build and graph discrete probability distribution (Length: 3:36)
Video #33How to apply binomial distribution (Length: 4:48)
Video #34How to apply hypergeometric distribution (Length: 4:41)
Video #35How to apply Poisson.dist (Length: 3:31)

CHAPTER 7: CONTINUOUS PROBABILITY DISTRIBUTIONS

VideoTopic
Video #36Transforming continuous distribution to standard normal distribution (Length: 5:05)
Video #37Using Norm.Dist to find probability in a normal distribution (Length: 5:21)
Video #38How to apply norm.inv (Length: 2:52)
Video #39How to apply norm.s.inv and norm.s.dist (Length: 4:36)
Video #40How to use expondist and gammainv (Length: 5:28)

CHAPTER 8: SAMPLING METHODS AND THE CENTRAL LIMIT THEOREM

VideoTopic
Video #41Generating random numbers- three methods (Length: 5:50)
Video #42Simple random sample with replacement (Length: 2:16)
Video #43Simple random sample without replacement (Length: 3:29)
Video #44Generating a stratified random sample (Length: 3:15)
Video #45Generating a systematic random sample (Length: 3:05)
Video #46Building a sampling distribution (Length: 5:43)
Video #47Finding probability of a sample mean with normdist (Length: 3:31)

CHAPTER 9: ESTIMATION AND CONFIDENCE INTERVALS

VideoTopic
Video #48Confidence interval with Descriptive Statistics (Length: 2:46)
Video #49Simulation of confidence intervals sigma known (Length: 4:01)
Video #50Computing a confidence interval with confidence-t (Length: 2:04)

CHAPTER 10: ONE-SAMPLE TESTS OF HYPOTHESIS

VideoTopic
Video #51Conducting a one sample z test of the mean (Length: 4:27)
Video #52Conducting a one sample t test of the mean (Length: 3:18)
Video #53Computing beta and power (Length: 3:24)

CHAPTER 11: TWO-SAMPLE TESTS OF HYPOTHESIS

VideoTopic
Video #54Conducting a two sample t test assuming equal variance (Length: 5:49)
Video #55Conducting a two sample z test independent populations (Length: 5:33)
Video #56Conducting a two sample t test assuming unequal variance (Length: 5:57)
Video #57Conducting a paired t test for two dependent samples (Length: 1:56)

CHAPTER 12: ANALYSIS OF VARIANCE

VideoTopic
Video #58Conducting an F test two sample for variances (Length: 4:04)
Video #59Conducting a single factor ANOVA (Length: 3:30)
Video #60Conducting ANOVA two factor with replication (Length: 3:57)
Video #61Conducting ANOVA two factor without replication (Length: 3:56)

CHAPTER 13: CORRELATION AND LINEAR REGRESSION

VideoTopic
Video #62Computing correlation (Length: 2:50)
Video #63How to run regression (Length: 4:55)
Video #64How to transform data (Length: 4:36)

CHAPTER 14: MULTIPLE REGRESSION ANALYSIS

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

CHAPTER 15: NONPARAMETRIC METHODS: NOMINAL LEVEL HYPOTHESIS TESTS

VideoTopic
Video #66Conducting a chi square test for observed vs. expected frequencies (Length: 5:11)
Video #67Conducting a chi square test of independence for a contingency table (Length: 4:08)

CHAPTER 18: TIME SERIES AND FORECASTING

VideoTopic
Video #68Using least squares method to generate a trend line for a forecast (Length: 5:09)
Video #69How to conduct a test for autocorrelation using Durbin Watson statistic (Length: 5:45)
Video #70How to deseasonalize data to generate a trend adjusted equation (Length: 5:39)

CHAPTER 19: STASTISTICAL PROCESS CONTROL AND QUALITY MANAGEMENT

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