06/2016

3:19 hours

Introduction

Welcome

Using exercise files

1. Excel Statistics Essentials

Excel functions

Excel statistical functions

Excel graphics

Excel Analysis ToolPak

2. Understanding Data

Types of data

Independent and dependent variables

3. Probability

Probability definitions

Calculating probability

Counting rules and probability

Conditional probability

Bayesian probability

4. Central Tendency

Mean and its properties

Median

Mode

5. Variability

Variance

Standard deviation

6. Distributions

What is a distribution?

Organize and graph a distribution

Graph frequency polygons

Properties of distributions

Probability distributions

7. Normal Distributions

The normal distribution family

The standard normal distribution

Standard normal distribution probability

Normal distribution graph

8. Sampling Distributions

Sampling distribution overview

Central limit theorem

Meet the t-distribution

9. Estimation

Confidence in estimation

Calculating confidence intervals

10. Hypothesis Testing

The logic of hypothesis testing

Type I errors and type II errors

11. Mean Hypothesis Testing

Applying the central limit theorem

The z-test and the t-test

12. Variance Hypothesis Testing

Chi-square distribution

13. z and t Hypothesis Testing

Understanding independent samples

Distributions for independent samples

The z-test for independent samples

The t-test for independent samples

14. Matched Sample Hypothesis Testing

Matched samples

Distributions for matched samples

The t-test for matched samples

15. F-Test Hypothesis Testing

F-test overview

16. Analysis of Variance

More than two parameters

ANOVA

Applying ANOVA

17. After the Analysis of Variance

Types of post-ANOVA testing

Post-ANOVA planned comparisons

18. Repeated Measures Testing

What is repeated measures?

Perform repeated measures ANOVA

19. Hypothesis Testing with Two Factors

Statistical interactions

Two-factor ANOVA

Perform two-factor ANOVA

20. Regression

Regression line overview

Variation around the regression line

Analysis of variance for regression

Multiple regression analysis

21. Correlation

Up next

Correlation coefficient

Correlation and regression

Hypothesis testing with correlation

Conclusion

Up next