ABM 4
Performance Task
Name: Cheny N. Asna
Section: Section
Instructions: Read each instruction in every item.
1. Sample of 40 college students are considered for study and were categorized
according to year level. The data set is
Construct a frequency distribution for the data Then using MS Excel, construct a
bar chart, and a pie chart. Attach a screenshot of the excel application with the
graphs in this file. (20 points)
Note: Please upload the excel file you use in creating this exercise.
Class Tally Frequency Percentage
Freshman xxxxxxxxxxx 11 27.5
Sophomore xxxxxxxxx 9 22.5
Junior xxxxxxxxxxxx 12 30
Senior xxxxxxxx 8 20
TOTAL 100
BAR CHART
, PIE CHART
2. Every month, for the past two years, a poll was taken to measure the perceptions
of people who rate the president of the Philippines on his job performance. The
percentages of those who judged that performance as satisfactory are listed
here.
Compute for the mean, median, and mode. This is an ungrouped data. Please
show your complete solution for this item. (20 points)
MEAN
63 67 79 80 54 53 54 49 68 69 50 48
49 60 67 54 60 54 51 70 73 80 57 66
𝑆𝑢𝑚 𝑜𝑓 𝑎𝑙𝑙 𝑣𝑎𝑙𝑢𝑒𝑠
𝑀𝑒𝑎𝑛 =
𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝑣𝑎𝑙𝑢𝑒𝑠
1475
=
24
= 61.458/61.46
MEDIAN
48 49 51 54 54 57 60 66 67 69 73 80
49 50 53 54 54 60 63 67 68 70 79 80
Performance Task
Name: Cheny N. Asna
Section: Section
Instructions: Read each instruction in every item.
1. Sample of 40 college students are considered for study and were categorized
according to year level. The data set is
Construct a frequency distribution for the data Then using MS Excel, construct a
bar chart, and a pie chart. Attach a screenshot of the excel application with the
graphs in this file. (20 points)
Note: Please upload the excel file you use in creating this exercise.
Class Tally Frequency Percentage
Freshman xxxxxxxxxxx 11 27.5
Sophomore xxxxxxxxx 9 22.5
Junior xxxxxxxxxxxx 12 30
Senior xxxxxxxx 8 20
TOTAL 100
BAR CHART
, PIE CHART
2. Every month, for the past two years, a poll was taken to measure the perceptions
of people who rate the president of the Philippines on his job performance. The
percentages of those who judged that performance as satisfactory are listed
here.
Compute for the mean, median, and mode. This is an ungrouped data. Please
show your complete solution for this item. (20 points)
MEAN
63 67 79 80 54 53 54 49 68 69 50 48
49 60 67 54 60 54 51 70 73 80 57 66
𝑆𝑢𝑚 𝑜𝑓 𝑎𝑙𝑙 𝑣𝑎𝑙𝑢𝑒𝑠
𝑀𝑒𝑎𝑛 =
𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝑣𝑎𝑙𝑢𝑒𝑠
1475
=
24
= 61.458/61.46
MEDIAN
48 49 51 54 54 57 60 66 67 69 73 80
49 50 53 54 54 60 63 67 68 70 79 80
