Data Management
Data Management
Contact Details
Contact Number: 09489322205
E-mail Address: [email protected]
Web Address: -
Consultation Schedule
Friday 8:00am-5:00pm
In addition, students will undergo pre-test and post-test short-examination. The pre-test questionnaires will
be given at the start of each rating period (Prelims, Midterms, Finals) while the post-test questionnaires will
be given at the end of each rating period. The results of the assessment will serve as one of the key
indicators that determine the effectiveness of this learning material. Thus, exemplifying honesty and
rectitude in this particular undertaking are highly appreciated and commendable.
Always keep connected and updated with announcements and relevant information concerning this course.
Lastly, do not hesitate to ask for assistance and raise your concerns to your instructor / professor.
B. Mathematics as a Tool
Introduction
Mathematics is a powerful tool for global understanding and communication. Using it, students can
make sense of the world and solve complex and real problems. Rethinking math in a global context offers
students a twist on the typical content that makes the math itself more applicable and meaningful for
students. For students to function in a global context, math content needs to help them get to global
competence, which is understanding different perspectives and world conditions, recognizing that issues
are interconnected across the globe, as well as communicating and acting in appropriate ways. In math,
this means reconsidering the typical content in a typical ways and showing students how the world consists
of situations, events and phenomena that can be sorted out using the right math tools. In this learning
material, you will find out how mathematics is applied as a powerful tool in our nature.
t-test
A t-test is a statistical test that is used to compare the means of two groups. It is often used in
hypothesis testing to determine whether a process or treatment actually has an effect on the
population of interest, or whether two groups are different from one another. Also, t-test uses means
and standard deviations of two samples to make a comparison and expressed by the formula:
𝑥1 − ̅̅̅
̅̅̅ 𝑥2
𝑡=
𝑆12 𝑆2
√( ) + ( 2)
𝑛1 𝑛1
Where:
̅̅̅1 =
𝑥 Mean of first set of values
𝑥2 =
̅̅̅ Mean of second set of values
𝑆1 = Standard deviaton of first set of values
𝑆2 = Standard deviation of second set of values
𝑛1 = Total number of values in the first set.
𝑛2 = Total number of values in second set.
Solution:
Step 1: Set up the hypothesis.
H0: There is no significant difference between the performance of male and
female students in spelling.
H1: There is a significant difference between the performance of the male and
female students in spelling.
Step 2: Set the level of Significance.
𝑎 = 0.05
𝑑𝑓 = 𝑛1 + 𝑛2 − 2
𝑑𝑓 = 4 + 4 − 2 = 6
𝑡. 05 = 2.4469 𝑡 − 𝑡𝑎𝑏𝑢𝑙𝑎𝑟 𝑣𝑎𝑙𝑢𝑒 𝑎𝑡 0.025 (Refer to the table below on page 10)
Step 3: Construct the following table for standard deviation and calculate the t-Test value.
𝑥 𝑥 − 𝑥̅ (𝑥 − 𝑥̅ )2 𝑥 𝑥 − 𝑥̅ (𝑥 − 𝑥̅ )2
7 0.5 0.25 1 1.5 2.25
2 -4.5 20.25 2 0.5 0.25
9 2.5 6.25 3 -0.5 0.25
8 1.5 2.25 4 1.5 2.25
𝑥̅1 = 6.5 ∑(𝑥 − 𝑥̅ )2 = 29 𝑥̅2 = 2.5 ∑(𝑥 − 𝑥̅ )2 = 5
𝑛1 = 4 𝑆1 = 3.11 𝑛2 = 4 𝑆2 = 1.29
𝑆12 = 9.67 𝑆22 = 1.67
Where:
𝑆𝑢𝑚 𝑜𝑓 𝑆𝑞𝑢𝑎𝑟𝑒𝑠 𝐵𝑒𝑡𝑤𝑒𝑒𝑛 𝐺𝑟𝑜𝑢𝑝𝑠 𝑆𝑆𝑏
𝑀𝑆𝐵 = =
𝐷𝑒𝑔𝑟𝑒𝑒𝑠 𝑜𝑓 𝐹𝑟𝑒𝑒𝑑𝑜𝑚 𝐵𝑒𝑡𝑤𝑒𝑒𝑛 𝐺𝑟𝑜𝑢𝑝𝑠 𝑑𝑓𝑏
𝑆𝑢𝑚 𝑜𝑓 𝑆𝑞𝑢𝑎𝑟𝑒𝑠 𝑊𝑖𝑡ℎ𝑖𝑛 𝐺𝑟𝑜𝑢𝑝𝑠 𝑆𝑆𝑤
𝑀𝑆𝑤 = =
𝐷𝑒𝑔𝑟𝑒𝑒𝑠 𝑜𝑓 𝐹𝑟𝑒𝑒𝑑𝑜𝑚 𝑊𝑖𝑡ℎ𝑖𝑛 𝐺𝑟𝑜𝑢𝑝𝑠 𝐷𝑓𝑏
𝑆𝑆𝑏 = 𝑘 − 1
Degree of freedom (df):
𝑆𝑆𝑤 = 𝑘(𝑛 − 1)
Where:
k = number of group samples
n = number of items per column (size of each sample)
Where:
SSt = total number of squares SSb = sum of the squares between
X = item value per column ∑ 𝑋𝑐 = sum of the values per column
N = total sample size SSw = sum of squares within
n = sample size
Solution:
Step 1: Set up the hypothesis.
H0: There is no significant difference in the weights of the women as a result of
the weight loss diet program.
H1: There is a significant difference in the weights of the women as a result of the
weight loss diet program.
Step 2: Set the level of Significance.
𝑎 = 0.05
𝑑𝑓𝑏 = 𝑘 − 1 = 3 − 1 = 2
𝑑𝑓𝑤 = 𝑘(𝑛 − 1) = 3(7 − 1) = 18
critical value at 2 & 18 from the F-table at 0.05 = 3.55 (Refer to the table on page 11)
Step 3: Solve for the F-ratio
Pearson r Coefficient
Statisticians devised quantitative ways to measure the association between two variables. The
strength of correlation is indicated by one coefficient of correlation. There are several coefficients of
correlation. One that is most commonly used is Pearson Product-Moment coefficients of correlation,
symbolized by r, named in honor of the statistician who did a lot of research on this area, Karl
Pearson (Belecina, Rene R. Et.al Statistics and Probability 2019).
• If an r-value of exactly +1indicates a perfect positive correlation. Positive values indicate
a relationship between x and y variables such that as values for one variable increase,
values of the other variable also increase.
• If an r-value of exactly -1 indicates a perfect negative relationship between two variables.
Negative values indicate a relationship between two variables such that as values of x
increases, values for y decreases.
• If there is no correlation or a weak correlation, r is close to 0. A value near zero means
that there is a random, nonlinear relationship between two variables.
The following summarizes the correlation coefficient and the strength of relationships:
0.0 no correlation, no relationship
±0.01 𝑡𝑜 ± 0.20 Very low correlation, almost negligible relationship
±0.21 𝑡𝑜 ± 0.40 Slight correlation, definite but small relationship
±0.41 𝑡𝑜 ± 0.70 Moderate correlation, substantial relationship
±0.71 𝑡𝑜 ± 0.90 High correlation, marked relationship
±0.91 𝑡𝑜 ± 0.99 Very high correlation, very dependable relationship
±1.00 Perfect correlation, perfect relationship
The formula for the Pearson Product Moment Coefficient of Correlation r is:
𝑛 ∑ 𝑥𝑦 − ∑ 𝑥 ∑ 𝑦
𝑟=
√[𝑛 ∑ 𝑥2 − (∑ 𝑥)2 ][𝑛 ∑ 𝑦2 − (∑ 𝑦)2 ]
Where,
r = the Pearson Product Moment Coefficient of Correlation
n = sample size
∑xy = the sum of product of x and y
∑x∑y = the product of the sum of ∑x and the sum of ∑y
∑x2 = sum of squares of x
∑y2 = sum of the squares of y
Solution:
Step 1: Set up the hypothesis.
H0: There is no significant relationship between the midterm grades and the final
grades of 10 students in Mathematics
H1: There is a significant relationship between the midterm grades and the final
grades of 10 students in Mathematics.
Step 2: Set the level of Significance.
𝑎 = 0.05
𝑑𝑓 = 𝑛 − 2 = 10 − 2 = 8
𝑟. 05 = 0.632 (Refer to the table on page 12)
x y x2 y2 xy
75 80 5,625 6,400 6,000
70 75 4,900 5,625 5,250
65 65 4,225 4,225 4,225
90 95 8,100 9,025 8,550
85 90 7,225 8,100 7,650
85 85 7,225 7,225 7,225
80 90 6,400 8,100 7,200
70 75 4,900 5,625 5,250
65 70 4,225 4,900 4,550
90 90 8,100 8,100 8,100
∑x=775 ∑y=815 ∑x2= 60,925 ∑y2= 67,325 ∑xy= 64,000
𝑥̅ = 77.5 𝑦̅ = 81.5
𝑛 ∑ 𝑥𝑦 − ∑ 𝑥 ∑ 𝑦
𝑟=
√[𝑛 ∑ 𝑥2 − (∑ 𝑥)2 ][𝑛 ∑ 𝑦 2 − (∑ 𝑦)2 ]
10(64,000) − (775)(815)
𝑟=
√[10(60,925) − (775)2 ][10(67,325) − (815)2 ]
8,375
𝑟=
√(8,625)(9,025)
8,375
𝑟=
8,822.73
𝒓 = 𝟎. 𝟗𝟒𝟗 (very high correlation, very dependable relationship)
Step 4: Use the following basis for arriving at the decision:
If the computed r value is greater than r tabular value, reject H0
2. A coffee shop serves different brands of coffee based on customers request. They would like to
determine the best coffee based on the number of orders. A sample of 8 days were taken and
here is the result:
Brand A Brand B Brand C
23 18 12
24 15 8
18 17 7
25 15 5
33 20 12
45 13 10
33 14 14
23 15 12
Is there a significant difference in the number of orders of the different brands of coffee at 0.05
level of significance?
3. A teacher would like to know if there is a linear correlation between a student’s classroom
performance and achievement in the national achievement test (NAT). At the end of academic
year, she gathers the data and came up with the following table. If the set level of significance a
= 0.05, is there a significant relationship between classroom performance and achievement in
the national achievement test (NAT)?
Achievement 98 96 94 88 91 77 86 71 59 63 84 79 75 72 86 85 71 93 90 62
GPA 3.6 2.7 3.1 4.0 3.2 3.0 3.8 2.6 3.0 2.2 1.7 3.1 2.6 2.9 2.4 3.4 2.8 3.7 3.2 1.6
References:
Manlulu, E.A. and Hipolito, L.M.M. (2019) A Course Module for Mathematics in the Modern World.
Baltazar, Ethel Cecille, et. al, Mathematics in the Modern World. C and E Publishing, Inc. 2018
Tolentino, Aurora Roslie P. et. al., Mathematics in the Modern World. Mutya Publishing House. 2018
Ariola, Marion Faye Q. et. al., Deal with the World of Today through Mathematics. Mutya Publishing House. 2018
Matira, Myrna D. (2016) Data Handling Essentials of Statistics and Probability for the 21st Century Learners
Belcina, R.R, Baccay, E.S, and Mateo, E.B (2019) Statistics and Probability
Broto, Antonio S. Statistics Made Simple (second edition)
Annex A – t-Table
Annex B – F-Table