Excel guidelines Chapter 2: Summarising data using the frequency distribution View resources for chapter 2 Opening Microsoft Excel and Installing Analysis ToolPak Chapter 2 PDF Document (0.5Mb) Making a frequency distribution table Chapter 2 PDF Document (1.023Mb) Making a frequency distribution table for nominal data Chapter 2 PDF Document (0.723Mb) Making a grouped frequency distribution table Chapter 2 PDF Document (0.926Mb) Making a frequency distribution chart Chapter 2 PDF Document (0.577Mb) Making a frequency distribution graph Chapter 2 PDF Document (1.41Mb) Chapter 3: Summarising data using measures of central tendency How to calculate measures of central tendency Chapter 3 PDF Document (0.618Mb) Excel file Chapter 3 (0.017Mb) Chapter 4: Variability Making an auxiliary table for calculating the standard deviation Chapter 4 PDF Document (1.87Mb) How to calculate range and standard deviation Chapter 4 PDF Document (0.571Mb) Excel file Chapter 4 (0.01Mb) Chapter 5: Standardised scores, normal distribution, and probability How to calculate z-scores Chapter 5 PDF Document (1.61Mb) Excel file Chapter 5 (0.01Mb) Chapter 6: Using the t-test to measure the difference between independent groups How to calculate a t-test for independent samples Chapter 6 PDF Document (1.02Mb) Chapter 8: Non-parametric tests of difference between independent groups How to run a Mann-Whitney test in Excel Chapter 8 PDF Document (0.746Mb) Chapter 9: Using the t-test to measure change in related samples How to calculate a t-test for related samples Chapter 9 PDF Document (0.712Mb) Chapter 11: Improving predictions through the Pearson Correlation Coefficient Calculating the Pearson Correlation Coefficient with Excel Chapter 11 PDF Document (1.42Mb) Chapter 12: Improving predictions through non-parametric tests How to calculate the Spearman correlation Chapter 12 PDF Document (0.094Mb) How to calculate a chi-square test of independence Chapter 12 PDF Document (0.512Mb) Chapter 13: Using analysis of variance for multiple independent variables Running an ANOVA for independent groups of people Chapter 13 PDF Document (0.202Mb) Running an ANOVA for repeated measures Chapter 13 PDF Document (0.27Mb)