Chapter |
Description |
Excel |
SPSS |
1 |
Calculating descriptive statistics (average, spread, shape, histogram) |
||
2 |
Calculating descriptive statistics (average, spread, shape, histogram) |
||
3 |
Solving normal distribution problems using Excel and SPSS |
||
|
Solving Student’s t distribution problems using Excel and SPSS |
||
|
Solving F distribution problems using Excel and SPSS |
||
|
Solving chi-square distribution problems using Excel and SPSS |
||
4 |
Creating a random sample from a population distribution: normal, non-normal |
||
5 |
Parametric data - confidence interval and hypothesis testing - one sample t-test |
||
|
Parametric data - confidence interval and hypothesis testing - two sample t-tests (independent) |
||
|
Parametric data - confidence interval and hypothesis testing - two sample t-tests (dependent) |
||
6 |
Introduction to hypothesis testing |
||
7 |
Parametric data – check for normality |
||
|
Parametric data - confidence interval and hypothesis testing - one sample t-test |
||
|
Parametric data - confidence interval and hypothesis testing - two sample t-tests (independent) |
||
|
Parametric data - confidence interval and hypothesis testing - two sample t-tests (dependent) |
||
8 |
Chi-square test of association (independence) |
||
|
Chi-square test for proportions (independent) |
||
|
Chi-square test for proportions (dependent McNemar) |
||
|
Non-parametric - Sign test |
||
|
Non-parametric - Wilcoxon paired samples test |
||
|
Non-parametric - Mann-Whitney U test for independent samples |
||
9 |
Regression analysis - fitting a regression line and measuring fit |
||
|
Regression analysis - fitting a prediction interval for regression |
||
10 |
Time series - fitting a Trend line |
||
|
Time series - fitting a Prediction interval |
||
|
Time series - decomposition |
||
11 |
Time series - moving averages |
||
|
Time series - exponential smoothing |
||
|
Time series - double exponential smoothing |
||
|
Time series - Holt-Winters method |
||
|
|
|
|