Statistics and Probability11 - Q4 - Mod18
Statistics and Probability11 - Q4 - Mod18
Statistics and Probability11 - Q4 - Mod18
Probability
Quarter 4 – Module 18:
Calculating the Pearson’s
Sample Correlation Coefficient
Statistics and Probability – Grade 11
Alternative Delivery Mode
Quarter 4 – Module 18: Calculating the Pearson’s Sample Correlation Coefficient
First Edition, 2020
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
Development Team of the Module
Welcome to the Statistics and Probability for Senior High School Alternative
Delivery Mode (ADM) Module on Calculating the Pearson’s Sample Correlation
Coefficient!
This learning resource hopes to engage the learners into guided and independent
learning activities at their own pace and time. Furthermore, this also aims to help
learners acquire the needed 21st century skills while taking into consideration
their needs and circumstances.
In addition to the material in the main text, you will also see this box in the body of
the module:
As a facilitator, you are expected to orient the learners on how to use this module.
You also need to keep track of the learners' progress while allowing them to
manage their own learning. Furthermore, you are expected to encourage and assist
the learners as they do the tasks included in the module.
PAGE \* MERGEFORMAT 14
For the learner:
Welcome to the Statistics and Probability for Senior High School Alternative
Delivery Mode (ADM) Module on Calculating the Pearson’s Sample Correlation
Coefficient!
The hand is one of the most symbolical parts of the human body. It is often used to
depict skill, action, and purpose. Through our hands we may learn, create, and
accomplish. Hence, the hand in this learning resource signifies that as a learner,
you are capable and empowered to successfully achieve the relevant competencies
and skills at your own pace and time. Your academic success lies in your own
hands!
This module was designed to provide you with fun and meaningful opportunities
for guided and independent learning at your own pace and time. You will be
enabled to process the contents of the learning resource while being an active
learner.
What I Need to Know This will give you an idea of the skills or
competencies you are expected to learn in
the module.
PAGE \* MERGEFORMAT 14
What I Can Do This section provides an activity which will
help you transfer your new knowledge or
skill into real life situations or concerns.
1. Use the module with care. Do not put unnecessary mark/s on any part of
the module. Use a separate sheet of paper in answering the exercises.
2. Don’t forget to answer What I Know before moving on to the other activities
included in the module.
3. Read the instruction carefully before doing each task.
4. Observe honesty and integrity in doing the tasks and checking your
answers.
5. Finish the task at hand before proceeding to the next.
6. Return this module to your teacher/facilitator once you are through with it.
If you encounter any difficulty in answering the tasks in this module, do not
hesitate to consult your teacher or facilitator. Always bear in mind that you are
not alone.
We hope that through this material, you will experience meaningful learning
and gain deep understanding of the relevant competencies. You can do it!
PAGE \* MERGEFORMAT 14
What I Need to Know
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.
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.
PAGE \* MERGEFORMAT 14
What I Know
Directions: Choose the best answer to the given questions or statements. Write the
letter of your choice on a separate sheet of paper.
6. Based 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 X2 Y2 C.
X Y XY X2 Y2
1 2 2 13
3 8 20
2 8 1 22
0 1
2 11 PAGE \* MERGEFORMAT
9 14
5
2
5 9
B. D.
X Y X2 Y2 X Y XY X3 Y3
2 1 2 13
3 8 20
8 2
0 1 22
11 2 1
2 9 5
9 5
7. In the bivariate data on X 1 2 3
the right, which among the choices is the correct Y 18 13 7
completed table?
A. C.
X Y XY X2 Y2 X Y XY X2 Y2
1 18 18 1 324 1 1 1 324 18
2 13 26 4 169 8
2 1 4 169 26
3 7 21 9 64 3
6 39 68 14 557 3 7 9 64 21
6 3 14 557 68
B. D.
2 2 X 9Y XY X 2
Y2
X Y XY X Y
1 1 18 324 1 1 18 1 18 324
8 2 13 4 26 169
2 1 26 169 4
3 7 9 21 64
3
3 7 21 64 9 6 39 14 68 557
6 3 68 557 14
8. Using 9 the following summation values below,
what is the value of Pearson r ?
n=4 ∑ X = ∑ Y = 15 ∑ XY = 39 ∑ X 2= 30 ∑ Y 2= 65
10
A. -0.02
B. 0
C. 0.23
D. 1
9. Using the following summation values below, what is the value of Pearson
r?
n=3 ∑ X = 6 ∑ Y = 39 ∑ XY = 68 ∑ X 2= 14 ∑ Y 2= 557
A. -1
B. -0. 74
C. 0
D. 0.39
X 1 2 3
Y 5 9 8
PAGE \* MERGEFORMAT 14
10. Which of the following is the CORRECT completed table for the bivariate
data?
A. C.
X Y XY X2 Y2 X Y XY X2 Y2
1 5 1 25 5 1 5 5 1 25
2 9 4 81 18 2 9 18 4 81
3 8 9 64 24 3 8 24 9 64
6 22 14 170 47 6 22 47 14 170
B. D.
X Y XY X2 Y2 X Y XY X2 Y2
1 5 1 5 25 1 5 5 25 1
2 9 4 18 81 2 9 18 81 4
3 8 9 24 64 3 8 24 64 9
6 22 14 47 170 6 22 47 170 14
11. When you substitute all the summation ( ∑ ❑¿ values in the formula for
Pearson r, which among the choices is its best representation?
4 ( 47 )−(6)(22)
A. r =
√ [ 3 ( 14 )−22 ][ 3 ( 170 )−6 ]
2 2
4 (47)−(6)(22)
B. r =
√ [ 3 ( 14 )−6 ] [ 3 ( 170 )−22 ]
2 2
3 ( 47 )−(6)(22)
C. r =
√ [ 3 ( 14 )−22 ][ 3 ( 170 )−6 ]
2 2
3( 47)−(6)(22)
D. r =
√ [ 3 ( 14 )−6 ] [ 3 ( 170 )−22 ]
2 2
X 3 2 0 1 3
Y 10 24 21 15 28
13. Which of the following is the CORRECT completed table for the bivariate
data?
A. C. X Y XY X2 Y2
X Y XY X2 Y2 10 3 30 100 9
10 3 30 9 100 24 2 48 576 4
24 2 48 4 576 21 0 0 441 0
21 0 0 0 441 15 1 15 225 1
15 1 15 PAGE
1 \*225 28 3 84 784 9
MERGEFORMAT 14
28 3 84 9 784 98 9 177 2126 23
98 9 177 23 2126
B. X Y X2 Y2 XY2 X Y XY X2 Y2
D. 3 10 30 9 100 3 10 30 9 100
2 24 48 4 576 2 24 48 4 576
0 21 0 0 441 0 21 0 0 441
1 15 15 1 225 1 15 15 1 225
3 28 84 9 784 3 28 84 9 784
9 98 177 23 2126 9 98 177 23 2126
14. When you substitute all the summation ( ∑ ) values in the formula for
Pearson r, which among the choices is its best representation?
5 (177 )−(9)(98)
A. r =
√ [ 5 ( 23 )−9 ][ 5 ( 2126 )−98 ]
2 2
5 ( 177 ) +( 9)(98)
B. r =
√ [ 5 ( 23 )−9 ][ 5 ( 2126 )−98 ]
2 2
5 (2126 )−(9)(98)
C. r =
√ [ 5 ( 23 )−9 ][ 5 ( 2126 )−98 ]
2 2
5 ( 2126 )+(9)(98)
D. r =
√ [ 5 ( 23 ) +9 ][ 5 ( 2126 ) +98 ]
2 2
PAGE \* MERGEFORMAT 14
Lesson
Calculating the Pearson’s
1 Sample Correlation Coefficient
In the previous lesson, we learned about bivariate data and pairs of variables
that are related to each other. We 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
Directions: Identify the trend and strength of correlation of the scatter plots below.
Choose your answer from the choices inside the box.
1. 3.
2. 4.
PAGE \* MERGEFORMAT 14
5.
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.
1. ____________________________
x 1 2 3 4 5 6 ____________________________
y 5 10 10 15 25 30 ____________________________
2. ____________________________
x 1 3 11 10 6 9 ____________________________
y 14 6 12 11 10 9 ____________________________
3. ____________________________
x 10 8 6 4 2 1 ____________________________
y 16 19 26 24 29 36 ____________________________
PAGE \* MERGEFORMAT 14
Guide Questions:
1. How do you assess the bivariate data do determine the trend of its
correlation?
___________________________________________________________________________
___________________________________________________________________________
2. Do you think it is easy to determine the trend of its correlation? Why and
why not?
___________________________________________________________________________
___________________________________________________________________________
3. Is there a way to get the exact number that will represent its correlation?
___________________________________________________________________________
___________________________________________________________________________
What Is It
r =n ¿ ¿
X 1 2 3 4 5 6
Y 5 10 10 15 25 30
PAGE \* MERGEFORMAT 14
The next section will guide you on how to compute the Pearson product
moment correlation r.
STEPS SOLUTION
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
3.
a. Get the sum of all entries in the X Y XY X2 Y2
X column. This is ∑ X .
1 5 5 1 25
b. Get the sum of all entries in the 2 10 20 4 100
Y column. This is ∑ Y . 3 10 30 9 100
4 15 60 16 225
c. Get the sum of all entries in the
XY column. This is ∑ XY . 5 25 125 25 625
6 30 180 36 900
d. Get the sum of all entries in the
X2 column. This is ∑ X 2.
∑Y2
∑ X ∑ Y ∑ XY =
= = = ∑X 2
1,97
e. Get the sum of all entries in the 21 95 420 = 91 5
Y2 column. This is ∑ Y 2.
4. Substitute the values obtained Here n = 6 because there are six (6)
from Step 3 in the formula: pairs of values.
r =n ¿ ¿ r =n ¿ ¿
6(420)−(21)(95)
¿
√[ 6 ( 91 )−(21) ] [ 6 ( 1,975 )−(95) ]
2 2
PAGE \* MERGEFORMAT 14
2,520−1,995
¿
√ [ 546−441 ][ 11,850−9,025 ]
You may use your
calculator here! 525
¿
√ [ 105 ][ 2,825 ]
525
¿
√296,625
r ≈ 0.96395 or 0.96
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.
PAGE \* MERGEFORMAT 14
What’s More
X 1 3 4 5 7
Y 35 20 15 10 15
X Y XY X2 Y2
1 35 35
3 20 9 400
4 15 60 225
5 10 25
7 15 105 225
∑ X= ∑Y= ∑ XY = ∑X = 2
∑ Y 2=
20 ______ 310 ______ 2,175
r =n ¿ ¿
¿ 5(310)−(20)¿ ¿
¿ 1,550−¿ ¿ ¿
√[ ¿] ¿¿¿
¿ Be careful in
substituting the
¿−¿ ¿ √ [ ¿ ¿ ] [ ¿¿ ] ¿ values, make sure
they are correct.
¿−¿ ¿ √ ¿¿ ¿ Always double check.
¿−¿ ¿ ¿¿ ¿
r ≈−0.81
PAGE \* MERGEFORMAT 14
Activity 1.2 Complete Me!
Directions: Complete the table below. Then, fill in the blanks in the formula to
arrive at the computed Pearson r.
X Y XY X2 Y2
15 5 225
23 3
11 8 64
9 10 100
15 8 64
20 20 400
∑ X= ∑Y= ∑ XY = ∑ X 2= ∑ Y 2=
_____ _____ 842 1,581 _____
r =n ¿ ¿ n = ____
r =¿¿ (842)−¿ ¿
r ≈ 0.03
Activity 1.3 Let Me Guide You Because…
Directions: 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.)
1.
n=5 ∑ X= ∑ Y = 85 ∑ XY = ∑ X 2= 75 ∑ Y 2= 1,875
17 375
2.
n=8 ∑ X= ∑Y= ∑ XY =1,02 ∑ X 2= 816 ∑ Y 2= 1,725
72 105 0
3.
n=6 ∑ X= ∑ Y = 34 ∑ XY = 79 ∑ X 2= 734 ∑ Y 2= 364
22
Letter Box
Y T I L R
1 0.73 -0.14 0.31 0
DECODE…
Let me guide you because…
3 2 1
PAGE \* MERGEFORMAT 14
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 Quarterly Assessment
Score (X) Score (Y)
8 14
15 5
11 8
7 12
5 2
10 11
What I Can Do
PAGE \* MERGEFORMAT 14
Assessment
Directions: Choose the best answer to the given questions or statements. Write the
letter of your choice on a separate sheet of paper.
B. X Y XY X2 Y2 D. X Y XY X3 Y3
-1 15 -1 15
0 9 PAGE \* MERGEFORMAT 14 9
0
1 13 1 13
2 10 2 10
7. In the bivariate data on the right, which X 2 4 6
among the choices is the correct completed Y 1 3 5
table?
A. C.
X Y XY X2 Y2 X Y XY X2 Y2
2 1 2 4 1 2 1 2 4 1
4 3 12 16 9 4 3 12 16 9
6 5 30 36 25 6 5 30 36 25
B. 12 9 35 56 44 12 9 44 56 35 D.
X Y XY X2 Y2 X Y X2 Y2 XY
2 1 2 1 4 2 1 2 4 1
4 3 12 9 16 4 3 12 16 9
6 5 30 25 36 6 5 30 36 25
12 9 44 35 56 12 9 44 56 35
8. Using the given summation values below, what is the value of Pearson r?
n = 3 ∑ X = 6 ∑ Y = 30 ∑ XY = 60 ∑ X 2= 14 ∑ Y 2= 450
A. -0.06
B. 0
C. 0.11
D. 1
9. Using the given summation values below, what is the value of Pearson r?
n=5 ∑ X = ∑ Y = 15 ∑ XY = 90 ∑ X 2= 60 ∑ Y 2= 135
10
A. – 1
B. 0
C. 0.99
D. 1
For numbers 10-12, refer to the following X 1 2 3
bivariate data: Y 10 8 9
10.Which of the following is the CORRECT completed table for the bivariate data?
A. X Y XY X2 Y2 C. X Y XY X2 Y2
1 10 100 1 1 1 1 100 1 1
0 0 0
2 8 64 1 4 2 8 64 1 4
6 6
3 9 81 2 9 3 9 81 2 9
7 7
6 27 245 5 14 6 2 245 5 14
3 7 3
PAGE \* MERGEFORMAT 14
B. D.
X Y XY X2 Y2 X Y XY X2 Y2
1 10 10 1 100 1 10 10 1 100
2 8 16 4 64 2 8 16 4 64
3 9 27 9 81 3 9 27 9 81
6 27 53 14 245 6 27 53 245 14
11.When you substitute all the summation (∑ ❑¿ values in the formula for
Pearson r, which among the choices is its best representation?
3 ( 53 )−(6)(27)
A. r =
√ [ 3 ( 14 )−6 ] [ 3 ( 245 )−27 ]
2 2
3 ( 53 )−(6)(27)
B. r =
√ [ 3 ( 14 )+6 ][ 3 ( 245 )+ 27 ]
2 2
3 ( 27 )−(6)(27)
C. r =
√ [ 3 ( 14 )−6 ] [ 3 ( 245 )−27 ]
2 2
3 ( 53 )−(6)(27)
D. r =
√ [ 3 ( 6 ) −14 ] [ 3 ( 27 )−245 ]
2 2
5 ( 80 )−(6)(54)
B. r =
√ [ 5 ( 30 ) +6 ][ 5 ( 722 ) +54 ]
2 2
PAGE \* MERGEFORMAT 14
5 ( 80 )−(6)(54)
C. r =
√ [ 5 ( 6 ) −30 ][ 5 ( 54 )−722 ]
2 2
( 6 ) ( 54 )−5 ( 80 )
D. r =
√ [ 5 ( 30 )−6 ][ 5 ( 722 )−54 ]
2 2
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
Temperatur 26 28 24 28 23 24 27 32
e (OC)
Number of
Ice Creams 21 38 42 47 29 19 52 56
Sold
PAGE \* MERGEFORMAT 14
Answer Key
PAGE \* MERGEFORMAT 14
What I Know What’s In
1. D 6. C 11. D 1. strong negative correlation
2. A 7. A 12. B 2. no/negligible correlation
3. B 8. C 13. D 3. strong positive correlation
4. C 9. A 14. A
4. perfect positive correlation
5. perfect negative correlation
5. D 10. C 15. B
What’s New
1. Positive Correlation
As X values increase, the Y values also increase and vice versa.
2. No/Negligible Correlation
High values of one variable correspond to either high or low values of
another variable.
3. Negative Correlation
As X values increase, the Y values decrease and vice versa.
What’s More
Activity 1.1
X Y XY X2 Y2
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 ∑ XY ∑ X 2
= ∑Y= = = ∑ Y 2=
20 95 310 100 2,175
¿ 5310 ¿−20¿ 95¿ ¿
√[ 5 ( 100 ) −20 ¿¿¿ 2 ][ 5 ( 2,175 )−95 ¿ ¿¿ 2 ]
1,550−1,900
¿
√ [ 500−400 ][ 10,875−9,025 ]
−350
¿
√ [ 100 ][ 1,850 ]
−350
r=
√ 185,000
PAGE \* MERGEFORMAT 14
What’s More
Activity 1.2
X Y XY X2 Y2
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= ∑Y= ∑ XY = ∑ X 2= ∑ Y 2=
93 54 842 1,581 662
6 (842)−(93)(54)
r=
√ [ 6 ( 1,581 )−(93) ] [ 6 ( 662 )−(54) ]
2 2
PAGE \* MERGEFORMAT 14
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.
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/quiz-
worksheet-pearson-correlation-coefficient.html
PAGE \* MERGEFORMAT 14
For inquiries or feedback, please write or call: