Data Science: Expert Relationships In Data With Excel

Name: Data Science: Expert Relationships In Data With Excel
Rating: 4.6 (86 reviews)

Data Science: Relationships In Data With Microsoft Excel

Created bySix Sigma Academy Amsterdam (SSAA)

Last updated 2/2025

English

What you'll learn

Visualize a relationship with scatter plots
Quantify strength of relationship with Pearson correlation coefficient
Identify time lags in relationships
Quantify direction of relationship with Pearson correlation coefficient

Course content

1 section • 16 lectures • 1h 1m total length

Living on Mars2:10
Correlation theory7:35
Our data file1:39
Visualizing3:47
Visualize data with a scatter plot in Excel to explore correlation, swap axis data, add axis titles, and spot outliers before computing the correlation coefficient.
Single correlation2:38
Analysis Toolpak0:59
Correlation matrix3:21
Explore how to compute a correlation matrix in Excel using the Data Analysis Toolpak to assess relationships among multiple variables, including interpreting diagonal ones and notable coefficients.
Inspecting the correlation matrix3:18
Correlation traps5:05
Respect outliers7:23
EXERCISE CORRELATION1:44
Explore correlations by analyzing how a fictional Abc123 stock price relates to short-term rates, long-term rates, the S&P 500, unemployment, and crude oil prices in a simplified Excel data exercise.
SOLUTION CORRELATION3:07
Time lags8:01
EXERCISE TIME LAGS2:39
SOLUTION TIME LAGS5:25
BONUS LECTURE2:30

Requirements

Everyone can join

Description

Data Science: Relationships In Data With Excel

WHO IS THIS COURSE FOR?

Adam from Canada owns cryptocurrency. He wants to know: How does the price of my cryptocurrency relate to the interest rate?

Maria is a restaurant manager in Italy. She wants to know: How do the sales of my restaurant relate to the temperature?

Sandeep is sales manager at a bank in India. He wants to know: How do the amount of bank loan applications relate to the inflation numbers?

Once they know whether or not there is a relationship and if so, how strong it is and which direction it has, they can use that information to make better choices, with more confidence.

Our course equips you with a tool that allows you to quantify relationships. You will see if there is a linear relationship, which direction it has and how strong it is.

This course is designed to be broadly accessible. You do not need a specific background in math or statistics. All are welcome to join. We will use Microsoft Excel to teach you. You do not need previous experience with Excel and any Excel version is accepted.

SIX SIGMA ACADEMY AMSTERDAM (SSAA)

The training is provided by Six Sigma Academy Amsterdam (SSAA), an accredited provider of education. SSAA was set up by university lecturers from Holland to make academic quality education more broadly accessible, affordable and engaging.

We hope to welcome you to our course.

Who this course is for:

If you work with data