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

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

**CHAPTER 3: DESCRIBING DATA: NUMERICAL MEASURES**

**CHAPTER 4: DESCRIBING DATA: DISPLAYING AND EXPLORING DATA**

**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**

**CHAPTER 7: CONTINUOUS PROBABILITY DISTRIBUTIONS**

**CHAPTER 8: SAMPLING METHODS AND THE CENTRAL LIMIT THEOREM**

**CHAPTER 9: ESTIMATION AND CONFIDENCE INTERVALS**

**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**

**CHAPTER 12: ANALYSIS OF VARIANCE**

**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**

**CHAPTER 19: STASTISTICAL PROCESS CONTROL AND QUALITY MANAGEMENT**

Video | Topic |

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