Data Analysis using Excel

Data Analysis using Excel

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

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...