Anyone whose role demands the statistical analysis of datasets by using Microsoft Excel.
A basic knowledge of Microsoft Excel.
Two days. Lecture presentations are supported by examples. Participants will gain hands-on experience of analysing data sets using Excel.
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.
Data Analysis and Statistical Concepts
Generic data analysis process
Categorical and numeric variables
Frequency distributions, bar charts
Mean, median and mode
Standard deviation, variance
Working with Data
Importing data into Excel
Identifying invalid values
Dealing with missing values
Recoding and aggregation
Transforming and integrating data
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
Prediction using regression
Null and alternative hypothesis
Relationships between Categorical Variables
Goodness of fit
Testing for independence