Audience
Anyone whose role demands the statistical analysis of datasets by using Microsoft Excel.
Prerequisites
A basic knowledge of Microsoft Excel.
Duration
Two days. Lecture presentations are supported by examples. Participants will gain hands-on experience of analysing data sets using Excel.
Course Objectives
After taking this course, participants should be able to:
- Understand the statistical concepts underlying the analysis of datasets.
- Import data sets into Microsoft Excel and ensure the data is valid.
- Use Excel to produce appropriate visualisations.
- Understand what is meant by hypothesis testing.
- Analyse datasets using appropriate statistical methods.
Course Content
Data Analysis and Statistical Concepts
Generic data analysis process
Sampling
Categorical and numeric variables
Frequency distributions, bar charts
Mean, median and mode
Standard deviation, variance
Percentiles, outliers
Boxplots
Working with Data
Importing data into Excel
Identifying invalid values
Dealing with missing values
Recoding and aggregation
Transforming and integrating data
Data Visualisation
Principles of good data visualisation
Pie charts, histograms
Grouped and stacked bar charts
Line graphs, scatterplots
Relationships between Numeric Variables
Association and correlation
Covariation, Pearson Correlation
Linear regression
Prediction using regression
Multiple regression
Hypothesis Testing
Probability
Confidence intervals
Null and alternative hypothesis
Statistical significance
Relationships between Categorical Variables
Chi-square distribution
Goodness of fit
Contingency tables
Testing for independence