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

Thứ Hai, 28/10/2024

admin

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

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

CHAPTER 3: DESCRIBING DATA: NUMERICAL MEASURES

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

CHAPTER 4: DESCRIBING DATA: DISPLAYING AND EXPLORING DATA

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

CHAPTER 5: A SURVEY OF PROBABILITY CONCEPTS

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

CHAPTER 6: DISCRETE PROBABILITY DISTRIBUTIONS

Video	Topic
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	Topic
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.dist (Length: 4:36)
Video #40	How to use expondist and gammainv (Length: 5:28)

CHAPTER 8: SAMPLING METHODS AND THE CENTRAL LIMIT THEOREM

Video	Topic
Video #41	Generating random numbers- three methods (Length: 5:50)
Video #42	Simple random sample with replacement (Length: 2:16)
Video #43	Simple random sample without replacement (Length: 3:29)
Video #44	Generating a stratified random sample (Length: 3:15)
Video #45	Generating a systematic random sample (Length: 3:05)
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	Topic
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	Topic
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	Topic
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	Topic
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	Topic
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	Topic
Video #65	How to build a multiple regression model (Length: 5:46)

CHAPTER 15: NONPARAMETRIC METHODS: NOMINAL LEVEL HYPOTHESIS TESTS

Video	Topic
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	Topic
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)