How to Calculate a Correlation in Microsoft Excel – Pearson's r

About this tutorial:

Video duration: 00:02:14
Check out our brand-new Excel Statistics Text:

How to Calculate the Correlation using the Data Analysis Toolpak in Microsoft Excel is Covered in this Video (Part 1 of 2).

Correlation in Excel
Data Analysis Toolpak
Pearson’s r in Excel
Statistics in Excel

Video Transcript:
In this video we’ll take a look at how to calculate the correlation coefficient in Microsoft Excel. Now on your screen here we have two variables hours studied and that indicates the number of hours studied for an exam and then exam grade which is just a percentage grade on an exam….

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads