Student | Hours Studied | Exam Score |
---|---|---|
John | 2 | 75 |
Emily | 3 | 85 |
David | 1 | 60 |
Sarah | 4 | 90 |
Mark | 5 | 95 |
Lisa | 2 | 70 |
Alex | 6 | 98 |
Emma | 3 | 82 |
Michael | 4 | 88 |
Olivia | 5 | 93 |
Table of Contents
ToggleEnter your data into an Excel spreadsheet. Place “Student” in A1, “Hours Studied” in B1, and “Exam Score” in C1. Then, input the corresponding data under each column.
=CORREL(B2:B11, C2:C11)
Press Enter to get the correlation value.
This correlation value will help you understand the strength and direction of the relationship between hours studied and exam scores.
The CORREL function calculates the Pearson correlation coefficient, which measures the strength and direction of the linear relationship between two sets of data. The result will be a number between -1 and 1:
After enabling the Data Analysis ToolPak, select “Regression” from the list and click “OK.”
This tool provides more comprehensive output than just the LINEST formula and includes statistics like coefficients, p-values, confidence intervals, and more.