Foundations in data analysis: techniques to unlock insights

Course Curriculum

Chapter 1: A short introduction to data and variables

Lecture 1: Understanding the four different types of variables

Lecture 2: Understanding the three different types of data sets

Chapter 2: Welcome to the wage data we will use in this course

Lecture 1: An overview of the wage data used in this course

Chapter 3: Microsoft Excel tips and tricks to speed up your analysis

Lecture 1: Excel tip: Navigating and selecting data quickly

Lecture 2: Excel tip: Filtering and sorting data

Lecture 3: Excel tip: The =AVERAGE function

Lecture 4: Excel tip: The =AVERAGEIF function

Lecture 5: Excel tip: The =AVERAGEIFS function

Chapter 4: Descriptive statistics: describing your data

Lecture 1: Using the Average or the Mean to describe your data

Lecture 2: Excel tip: How to calculate the average, median or mode

Lecture 3: Basic data visualizations for categorical variables (bar graphs and pie charts)

Lecture 4: Excel tip: Creating bar-graphs and pie-charts

Lecture 5: Comparing means and percentage contributions within categories

Lecture 6: Excel tip: Using "=COUNTIFS" to compare sub-categories

Lecture 7: Box-plots: an easy way to compare different samples or categories of data

Lecture 8: Excel tip: how to create and edit box-plots

Lecture 9: Using scatter-plots to identify a trend or relationship between two variables

Lecture 10: Excel tip: creating and editing scatter plots

Lecture 11: Using "correlation" to identify trends or relationships

Lecture 12: Excel tip: calculating the correlation coefficient

Lecture 13: Using Histograms (frequency distributions) to understand the shape of your data

Lecture 14: Excel tip: Creating and editing Histograms

Chapter 5: Measuring dispersion: the spread of data relative to the mean

Lecture 1: Why we often square values or differences in statistics to measure "spread"

Lecture 2: Calculating the variance of data

Lecture 3: Excel tip: calculating variance

Lecture 4: Calculating and using the Standard Deviation of the mean

Lecture 5: Excel tip: calculating Standard Deviation

Chapter 6: How to improve the "confidence" of our analysis

Lecture 1: Introducing Standard Normal Distributions (and why they are so cool)

Lecture 2: Central Limit theorem

Lecture 3: How to construct confidence intervals

Lecture 4: How to use confidence intervals in a graph

Lecture 5: Excel tip: calculating confidence intervals

Lecture 6: Excel tip: adding confidence intervals to bar graphs

Chapter 7: Hypothesis testing through t-tests

Lecture 1: Hypothesis testing: One Sample T-Test (calculating the t-value)

Lecture 2: Hypothesis testing: One Sample T-Test (finding the critical T-value)

Lecture 3: Hypothesis testing: One Sample T-Test (one tail vs two tail test)

Lecture 4: Hypothesis testing: One Sample T-Test (Using p-values)

Lecture 5: Hypothesis testing: One Sample T-Test (Using p-values in a one-tail test)

Lecture 6: Two sample t-test: calculating the t-value

Lecture 7: Two sample t-test: calculating the critical T-value

Lecture 8: Two sample t-test: the p-value approach

Chapter 8: Analysis overview

Lecture 1: Applying some of the techniques we have learnt to investigate wage differences