0% found this document useful (0 votes)
95 views7 pages

Statistical Analysis of Student Scores

The document provides information about a problem set assignment involving statistical analysis tasks. The tasks include describing data through a frequency distribution table, tabulating exam scores into a cumulative frequency distribution table, and constructing a frequency distribution for students' stress ratings. The document gives the details and data needed to complete the assignments.

Uploaded by

Joy Lanaja
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
95 views7 pages

Statistical Analysis of Student Scores

The document provides information about a problem set assignment involving statistical analysis tasks. The tasks include describing data through a frequency distribution table, tabulating exam scores into a cumulative frequency distribution table, and constructing a frequency distribution for students' stress ratings. The document gives the details and data needed to complete the assignments.

Uploaded by

Joy Lanaja
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Republic of the Philippines

Central Philippines State University


Kabankalan City, Negros Occidental 6111
Website: www.cpsu.edu.ph
E-mail add: [email protected] or [email protected]
Contact No.: 09173015565 (Mobile); (034) 702-9903 (Landline)

Name: ________________________________________ Date: ____________ Score: __________

PROBLEM SET #2

Direction: Answer the items below as indicated. Kindly write your solution neatly and comprehensively
in a separate sheet of paper (s).

1. Describing Data. Identify the class width, class midpoints (CM) and class boundaries (LCB,
UCB) for the given frequency table. Show them in a frequency distribution table.

Absences Frequency
0-9 21
10-19 10
20-29 2
30-39 2
40-49 14

2. Tabulate the following exam scores of college students in General Mathematics class into a cumulative
frequency distribution.

84 62 69 66 90 54

80 79 78 57 81 65

90 73 90 63 77 56

82 74 85 71 78 71

84 87 58 71 78 65

70 76 52 84 86

89 79 85 74 92

77 97 94 62 85

Formulate 3 possible questions that can be answered by the cumulative frequency distribution
you have made. Show the solution for each question made. Use the table below as your guide to
completely fill-in all details and write the title of this table on the blank provided on Table 1. Kindly
present your complete solution for the table constructed.

Statistical Methods/Educational Statistics CPSU- Graduate School


Republic of the Philippines
Central Philippines State University
Kabankalan City, Negros Occidental 6111
Graduate School

Table 1. Exam Scores in General Mathematics


Class
Class Interval Frequency Class Midpoint
(Exam (f) Boundaries (x) RF RFP <CF >CF
Scores) LCB UCB

3. The 30 students’ scores (their ratings on the scale) are:


8, 7, 4, 10, 8, 6, 8, 9, 9, 7, 3, 7, 6, 5, 0, 9, 10, 7, 7, 3, 6, 7, 5, 2, 1, 6, 7, 10, 8, 8

It was known by the researcher that the higher the scores, the higher is the stress level
experienced by the students. Construct a frequency and percent (RFP) distribution showing the
frequency falling for each individual rating scale. Present and describe the information found in
your table comprehensively.

- ------------------------------------------------

Name: MERRY JOY LANAJA MANDALUPE Date: March 3, 2020 Score: __________

ANSWERS TO PROBLEM SET #2

1. Describing Data. Identify the class width, class midpoints (CM) and class boundaries (LCB,
UCB) for the given frequency table. Show them in a frequency distribution table.
Republic of the Philippines
Central Philippines State University
Kabankalan City, Negros Occidental 6111
Graduate School

Absences Class Lower Upper


Class Frequency Midpoint Class Class
Interval (X) Boundary Boundary
0-9 21 4.5 -0.5 9.5
10-19 10 14.5 9.5 19.5
20-29 2 24.5 19.5 29.5
30-39 2 34.5 29.5 39.5
40-49 14 44.5 39.5 49.5
i = 10 f = 49

Table 1. Frequency Table of Students Absences

2. Tabulate the following exam scores of college students in General Mathematics class into a
cumulative frequency distribution.
a. Determine the number of classes using Sturges’ formula:.
Solution: K= 1 + 3.322 log n
K= 1 + 3.322 log 45
K= 6.49 6
b. Solve for the class size.
 Solve for the range, R = max – min.
Range = 97 – 52
Range = 45
 Compute for C’ = R / K.
C’ = 45/6
C’ = 7.5 8
c. The lowest class limit I used is the smallest number I have in the data which is 52.
d. Therefore, the next lower limit will be 52 + 8 = 60, 60 + 8 = 68, 68 + 8 = 76, 76 + 8 = 82, and
82 + 8 = 90.
e. The upper limit of each class was then identified giving me the class intervals as shown in the
first column in the table 1.
f. Next, I tally the scores that fall under the certain class interval. It yields the data that falls
under the second column with a total frequency of 45.
g. To compute for the class boundaries, we simply subtract 0.5 from the lower limit to have the
lower class boundary and add 0.5 to the upper limit to have the upper class boundary.
*Solution as follows.

Lower Class Boundaries Class Interval Upper Class Boundaries

52 – 0.5 = 51.5 52 – 59 59 + 0.5 = 59.5


60 – 0.5 = 59.5 60 – 67 67 + 0.5 = 67.5
68 – 0.5 = 67.5 68 – 75 75 + 0.5 = 75.5
Republic of the Philippines
Central Philippines State University
Kabankalan City, Negros Occidental 6111
Graduate School

76 – 0.5 = 75.5 76 – 81 81 + 0.5 = 81.5


82 – 0.5 = 81.5 82 – 89 89 + 0.5 = 89.5
90 – 0.5 = 89.5 90 - 97 97 + 0.5 = 97.5

h. To solve for the midpoint, just add the lower limit and upper limit then divide it by 2.

Class Interval Solution Class Midpoint


52 – 59 (52 + 59)/2 = 55.5
60 – 67 (60 + 67)/2 = 63.5
68 – 75 (68 + 75)/2 = 71.5
76 – 81 (76 + 81)/2 = 79.5
82 – 89 (82 + 89)/2 = 87.5
90 - 97 (90 + 97)/2 = 95.5

i. The relative frequency is computed by dividing the total number of observations from the
frequency of the classes and multiplying the answer to 100 to get the relative frequency
percentage.

Class Frequency Solution to Relative Solution to Relative


Interval Relative Frequenc Relative Frequency Frequency
Frequency y Percentage Percentage
52 – 59 5 5/45 = 0.11 0.11*100= 11%
60 – 67 6 6/45 = 0.13 0.13*100= 13%
68 – 75 8 8/45 = 0.19 0.19*100= 19%
76 – 81 10 10/45 = 0.22 0.22*100= 22%
82 – 89 10 10/45 = 0.22 0.22*100= 22%
90 - 97 6 6/45 = 0.13 0.13*100= 13%

j. The cumulative frequency can be computed by simply adding the frequency of the lowest
class to the frequency of the next class until the frequency of the highest class interval which
is equal to the total number of observation for the less than cumulative frequency and for
greater than cumulative frequency, we simply add also the frequency but this time we begin
from the highest class interval to the lowest class interval which should be equal also to the
number of observation. Solution is shown in the next page.

Class Frequency Solution to <CF <CF Solution to >CF >CF


Interval
52 – 59 5 5+0= 5 40 + 5 = 45
60 – 67 6 5 + 6 = 11 34 + 6 = 40
68 – 75 8 11 + 8 = 19 26 + 8= 34
Republic of the Philippines
Central Philippines State University
Kabankalan City, Negros Occidental 6111
Graduate School

76 – 81 10 19 + 10 = 29 16 + 10 = 26
82 – 89 10 29 + 10 = 39 6 + 10 = 16
90 - 97 6 39 + 6 = 45 6+0= 6

Below is the summary table where I was able to supply with the information needed from what
I’ve solved from the previous steps.
Class Interval Frequency Class Class
(Exam (f) Boundaries Midpoint
Scores) LCB UCB (x) RF RFP <CF >CF

52 – 59 5 51.5 59.5 55.5 0.11 11% 5 45


60 – 67 6 59.5 67.5 63.5 0.13 13% 11 40
68 – 75 8 67.5 75.5 71.5 0.19 19% 19 34
76 – 81 10 75.5 81.5 79.5 0.22 22% 29 26
82 – 89 10 81.5 89.5 87.5 0.22 22% 39 16
90 - 97 6 89.5 97.5 95.5 0.13 13% 45 6
i=8 f = 45 1.00 100%

Table 2. Cumulative Frequency Table of Students’ Scores in General Mathematics Exam

Questions:

i. How many students got a score above 75?


Answer: Since we are looking for those who scored above 75, we can easily answer it using
the more than cumulative frequency (>CF) column and by simply looking at the class interval
above the mark 75, 76 – 81 class interval specifically, there are 26 students who scored
above 75.

ii. How many students scored 75 and below?


Answer: There are 19 students who scored 75 and below, using the table, go to the less than
cumulative formula (<CF) and look for the 75 score. The <CF in the interval were the score
75 belong is 19. Therefore, there are 19 students scored 75 or less than 75.

iii.How many scored less than or equal to 60?


Answer: Since there are 11 under the less cumulative frequency of 60 – 67 interval, it is then
interpreted that there are 11 who scored less than or equal to the score of 60.
3. The 30 students’ scores (their ratings on the scale) are:
8, 7, 4, 10, 8, 6, 8, 9, 9, 7, 3, 7, 6, 5, 0, 9, 10, 7, 7, 3, 6, 7, 5, 2, 1, 6, 7, 10, 8, 8

It was known by the researcher that the higher the scores, the higher is the stress level
experienced by the students. Construct a frequency and percent (RFP) distribution showing the
frequency falling for each individual rating scale. Present and describe the information found in
your table comprehensively.
Republic of the Philippines
Central Philippines State University
Kabankalan City, Negros Occidental 6111
Graduate School

a. Determine the number of classes using Sturges’ formula:.


Solution: K= 1 + 3.322 log n
K= 1 + 3.322 log 30
K= 5.91 6
b. Solve for the class size.
 Solve for the range, R = max – min.
Range = 10 – 0
Range = 10
 Compute for C’ = R / K.
C’ = 10/6
C’ = 1.67 2
c. The lowest class limit I used is the smallest number I have in the data which is 0.
d. Therefore, the next lower limit will be 0 + 2 = 2, 2 + 2 = 4, 4 + 2 = 6, 6 + 2 = 8, and
8 + 2 = 10.
e. The upper limit of each class was then identified giving me the class intervals as shown in the
first column in the table 1.
f. Next, I tally the scores that fall under the certain class interval. It yields the data that falls
under the second column with a total frequency of 30.
g. To compute for the class boundaries, we simply subtract 0.5 from the lower limit to have the
lower class boundary and add 0.5 to the upper limit to have the upper class boundary.
*Solution as follows.

Lower Class Boundaries Class Interval Upper Class Boundaries

0 – 0.5 = -0.5 52 – 59 1 + 0.5 = 1.5


2 – 0.5 = 1.5 60 – 67 3 + 0.5 = 3.5
4 – 0.5 = 3.5 68 – 75 5 + 0.5 = 5.5
6 – 0.5 = 5.5 76 – 81 7 + 0.5 = 7.5
8 – 0.5 = 7.5 82 – 89 9 + 0.5 = 9.5
10 – 0.5 = 9.5 90 - 97 11 + 0.5 = 11.5

h. To solve for the midpoint, just add the lower limit and upper limit then divide it by 2.

Class Interval Solution Class Midpoint


0–1 (0 + 1)/2 = 0.5
2-3 (2 + 3)/2 = 2.5
4-5 (4 + 5)/2 = 4.5
6–7 (6 + 7)/2 = 6.5
8–9 (8 + 9)/2 = 8.5
10 – 11 (10 + 11)/2 = 10.5
Republic of the Philippines
Central Philippines State University
Kabankalan City, Negros Occidental 6111
Graduate School

i. The relative frequency is computed by dividing the total number of observations from the
frequency of the classes and multiplying the answer to 100 to get the relative frequency
percentage.
Class Frequency Solution to Relative Solution to Relative
Interval Relative Frequenc Relative Frequency Frequency
Frequency y Percentage Percentage
0–1 2 2/30 = 0.06 0.06*100= 6%
2-3 3 3/30 = 0.1 0.10*100= 10%
4-5 3 3/30 = 0.1 0.10*100= 10%
6–7 11 11/30 = 0.37 0.37*100= 37%
8–9 8 8/30 = 0.27 0.27*100= 27%
10 – 11 3 3/30 = 0.1 0.10*100= 10%

Below is the summary table where I was able to supply with the information needed from what
I’ve solved from the previous steps.

Class Interval Frequency Class Class


(Exam (f) Boundaries Midpoint
Scores) LCB UCB (x) RF RFP

0–1 2 -0.5 1.5 0.5 0.06 6%


2-3 3 1.5 3.5 2.5 0.1 10%
4-5 3 3.5 5.5 4.5 0.1 10%
6–7 11 5.5 7.5 6.5 0.37 37%
8–9 8 7.5 9.5 8.5 0.27 27%
10 – 11 3 9.5 11.5 10.5 0.1 10%
i=2 f = 30 1.00 100%
Table 3. Frequency Table of Student’s Stress Level

The table above shows that the highest stress level interval is at 10 – 11 where it has a
frequency of 3 which means that 10 % of the students identify that the stress they experienced is
at the highest level. In such case, the lowest interval is found to be at 0 – 1 level which also shows
that this is the lowest in frequency, which can be interpreted that there are only 6% of the total
observation experienced no stress to level one stress. It can also be concluded that stress level at
6 -7 is very common among the students, having 37% of the students experienced this stress
level.

You might also like