Excel Statistics Essential Training: 1

Introduction

• What is data?
• The big picture

• Using Excel functions
• Understanding Excel statistics functions
• Working with Excel graphics
• Installing the Excel Analysis Toolpak

• Differentiating data types
• Independent and dependent variables

• Defining probability
• Calculating probability
• Understanding conditional probability

• The mean and its properties
• Working with the median
• Working with the mode

• Understanding variance
• Understanding standard deviation
• Z-scores

• Organizing and graphing a distribution
• Graphing frequency polygons
• Properties of distributions
• Probability distributions

• The standard normal distribution
• Meeting the normal distribution family
• Standard normal distribution probability
• Visualizing normal distributions

• Introducing sampling distributions
• Understanding the central limit theorem
• Meeting the t-distribution

• Confidence in estimation
• Calculating confidence intervals

• The logic of hypothesis testing
• Type I errors and Type II errors

• Applying the central limit theorem
• The z-test and the t-test

• The chi-squared distribution

• Understanding independent samples
• Distributions for independent samples
• The z-test for independent samples
• The t-test for independent samples

• Understanding matched samples
• Distributions for matched samples
• The t-test for matched samples

• Working with the F-test

• Testing more than two parameters
• Introducing ANOVA
• Applying ANOVA

• Types of post-ANOVA testing
• Post-ANOVA planned comparisons

• What is repeated measures?
• Applying repeated measures ANOVA

• Statistical interactions
• Two-factor ANOVA
• Performing two-factor ANOVA

• Understanding the regression line
• Variation around the regression line
• Analysis of variance for regression
• Multiple regression analysis

• Hypothesis testing with correlation
• Understanding correlation
• The correlation coefficient
• Correlation and regression

• Next steps