This self-learning module (SLM) is Module 18 of Statistics and Probability for Grade 11 (Senior High School), Quarter 4. It was published under the Alternative Delivery Mode (ADM) by DepEd Region 4A CALABARZON, First Edition, 2021. It teaches you to compute Pearson’s sample correlation coefficient, or Pearson r: one number that tells exactly how strong the straight-line relationship between two variables is, and in which direction.
On this page 8 sections
What learners will learn
After going through this module, you are expected to:
- define Pearson’s sample correlation coefficient r;
- state the formula for Pearson’s sample correlation coefficient r;
- compute the Pearson’s sample correlation coefficient r; and
- apply and solve real-life problems using Pearson’s sample correlation coefficient.
What the module covers
The module has one lesson, “Calculating the Pearson’s Sample Correlation Coefficient.” It builds on the previous lesson on bivariate data and scatter plots. It has these parts:
- What I Know: a 15-item multiple-choice pretest.
- What’s In: a review where you name the trend and strength of five scatter plots, such as strong positive or perfect negative correlation.
- What’s New: three data tables where you tell, without a scatter plot, whether the correlation is positive, negative, or negligible.
- What is It: the definition, the formula, and a fully worked example.
- What’s More: four practice activities, from guided to independent.
- What I Have Learned, What I Can Do, the 15-item Assessment, an Additional Activity, and the Answer Key.
Key ideas: from scatter plot to Pearson r
A scatter plot shows the trend of a relationship. If the points rise from left to right, the correlation is positive. If they fall from left to right, it is negative. If they are scattered randomly, there is no or negligible correlation. But a scatter plot only lets you estimate how strong the relationship is.
Pearson’s sample correlation coefficient (Pearson r), written r, is a test statistic that measures the strength of the linear relationship between two variables. The formula is:
r = [n(ΣXY) − (ΣX)(ΣY)] / √{[n(ΣX²) − (ΣX)²][n(ΣY²) − (ΣY)²]}
Here n is the number of paired values, and ΣXY is the sum of the products of each X and Y pair. The value of r is always between −1 and 1, written −1 ≤ r ≤ 1. A positive r means a positive correlation, and a negative r means a negative one.
Worked example: study hours and test scores
The module’s example comes from Pag-asa National High School. Six Grade 11 students recorded their hours spent studying (X) and their test scores (Y).
Step 1. Construct a table with the columns X, Y, XY, X², and Y².
Step 2. Complete the table. Multiply each X by its Y, square each X, and square each Y.
Step 3. Get the sum of each column.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 5 | 5 | 1 | 25 |
| 2 | 10 | 20 | 4 | 100 |
| 3 | 10 | 30 | 9 | 100 |
| 4 | 15 | 60 | 16 | 225 |
| 5 | 25 | 125 | 25 | 625 |
| 6 | 30 | 180 | 36 | 900 |
| ΣX = 21 | ΣY = 95 | ΣXY = 420 | ΣX² = 91 | ΣY² = 1,975 |
Step 4. Substitute the sums and n in the formula. Here n = 6 because there are six pairs.
- Numerator: 6(420) − (21)(95) = 2,520 − 1,995 = 525
- Denominator: √{[546 − 441][11,850 − 9,025]} = √{[105][2,825]} = √296,625
- r ≈ 0.96
Since r is positive, there is a positive correlation between hours spent studying and test scores. The module asks you to round the final answer to two decimal places, and you may use a calculator. Interpreting the strength of r comes in the next module.
Practice activities
- Activity 1.1 Let Me Guide You!: fill in a partly completed table and formula. The answer is r ≈ −0.81.
- Activity 1.2 Complete Me!: complete a table of six pairs and the formula.
- Activity 1.3 Let Me Guide You Because…: compute r from three sets of given sums, then use a letter box to decode a hidden message.
- Activity 1.4 You Can Do It!: compute r for six students’ aptitude scores and quarterly assessment scores at Mapalad Integrated High School.
- What I Can Do: ask 10 classmates for their previous Mathematics and Science grades, then compute r between the two.
- Additional Activity: an ice cream vendor’s eight days of maximum temperature and ice creams sold. Make a scatter plot, compute r, and interpret the result. The key gives r ≈ 0.69: as temperature rises, sales also increase.
How to use this module
- Learners: Start with the pretest to see what you already know. Then go through the parts in order. Write all answers on a separate sheet of paper, not on the module. Show your solutions and double-check every value you substitute. Take the Assessment at the end, then check your work against the answer key honestly.
- Parents and facilitators: Help your child follow the four steps: construct, complete, sum, substitute. Let them use a calculator for the arithmetic.
- Teachers: The Notes to the Teacher ask you to have students round final answers to two decimal places, except for very small values near zero. Partial answers may be rounded to three or four decimal places. The symbol ≈ shows that r was rounded.
Before you check answers, review two items in the answer key. In What I Know item 3, n is the number of paired values, which is choice c, but the key lists B. In Assessment item 12, the given values give r = −3/6 = −0.5, which is choice d, but the key lists C.
Frequently asked questions
What grade and quarter is this Pearson r module for?
It is Statistics and Probability for Grade 11 (Senior High School), Quarter 4, Module 18. It was published by DepEd Region 4A CALABARZON as an Alternative Delivery Mode module, First Edition, 2021.
What is the formula for Pearson’s sample correlation coefficient?
r = [n(ΣXY) − (ΣX)(ΣY)] / √{[n(ΣX²) − (ΣX)²][n(ΣY²) − (ΣY)²]}, where n is the number of paired values. The result is always between −1 and 1.
What are the steps in computing Pearson r?
First, construct a table with columns X, Y, XY, X², and Y². Then complete the table and get the sum of each column. Finally, substitute the sums and n in the formula and simplify.
Does the module have an answer key?
Yes. It has answers for the pretest, activities, Assessment, and Additional Activity. Teachers should double-check pretest item 3 (the correct answer is c) and Assessment item 12 (the computed value is −0.5, choice d).
How many decimal places should the answer for r have?
The module asks learners to round the final value of r to two decimal places. Partial answers during computation may be rounded to three or four decimal places.
Full text of the module
The text below is a transcription of the PDF above, as printed.
Statistics and Probability Quarter 4 – Module 18: Calculating the Pearson’s Sample Correlation Coefficient
Senior High School
[illustration: students reading and studying outdoors and at home, with a teacher, a globe, and a child with a lantern]
GOVERNMENT PROPERTY NOT FOR SALE
Statistics and Probability – Grade 11 Alternative Delivery Mode Quarter 4 – Module 18: Calculating the Pearson’s Sample Correlation Coefficient First Edition, 2021
Republic Act 8293, section 176 states that: No copyright shall subsist in any work of the Government of the Philippines. However, prior approval of the government agency or office wherein the work is created shall be necessary for exploitation of such work for profit. Such agency or office may, among other things, impose as a condition the payment of royalties.
Borrowed materials (i.e., songs, stories, poems, pictures, photos, brand names, trademarks, etc.) included in this module are owned by their respective copyright holders. Every effort has been exerted to locate and seek permission to use these materials from their respective copyright owners. The publisher and authors do not represent nor claim ownership over them.
Published by the Department of Education Secretary: Leonor Magtolis Briones Undersecretary: Diosdado M. San Antonio
Printed in the Philippines by ________________________
Department of Education – Region 4A CALABARZON
Office Address: Gate 2 Karangalan Village, Brgy. San Isidro, Cainta, Rizal Telefax: 02-8682-5773/8684-4914/8647-7487 E-mail Address: lrmd.calabarzon@deped.gov.ph
Development Team of the Module
Writers: Ryan R. Sayson
Editors: Jerome A. Chavez, Nestor N. Sandoval, Josephine P. De Castro and Pelagia L. Manalang
Reviewers: Josephine V. Cabulong, Rey Mark R. Queaño, Maria Madel C. Rubia, Ermelo A. Escobinas, Michelle Anne L. Acesor, Allan Immanuel U. Ortiz, Luzviminda Cynthia Richelle F. Quintero, Jerome A. Chavez, and Generosa F. Zubieta
Illustrator: Jeewel L. Cabriga
Layout Artist: Ronnjemmele A. Rivera and Jeewel L. Cabriga
Management Team: Francis Cesar B. Bringas, Job S. Zape, Jr., Ramonito Elumbaring, Reicon C. Condes, Elaine T. Balaogan, Fe M. Ong-ongowan, Gerlie M. Ilagan, Antonio P. Faustino Jr., Imelda C. Raymundo, Generosa F. Zubieta, Louie L. Fulledo
Statistics and Probability
Quarter 4 – Module 18: Calculating the Pearson’s Sample Correlation Coefficient
Senior High School
Introductory Message
This Self-Learning Module (SLM) is prepared so that you, our dear learners, can continue your studies and learn while at home. Activities, questions, directions, exercises, and discussions are carefully stated for you to understand each lesson.
Each SLM is composed of different parts. Each part shall guide you step-by-step as you discover and understand the lesson prepared for you.
Pre-tests are provided to measure your prior knowledge on lessons in each SLM. This will tell you if you need to proceed on completing this module or if you need to ask your facilitator or your teacher’s assistance for better understanding of the lesson. At the end of each module, you need to answer the post-test to self-check your learning. Answer keys are provided for each activity and test. We trust that you will be honest in using these.
In addition to the material in the main text, Notes to the Teacher are also provided to our facilitators and parents for strategies and reminders on how they can best help you on your home-based learning.
Please use this module with care. Do not put unnecessary marks on any part of this SLM. Use a separate sheet of paper in answering the exercises and tests. And read the instructions carefully before performing each task.
If you have any questions in using this SLM or any difficulty in answering the tasks in this module, do not hesitate to consult your teacher or facilitator.
Thank you.
What I Need to Know
[illustration: hand pressing a button inside a circle]
This module was designed and written with you in mind. It is here to help you master computing Pearson’s sample correlation coefficient r. The scope of this module permits its use in many different learning situations. The language used recognizes the diverse vocabulary level of students. The concepts are arranged to follow the standard sequence of the learning area.
After going through this module, you are expected to:
- define Pearson’s sample correlation coefficient r;
- state the formula for Pearson’s sample correlation coefficient r;
- compute the Pearson’s sample correlation coefficient r; and
- apply and solve real-life problems using Pearson’s sample correlation coefficient.
Are you ready now to study about the calculation of Pearson’s sample correlation coefficient using your ADM module? Good luck and may you find it helpful.
What I Know
[illustration: hand holding a pencil inside a circle]
Choose the best answer to the given questions or statements. Write the letter of your choice on a separate sheet of paper.
Which of the following is a statistical method that measures the strength of the linear relationship between two variables?
a. z – value
b. scatterplot
c. testing hypothesis
d. Pearson’s sample correlation coefficientWhich of the following is the formula for Pearson’s sample correlation coefficient r?
A. r = [n(Σxy) − (Σx)(Σy)] / √{[n(Σx²) − (Σx)²][n(Σy²) − (Σy)²]}
B. r = [(Σxy) − (Σx)(Σy)] / √{[(Σx²) − (Σx)²][(Σy²) − (Σy)²]}
C. r = [n(Σxy) + (Σx)(Σy)] / √{[n(Σx²) + (Σx)²][n(Σy²) + (Σy)²]}
D. r = [(Σxy) + (Σx)(Σy)] / √{[(Σx²) + (Σx)²][(Σy²) + (Σy)²]}In the Pearson r, what does n represent?
a. sum of x-values
b. sum of square x-values
c. number of paired values
d. sum of the products of paired values x and yWhich of the following is the first step in computing Pearson’s sample correlation coefficient r?
a. Complete the table.
b. Construct the table.
c. Get the sum of all entries in all columns.
d. Substitute all the values obtained by all summations.Which of the following values CANNOT represent a correlation coefficient r?
a. -1
b. 0
c. 0.25
d. 1.001Based on the bivariate data below, which among the choices is the correctly constructed table?
| X | 2 | 8 | 11 | 9 |
|---|---|---|---|---|
| Y | 13 | 20 | 22 | 5 |
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 13 | 2 | |||
| 20 | 8 | |||
| 22 | 11 | |||
| 5 | 9 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 2 | 13 | |||
| 8 | 20 | |||
| 11 | 22 | |||
| 9 | 5 |
b.
| X | Y | X² | Y² |
|---|---|---|---|
| 2 | 13 | ||
| 8 | 20 | ||
| 11 | 22 | ||
| 9 | 5 |
d.
| X | Y | XY | X³ | Y³ |
|---|---|---|---|---|
| 2 | 13 | |||
| 8 | 20 | |||
| 11 | 22 | |||
| 9 | 5 |
- In the bivariate data on the right, which among the choices is the correct completed table?
| X | 1 | 2 | 3 |
|---|---|---|---|
| Y | 18 | 13 | 7 |
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 18 | 18 | 1 | 324 |
| 2 | 13 | 26 | 4 | 169 |
| 3 | 7 | 21 | 9 | 64 |
| 6 | 39 | 68 | 14 | 557 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 18 | 1 | 324 | 18 |
| 2 | 13 | 4 | 169 | 26 |
| 3 | 7 | 9 | 64 | 21 |
| 6 | 39 | 14 | 557 | 68 |
b.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 18 | 18 | 324 | 1 |
| 2 | 13 | 26 | 169 | 4 |
| 3 | 7 | 21 | 64 | 9 |
| 6 | 39 | 68 | 557 | 14 |
d.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 18 | 1 | 18 | 324 |
| 2 | 13 | 4 | 26 | 169 |
| 3 | 7 | 9 | 21 | 64 |
| 6 | 39 | 14 | 68 | 557 |
Using the following summation values below, what is the value of Pearson r?
n = 4 ΣX = 10 ΣY = 15 ΣXY = 39 ΣX² = 30 ΣY² = 65
a. -0.02
b. 0
c. 0.23
d. 1Using the following summation values below, what is the value of Pearson r?
n = 3 ΣX = 6 ΣY = 39 ΣXY = 68 ΣX² = 14 ΣY² = 557
a. -1
b. -0.74
c. 0
d. 0.39
For numbers 10-12, refer to the following bivariate data:
| X | 1 | 2 | 3 |
|---|---|---|---|
| Y | 5 | 9 | 8 |
- Which of the following is the CORRECT completed table for the bivariate data?
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 5 | 1 | 25 | 5 |
| 2 | 9 | 4 | 81 | 18 |
| 3 | 8 | 9 | 64 | 24 |
| 6 | 22 | 14 | 170 | 47 |
b.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 5 | 1 | 5 | 25 |
| 2 | 9 | 4 | 18 | 81 |
| 3 | 8 | 9 | 24 | 64 |
| 6 | 22 | 14 | 47 | 170 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 5 | 5 | 1 | 25 |
| 2 | 9 | 18 | 4 | 81 |
| 3 | 8 | 24 | 9 | 64 |
| 6 | 22 | 47 | 14 | 170 |
d.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 5 | 5 | 25 | 1 |
| 2 | 9 | 18 | 81 | 4 |
| 3 | 8 | 24 | 64 | 9 |
| 6 | 22 | 47 | 170 | 14 |
When you substitute all the summation (Σ) values in the formula for Pearson r, which among the choices is its best representation?
A. r = [4(47) − (6)(22)] / √{[3(14) − 22²][3(170) − 6²]}
B. r = [4(47) − (6)(22)] / √{[3(14) − 6²][3(170) − 22²]}
C. r = [3(47) − (6)(22)] / √{[3(14) − 22²][3(170) − 6²]}
D. r = [3(47) − (6)(22)] / √{[3(14) − 6²][3(170) − 22²]}What is the value of r?
a. 0.93
b. 0.72
c. 0.16
d. -0.16
For numbers 13-15, refer to the bivariate data below:
| X | 3 | 2 | 0 | 1 | 3 |
|---|---|---|---|---|---|
| Y | 10 | 24 | 21 | 15 | 28 |
- Which of the following is the CORRECT completed table for the bivariate data?
a.
| X | Y | XY | X2 | Y2 |
|---|---|---|---|---|
| 10 | 3 | 30 | 9 | 100 |
| 24 | 2 | 48 | 4 | 576 |
| 21 | 0 | 0 | 0 | 441 |
| 15 | 1 | 15 | 1 | 225 |
| 28 | 3 | 84 | 9 | 784 |
| 98 | 9 | 177 | 23 | 2126 |
b.
| X | Y | X2 | Y2 | XY2 |
|---|---|---|---|---|
| 3 | 10 | 30 | 9 | 100 |
| 2 | 24 | 48 | 4 | 576 |
| 0 | 21 | 0 | 0 | 441 |
| 1 | 15 | 15 | 1 | 225 |
| 3 | 28 | 84 | 9 | 784 |
| 9 | 98 | 177 | 23 | 2126 |
c.
| X | Y | XY | X2 | Y2 |
|---|---|---|---|---|
| 10 | 3 | 30 | 100 | 9 |
| 24 | 2 | 48 | 576 | 4 |
| 21 | 0 | 0 | 441 | 0 |
| 15 | 1 | 15 | 225 | 1 |
| 28 | 3 | 84 | 784 | 9 |
| 98 | 9 | 177 | 2126 | 23 |
d.
| X | Y | XY | X2 | Y2 |
|---|---|---|---|---|
| 3 | 10 | 30 | 9 | 100 |
| 2 | 24 | 48 | 4 | 576 |
| 0 | 21 | 0 | 0 | 441 |
| 1 | 15 | 15 | 1 | 225 |
| 3 | 28 | 84 | 9 | 784 |
| 9 | 98 | 177 | 23 | 2126 |
- When you substitute all the summation ( ∑ ) values in the formula for Pearson r, which among the choices is its best representation?
A. r = (5(177)−(9)(98)) / √[5(23)−9²][5(2126)−98²]
B. r = (5(177)+(9)(98)) / √[5(23)−9²][5(2126)−98²]
C. r = (5(2126)−(9)(98)) / √[5(23)−9²][5(2126)−98²]
D. r = (5(2126)+(9)(98)) / √[5(23)+9²][5(2126)+98²]
- What is the value of r?
a. 0 b. 0.02 c. 0.16 d. 0.61
Lesson 1: Calculating the Pearson’s Sample Correlation Coefficient
In the previous lesson, you learned about bivariate data and pairs of variables that are related to each other. You also learned how to construct the scatter plots of these bivariate data and determine the strength and direction of their association or relationship based on how the points are scattered. In this module, you will focus on the correlation of bivariate data. Check your readiness for this lesson by answering the following exercises.
What’s In
Identify the trend and strength of correlation of the scatter plots below. Choose your answer from the choices inside the box.
perfect positive correlation — perfect negative correlation strong positive correlation — strong negative correlation weak positive correlation — weak negative correlation no or negligible correlation
[chart: scatter plot; 1.] Values are not labeled on the chart.
[chart: scatter plot; 3.] Values are not labeled on the chart.
[chart: scatter plot; 2.] Values are not labeled on the chart.
[chart: scatter plot; 4.] Values are not labeled on the chart.
[chart: scatter plot; 5.] Values are not labeled on the chart.
How can we determine if there is a correlation between two variables: X and Y? By observing the scatter plot, you can tell if the correlation is positive, negative, or non-existent. If the points on the scatter plot closely resemble a straight line, then the correlation may be positive or negative depending on the trend of the line. It has a positive correlation if the line is increasing or rising from left to right. It has a negative correlation if the line is decreasing or it is trending downward from left to right. Meanwhile, the variables have no or negligible correlation if the points are scattered randomly on the scatter plot.
You can only estimate the direction and strength of the relationship between variables using a scatter plot. Is there a way to get the exact direction and strength of the relationship between variables? Just like any other measurement, correlation between two variables can be represented by a single number. This number can determine exactly whether the relationship is negative or positive. It can also tell exactly the degree or strength of the relationship. Let’s try the next activity.
The following tables show the bivariate data x and y. Without constructing a scatter plot, tell whether they have positive, negative, or no/negligible correlation. Then, briefly explain your answer.
What’s New
The following tables show the bivariate data x and y. Without constructing a scatter plot, tell whether they have positive, negative, or no/negligible correlation. Then, briefly explain your answer.
| x | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| y | 5 | 10 | 10 | 15 | 25 | 30 |
| x | 1 | 3 | 11 | 10 | 6 | 9 |
|---|---|---|---|---|---|---|
| y | 14 | 6 | 12 | 11 | 10 | 9 |
| x | 10 | 8 | 6 | 4 | 2 | 1 |
|---|---|---|---|---|---|---|
| y | 16 | 19 | 26 | 24 | 29 | 36 |
Guide Questions
- How do you assess the bivariate data to determine the trend of its correlation?
- Do you think it is easy to determine the trend of its correlation? Why or why not?
- Is there a way to get the exact number that will represent its correlation?
The scatter plot helps us visualize the relationship of the variables in a bivariate data. However, only the trend of the correlation can be exactly determined. We can only estimate the degree of the association whether the variables have weak, moderate, or high degree of relationship. Meanwhile, there is a statistical method that can be used to evaluate the strength of relationship between two quantitative variables.
What is It
The Pearson’s sample correlation coefficient (also known as Pearson r), denoted by r, is a test statistic that measures the strength of the linear relationship between two variables. To find r, the following formula is used:
r = [n(∑XY) − (∑X)(∑Y)] / √{[n(∑X²) − (∑X)²][n(∑Y²) − (∑Y)²]}
The correlation coefficient (r) is a number between -1 and 1 that describes both the strength and the direction of correlation. In symbol, we write -1 ≤ r ≤ 1.
Illustrative Example:
Teachers of Pag-asa National High School instilled among their students the value of time management and excellence in everything they do. The table below shows the time in hours spent in studying (X) by six Grade 11 students and their scores in a test (Y). Solve for the Pearson’s sample correlation coefficient r.
| X | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| Y | 5 | 10 | 10 | 15 | 25 | 30 |
The next section will guide you on how to compute the Pearson product moment correlation r.
STEPS and SOLUTION are laid out side by side in the original; they are given below one after another.
Step 1: Construct a table as shown on the right side.
| X | Y | XY | X2 | Y2 |
|---|---|---|---|---|
| 1 | 5 | |||
| 2 | 10 | |||
| 3 | 10 | |||
| 4 | 15 | |||
| 5 | 25 | |||
| 6 | 30 |
Step 2: Complete the table.
a. Multiply entries in the X and Y columns. Put them under the XY column.
b. Square all the entries in the X column. Put them under X2 column.
c. Square all the entries in the Y column. Put them under Y2 column.
| X | Y | XY | X2 | Y2 |
|---|---|---|---|---|
| 1 | 5 | 5 | 1 | 25 |
| 2 | 10 | 20 | 4 | 100 |
| 3 | 10 | 30 | 9 | 100 |
| 4 | 15 | 60 | 16 | 225 |
| 5 | 25 | 125 | 25 | 625 |
| 6 | 30 | 180 | 36 | 900 |
Step 3
a. Get the sum of all entries in the X column. This is ∑X.
b. Get the sum of all entries in the Y column. This is ∑Y.
c. Get the sum of all entries in the XY column. This is ∑XY.
d. Get the sum of all entries in the X2 column. This is ∑X².
e. Get the sum of all entries in the Y2 column. This is ∑Y².
| X | Y | XY | X2 | Y2 |
|---|---|---|---|---|
| 1 | 5 | 5 | 1 | 25 |
| 2 | 10 | 20 | 4 | 100 |
| 3 | 10 | 30 | 9 | 100 |
| 4 | 15 | 60 | 16 | 225 |
| 5 | 25 | 125 | 25 | 625 |
| 6 | 30 | 180 | 36 | 900 |
| ∑X= 21 | ∑Y= 95 | ∑XY= 420 | ∑X²= 91 | ∑Y²= 1,975 |
Step 4: Substitute the values obtained from Step 3 in the formula:
r = [n(∑XY) − (∑X)(∑Y)] / √{[n(∑X²) − (∑X)²][n(∑Y²) − (∑Y)²]}
Here n = 6 because there are six (6) pairs of values.
r = [n(∑XY) − (∑X)(∑Y)] / √{[n(∑X²) − (∑X)²][n(∑Y²) − (∑Y)²]}
= [6(420) − (21)(95)] / √{[6(91) − (21)²][6(1,975) − (95)²]}
= (2,520 − 1,995) / √{[546 − 441][11,850 − 9,025]}
= 525 / √{[105][2,825]}
= 525 / √296,625
r ≈ 0.96395 or 0.96
The value of r is a positive number. Therefore, we can say accurately that there is a positive correlation between hours spent in studying and their scores in a test.
Note: For consistency of our answer, round your final answer into two decimal places.
You may use your calculator here!
In the next module, we will interpret the strength of value of computed r and we will involve more real-life problems to solve using Pearson r. In the meantime, let’s focus on computing the Pearson’s sample correlation coefficient r.
Let’s try to answer all the activities that follow.
Notes to the Teacher
In the next part, the value of r will be interpreted given a scale. The numbers in the scale are expressed in two decimal places. Tell students that for consistency of your answer, round your final answer into two decimal places except for a very small number which is nearly zero. During computation, rounding of partial answer may be done in three to four decimal places. Also, the symbol ≈ will be used for r to indicate that the numbers were rounded off.
What’s More
Activity 1.1 Let Me Guide You!
In this activity, you will be guided on how to compute the Pearson’s sample correlation coefficient r. First, fill in the blank parts of the table with the correct values of each cell. After completing the table, get the sum of each column. Then, substitute the values obtained in the given formula. Finally, perform the indicated operations to calculate the value of r.
| X | 1 | 3 | 4 | 5 | 7 |
|---|---|---|---|---|---|
| Y | 35 | 20 | 15 | 10 | 15 |
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 35 | 35 | ||
| 3 | 20 | 9 | 400 | |
| 4 | 15 | 60 | 225 | |
| 5 | 10 | 25 | ||
| 7 | 15 | 105 | 225 | |
| ∑X= 20 | ∑Y= _______ | ∑XY= 310 | ∑X²= _______ | ∑Y²= 2,175 |
n = 5 (since there are 5 pairs of values)
r = [n(∑xy) − (∑x)(∑y)] / √{[n(∑x²) − (∑x)²][n(∑y²) − (∑y)²]}
= [5(310) − (20)()] / √{[5() − (20)²][5(2,175) − (____)²]}
= [1,550 − __] / √{[ − 400][10,875 − _______]}
= () / √[][_____]
= (_____) / √_____________
= (_____) / _____
r ≈ −0.81
Be careful in substituting the values, make sure they are correct. Always double check.
Activity 1.2 Complete Me!
Complete the table below. Then, fill in the blanks in the formula to arrive at the computed Pearson r.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 15 | 5 | 225 | ||
| 23 | 3 | |||
| 11 | 8 | 64 | ||
| 9 | 10 | 100 | ||
| 15 | 8 | 64 | ||
| 20 | 20 | 400 | ||
| ∑X= _____ | ∑Y= _____ | ∑XY= 842 | ∑X²= 1,581 | ∑Y²= _____ |
r = [n(∑xy) − (∑x)(∑y)] / √{[n(∑x²) − (∑x)²][n(∑y²) − (∑y)²]}
n = ____
r = [(842) − ()()] / √{[(1,581) − ()²][(____) − (____)²]}
Activity 1.3 Let Me Guide You Because…
The title of the activity is incomplete and to reveal the real message, follow the given directions. Using the given sum, substitute each to the formula of Pearson’s sample correlation coefficient. Then, compute the value of r. Choose your answer from the LETTER BOX below. Write the letter that corresponds to your answer on the DECODING AREA. (Show your solution.)
n = 5 | ∑X = 17 | ∑Y = 85 | ∑XY = 375 | ∑X² = 75 | ∑Y² = 1,875
n = 8 | ∑X = 72 | ∑Y = 105 | ∑XY = 1,020 | ∑X² = 816 | ∑Y² = 1,725
n = 6 | ∑X = 22 | ∑Y = 34 | ∑XY = 79 | ∑X² = 734 | ∑Y² = 364
Letter Box
| Y | T | I | L | R |
|---|---|---|---|---|
| 1 | 0.73 | -0.14 | 0.31 | 0 |
DECODE…
| Let me guide you because… | |||
|---|---|---|---|
| 3 | 2 | 1 |
r ≈ 0.03
Activity 1.4 You Can Do It!
In Mapalad Integrated High School, a guidance counselor believes that aptitude score is related to performance. The following sample data obtained from six students show their aptitude and performance score. Compute the Pearson r. Show your solution.
| Aptitude Score (X) | Quarterly Assessment Score (Y) |
|---|---|
| 8 | 14 |
| 15 | 5 |
| 11 | 8 |
| 7 | 12 |
| 5 | 2 |
| 10 | 11 |
What I Have Learned
Answer the following questions below:
- What do you call a statistical method that measures the strength of correlation between two variables?
- To find Pearson r, what is the formula to be used?
- Briefly discuss the steps in computing the Pearson’s sample correlation coefficient r.
What I Can Do
Ask your 10 classmates about their previous grade in Mathematics and Science subjects. Create a table for the data obtained from the survey and solve for Pearson’s sample correlation coefficient r between the grades in Mathematics and Science.
| Names | Previous Grade: Mathematics | Previous Grade: Science |
|---|---|---|
| 1. | ||
| 2. | ||
| 3. | ||
| 4. | ||
| 5. | ||
| 6. | ||
| 7. | ||
| 8. | ||
| 9. | ||
| 10. |
Assessment
Choose the best answer to the given questions or statements. Write the letter of your choice on a separate sheet of paper.
Which of the following is used to measure the strength of the association between bivariate data?
a. z – value
b. diagram
c. Pearson – b
d. Pearson’s sample correlation coefficientWhich of the following is the Pearson r formula?
A. $r = \dfrac{(\sum xy)-(\sum x)(\sum y)}{\sqrt{[(\sum x^2)-(\sum x)^2][(\sum y^2)-(\sum y)^2]}}$
B. $r = \dfrac{n(\sum xy)+(\sum x)(\sum y)}{\sqrt{[n(\sum x^2)+(\sum x)^2][n(\sum y^2)+(\sum y)^2]}}$
C. $r = \dfrac{n(\sum xy)-(\sum x)(\sum y)}{\sqrt{[n(\sum x^2)-(\sum x)^2][n(\sum y^2)-(\sum y)^2]}}$
D. $r = \dfrac{(\sum xy)+(\sum x)(\sum y)}{\sqrt{[(\sum x^2)+(\sum x)^2][(\sum y^2)+(\sum y)^2]}}$In the formula of Pearson r, what is the meaning of $\sum xy$?
a. sum of x-values
b. sum of square x-values
c. sum of the square of paired values x and y
d. sum of the products of paired values x and yIn computing Pearson r, which of the following is the next step after obtaining the sum of all entries in all columns in the table?
a. Construct a table.
b. Complete the table.
c. Simplify and compute for the value of r.
d. Substitute all the sum and n in the formula.Which of the following is the range of the correlation coefficient (r)?
a. $0 \le r \le 1$
b. $1 \le r \le -1$
c. $-1 < r < 1$
d. $-1 \le r \le 1$
e. [transcriber’s note: choice e. is blank in the document]In the given bivariate data, which among the choices is the correctly constructed table?
| X | -1 | 0 | 1 | 2 |
|---|---|---|---|---|
| Y | 10 | 13 | 9 | 15 |
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| -1 | 10 | |||
| 0 | 13 | |||
| 1 | 9 | |||
| 2 | 15 |
b.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| -1 | 15 | |||
| 0 | 9 | |||
| 1 | 13 | |||
| 2 | 10 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 10 | -1 | |||
| 13 | 0 | |||
| 9 | 1 | |||
| 15 | 2 |
d.
| X | Y | XY | X³ | Y³ |
|---|---|---|---|---|
| -1 | 15 | |||
| 0 | 9 | |||
| 1 | 13 | |||
| 2 | 10 |
- In the bivariate data on the right, which among the choices is the correct completed table?
| X | 2 | 4 | 6 |
|---|---|---|---|
| Y | 1 | 3 | 5 |
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 2 | 1 | 2 | 4 | 1 |
| 4 | 3 | 12 | 16 | 9 |
| 6 | 5 | 30 | 36 | 25 |
| 12 | 9 | 35 | 56 | 44 |
b.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 2 | 1 | 2 | 1 | 4 |
| 4 | 3 | 12 | 9 | 16 |
| 6 | 5 | 30 | 25 | 36 |
| 12 | 9 | 44 | 35 | 56 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 2 | 1 | 2 | 4 | 1 |
| 4 | 3 | 12 | 16 | 9 |
| 6 | 5 | 30 | 36 | 25 |
| 12 | 9 | 44 | 56 | 35 |
d.
| X | Y | X² | Y² | XY |
|---|---|---|---|---|
| 2 | 1 | 2 | 4 | 1 |
| 4 | 3 | 12 | 16 | 9 |
| 6 | 5 | 30 | 36 | 25 |
| 12 | 9 | 44 | 56 | 35 |
Using the given summation values below, what is the value of Pearson r?
n = 3 ∑X = 6 ∑Y = 30 ∑XY = 60 ∑X² = 14 ∑Y² = 450
a. -0.06
b. 0
c. 0.11
d. 1Using the given summation values below, what is the value of Pearson r?
n = 5 ∑X = 10 ∑Y = 15 ∑XY = 90 ∑X² = 60 ∑Y² = 135
a. – 1
b. 0
c. 0.99
d. 1
For numbers 10-12, refer to the following bivariate data:
| X | 1 | 2 | 3 |
|---|---|---|---|
| Y | 10 | 8 | 9 |
- Which of the following is the CORRECT completed table for the bivariate data?
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 10 | 100 | 10 | 1 |
| 2 | 8 | 64 | 16 | 4 |
| 3 | 9 | 81 | 27 | 9 |
| 6 | 27 | 245 | 53 | 14 |
b.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 10 | 10 | 1 | 100 |
| 2 | 8 | 16 | 4 | 64 |
| 3 | 9 | 27 | 9 | 81 |
| 6 | 27 | 53 | 14 | 245 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 10 | 100 | 10 | 1 |
| 2 | 8 | 64 | 16 | 4 |
| 3 | 9 | 81 | 27 | 9 |
| 6 | 27 | 245 | 53 | 14 |
d.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 10 | 10 | 1 | 100 |
| 2 | 8 | 16 | 4 | 64 |
| 3 | 9 | 27 | 9 | 81 |
| 6 | 27 | 53 | 245 | 14 |
When you substitute all the summation (∑) values in the formula for Pearson r, which among the choices is its best representation?
A. $r = \dfrac{3(53)-(6)(27)}{\sqrt{[3(14)-6^2][3(245)-27^2]}}$
B. $r = \dfrac{3(53)-(6)(27)}{\sqrt{[3(14)+6^2][3(245)+27^2]}}$
C. $r = \dfrac{3(27)-(6)(27)}{\sqrt{[3(14)-6^2][3(245)-27^2]}}$
D. $r = \dfrac{3(53)-(6)(27)}{\sqrt{[3(6)-14^2][3(27)-245^2]}}$What is the value of r?
a. 0.95
b. 0.75
c. -0.25
d. -0.5
For numbers 13-15, refer to the following bivariate data:
| X | -2 | 0 | 3 | 4 | 1 |
|---|---|---|---|---|---|
| Y | 8 | 5 | 8 | 13 | 20 |
- Which of the following is the CORRECT completed table for the bivariate data?
a.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| -2 | 8 | -16 | 4 | 64 |
| 0 | 5 | 0 | 0 | 25 |
| 3 | 8 | 24 | 9 | 64 |
| 4 | 13 | 52 | 16 | 169 |
| 1 | 20 | 20 | 1 | 400 |
| 6 | 54 | 80 | 722 | 30 |
b.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| -2 | 8 | 64 | 4 | -16 |
| 0 | 5 | 25 | 0 | 0 |
| 3 | 8 | 64 | 9 | 24 |
| 4 | 13 | 169 | 16 | 52 |
| 1 | 20 | 400 | 1 | 20 |
| 6 | 54 | 722 | 30 | 80 |
c.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| -2 | 8 | -16 | 4 | 64 |
| 0 | 5 | 0 | 0 | 25 |
| 3 | 8 | 24 | 9 | 64 |
| 4 | 13 | 52 | 16 | 169 |
| 1 | 20 | 20 | 1 | 400 |
| 6 | 54 | 80 | 30 | 722 |
d.
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| -2 | 8 | -16 | 64 | 4 |
| 0 | 5 | 0 | 25 | 0 |
| 3 | 8 | 24 | 64 | 9 |
| 4 | 13 | 52 | 169 | 16 |
| 1 | 20 | 20 | 400 | 1 |
| 6 | 54 | 80 | 722 | 30 |
When you substitute all the summation (∑) values in the formula for Pearson r, which among the choices is its best representation?
A. $r = \dfrac{5(80)-(6)(54)}{\sqrt{[5(30)-6^2][5(722)-54^2]}}$
B. $r = \dfrac{5(80)-(6)(54)}{\sqrt{[5(30)+6^2][5(722)+54^2]}}$
C. $r = \dfrac{5(80)-(6)(54)}{\sqrt{[5(6)-30^2][5(54)-722^2]}}$
D. $r = \dfrac{(6)(54)-5(80)}{\sqrt{[5(30)-6^2][5(722)-54^2]}}$What is the value of r?
a. – 0.27
b. 0.27
c. 0.48
d. 0.84
Additional Activities
An ice cream vendor records the maximum daily temperature and the number of ice creams he sells each day. An eight-day result is shown in the table below.
| Maximum Temperature (ºC) | 26 | 28 | 24 | 28 | 23 | 24 | 27 | 32 |
|---|---|---|---|---|---|---|---|---|
| Number of Ice Creams Sold | 21 | 38 | 42 | 47 | 29 | 19 | 52 | 56 |
[transcriber’s note: the table has no header row; its first row is used as the header above]
Follow the directions below:
- Display the data in a scatter plot and identify the trend of correlation.
- Compute the Pearson’s sample correlation coefficient r.
- Interpret the result of the data.
[transcriber’s note: this page is printed upside down in the source image; it is transcribed in upright reading order]
What’s More
Activity 1.1
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 1 | 35 | 35 | 1 | 1225 |
| 3 | 20 | 60 | 9 | 400 |
| 4 | 15 | 60 | 16 | 225 |
| 5 | 10 | 50 | 25 | 100 |
| 7 | 15 | 105 | 49 | 225 |
| ∑X = 20 | ∑Y = 95 | ∑XY = 310 | ∑X² = 100 | ∑Y² = 2,175 |
$r = \dfrac{5(310)-(20)(95)}{\sqrt{[5(100)-(20)^2][5(2{,}175)-(95)^2]}}$
$= \dfrac{1{,}550-1{,}900}{\sqrt{[500-400][10{,}875-9{,}025]}}$
$= \dfrac{-350}{\sqrt{[100][1{,}850]}}$
$= \dfrac{-350}{\sqrt{185{,}000}}$
What’s New
- Positive Correlation
As X values increase, the Y values also increase and vice versa. - No/Negligible Correlation
High values of one variable correspond to either high or low values of another variable. - Negative Correlation
As X values increase, the Y values decrease and vice versa.
What’s In
- strong negative correlation
- no/negligible correlation
- strong positive correlation
- perfect positive correlation
- perfect negative correlation
What I Know
- D 6. C 11. D
- A 7. A 12. B
- B 8. C 13. D
- C 9. A 14. A
- D 10. C 15. B
Answer Key
[transcriber’s note: this page is printed upside down in the source image; it is transcribed in upright reading order]
Assessment
- D 11. A
- C 12. C
- D 13. C
- D 14. A
- D 15. B
- A
- C
- B
- D
- B
Additional Activities
- Positive Correlation
[chart: scatter plot; Maximum Temperature and Number of Ice Creams Sold] Axes: x-axis ticks 0, 5, 10, 15, 20, 25, 30, 35; y-axis ticks 0, 10, 20, 30, 40, 50, 60. Values are not labeled on the chart.
- r ≈ 0.69
- As the temperature rises, the number of ice creams sold also increases.
What I Can Do
Computed Pearson r may vary.
What I Have Learned
Pearson’s sample correlation coefficient / Pearson r / Pearson
$r = \dfrac{n(\sum xy)-(\sum x)(\sum y)}{\sqrt{[n(\sum x^2)-(\sum x)^2][n(\sum y^2)-(\sum y)^2]}}$
Complete the table by getting all the sum for x, y, xy, x², y². Substitute all the sum in the formula and the value of n. Then, simplify and solve for the Pearson r.
What’s More
Activity 1.2
| X | Y | XY | X² | Y² |
|---|---|---|---|---|
| 15 | 5 | 75 | 225 | 25 |
| 23 | 3 | 69 | 529 | 9 |
| 11 | 8 | 88 | 121 | 64 |
| 9 | 10 | 90 | 81 | 100 |
| 15 | 8 | 120 | 225 | 64 |
| 20 | 20 | 400 | 400 | 400 |
| ∑X = 93 | ∑Y = 54 | ∑XY = 842 | ∑X² = 1,581 | ∑Y² = 662 |
$r = \dfrac{6(842)-(93)(54)}{\sqrt{[6(1{,}581)-(93)^2][6(662)-(54)^2]}}$
Activity 1.3
- r ≈ 1
- r ≈ 0.31
- r ≈ -0.14
Activity 1.4
r ≈ -0.08
Let me Guide You because… ILY
References
Books
Albacea, Zita VJ., Mark John V. Ayaay, Isidoro P. David, and Imelda E. De Mesa. Teaching Guide for Senior High School: Statistics and Probability. Quezon City: Commision on Higher Education, 2016.
Caraan, Avelino Jr S. Introduction to Statistics & Probability: Modular Approach. Mandaluyong City: Jose Rizal University Press, 2011.
De Guzman, Danilo. Statistics and Probability. Quezon City: C & E Publishing Inc, 2017.
Punzalan, Joyce Raymond B. Senior High School Statistics and Probability. Malaysia: Oxford Publishing, 2018.
Sirug, Winston S. Statistics and Probability for Senior High School CORE Subject A Comprehensive Approach K to 12 Curriculum Compliant. Manila: Mindshapers Co., Inc., 2017.
Ubarro, Arvie D., Josephine Lorenzo S. Tan, Renato Guerrero, Simon L. Chua, and Roderick V. Baluca. Soaring 21st Century Mathematics Precalculus. Quezon City, Philippines: Phoenix Publishing House Inc., 2016.
Online Resources
Project Maths Development Team. “Teaching & Learning Plans: The Correlation Coefficient.” Accessed May 23, 2020. https://www.projectmaths.ie/documents/T&L/CorrelationCoefficient.pdf
Study.com. “Pearson Correlation Coefficient: Formula, Example & Significance.” Accessed May 23, 2020. https://study.com/academy/practice/quizworksheet-pearson-correlation-coefficient.html
For inquiries or feedback, please write or call:
Department of Education – Bureau of Learning Resources (DepEd-BLR)
Ground Floor, Bonifacio Bldg., DepEd Complex Meralco Avenue, Pasig City, Philippines 1600
Telefax: (632) 8634-1072; 8634-1054; 8631-4985
Email Address: blr.lrqad@deped.gov.ph * blr.lrpd@deped.gov.ph
Leave a Reply