Scribd
Upload
6 views3 pages

Student Scores Frequency Distribution

The document presents the scores of 33 students in a mathematics test, detailing their frequencies across various class intervals. Additionally, it provides the ages of 45 individuals in a colony, along with a grouped frequency distribution for both datasets. The data includes minimum, maximum, and range values for both scores and ages.

Uploaded by

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

Student Scores Frequency Distribution

The document presents the scores of 33 students in a mathematics test, detailing their frequencies across various class intervals. Additionally, it provides the ages of 45 individuals in a colony, along with a grouped frequency distribution for both datasets. The data includes minimum, maximum, and range values for both scores and ages.

Uploaded by

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

Q1.

The scores (out of 100) obtained by 33 students in a mathematics test are as follows: 69, 48, 84, 58, 48, 73, 83, 48, 66,
Represent this data in the form of a frequency

Students Scores Class Intervals Frequency Used Countifs function to cal


Student 1 69 46-50 3
Student 2 48 51-55 0
Student 3 84 56-60 3
Student 4 58 61-65 4
Student 5 48 66-70 13
Student 6 73 71-75 5
Student 7 83 76-80 0
Student 8 48 81-85 5
Student 9 66
Student 10 58 MINIMUM 48
Student 11 84 MAXIMUM 84
Student 12 66
Student 13 64
Student 14 71
Student 15 64
Student 16 66
Student 17 69 Frequency
Student 18 66 14
Student 19 83
Student 20 66 12
Student 21 69 10
Student 22 71
Student 23 81 8
Student 24 71 6
Student 25 73
Student 26 69 4
Student 27 66
2
Student 28 66
Student 29 64 0
46-50 51-55 56-60 61-65 66-70 71-75 76-80 81-85
Student 30 58
Student 31 64
Student 32 69
Student 33 69

Q2. Given below are the ages of 45 people in a colony. 33, 8, 7, 25, 31, 26, 5, 50, 25, 48, 56, 33, 28, 22, 15, 62, 59, 16, 14, 19,
Construct grouped frequency distribution for th

Students Scores
student 1 33 MINIMUM 5
student 2 8 MAXIMUM 63
student 3 7 RANGE 58
student 4 25
student 5 31 Class Interval Frequency
student 6 26 1 to 10 6
student 7 5 11 to 20 7
student 8 50 21 to 30 10
student 9 25 31 to 40 7
student 10 48 41 to 50 8
student 11 56 51 to 60 4
student 12 33 61 to 70 3
student 13 28
student 14 22
student 15 15
student 16 62
student 17 59
student 18 16
student 19 14
student 20 19
student 21 24
student 22 35
student 23 26
student 24 9
student 25 12
student 26 46
student 27 15
student 28 42
student 29 63
student 30 32
student 31 5
student 32 22
student 33 11
student 34 42
student 35 23
student 36 52
student 37 48
student 38 62
student 39 10
student 40 24
student 41 43
student 42 51
student 43 37
student 44 48
student 45 36
69, 48, 84, 58, 48, 73, 83, 48, 66, 58, 84, 66, 64, 71, 64, 66, 69, 66, 83, 66, 69, 71 81, 71, 73, 69, 66, 66, 64, 58, 64, 69, 69.
data in the form of a frequency distribution.

Used Countifs function to calculate the frequency

Scores
90
80
70
60
50
40
30
20
10
0
1 3 5 7 9 1 3 5 7 9 1 3 5 7 9 1 3
e nt ent ent ent ent nt 1 nt 1 nt 1 nt 1 nt 1 nt 2 nt 2 nt 2 nt 2 nt 2 nt 3 nt 3
ud tud tud tud tud ude ude ude ude ude ude ude ude ude ude ude ude
70 71-75 76-80 81-85 St S S S S St St St St St St St St St St St St

33, 28, 22, 15, 62, 59, 16, 14, 19, 24, 35, 26, 9, 12, 46, 15, 42, 63, 32, 5, 22, 11, 42, 23, 52, 48, 62, 10, 24, 43, 51, 37, 48, 36.
ped frequency distribution for the given data.

You might also like