Topic: Data Presentation or types of graphs.
Learning Outcome: To construct an appropriate type of graph.
Construct the graphs of the data given.(you may use Microsoft excel in constructing the graphs)
1. Department of Labor and Employment statistical data for recent year shows the average monthly earnings of
Filipino workers with respect to educational level. Draw a Pareto Chart, pie chart and bar chart that shows this
information.
Educational Level Average Monthly Earnings
Elementary graduate (EG) P 8,000
High School Graduate (HSG) P11,000
Senior High Graduate (SHG) P12,300
College Level (CL) P13,500
College Graduate (CG) P17,200
a. Pareto Graph
AVERAGE MONTHLY EARNINGS
₱20,000
₱18,000
₱16,000
₱14,000
₱12,000
₱10,000
₱8,000
₱6,000
₱4,000
₱2,000
₱0
COLLEGE GRADUATE COLLEGE LEVEL SENIOR HIGH SCHOOL HIGH SCHOOL ELEMENTARY
GRADUATE GRADUATE GRADUATE
EARNINGS
b. Pie Chart
Average Monthly Earnings Of Filipino Workers With Respect To
Educational Level
13% EG
28% HSG
SHG
18%
CL
CG
22% 20%
c. Bar Chart
Average Monthly Earnings Of Filipino Workers With Respect
To Educati onal Level
20,000
16,000
AVERAGE MONTHLY EARNINGS
12,000
8,000
4,000
0
EG HSG SHG CL CG
AVERAGE MONTHLY EARNINGS
Holy Name University
City of Tagbilaran
College of Arts and Sciences
Subject: Advanced Statistics with Software Applications
Prepared by: Fe R. Janiola, Ph.D.
ACTIVITY SHEET No. 5
Name: FUDALAN, Dea Viktoria C. Date: Sept. 8,
2021
Course & year: BSA 3 Score: __________
Skills/Exercise/Drill Summative Performance Task
Topic: Data Presentation or types of graphs.
Learning Outcome: To construct an appropriate graph.
Construct the indicated graphs. (you may use Microsoft excel in constructing the graphs)
1.The Department of Transportations and Communications (DOTC) gathered information
about the communications agencies that provides mobile phone services among Filipinos. The
information in the table shows the communications agencies and the number of subscribers.
Construct a pictograph.(Sirug, 2011)
Communication Agency No. of Subscribers
Smart Communications P5,000,000
Globe Telecommunications P4,000,000
Sun Cellular P2,500,000
Talk and Text P1,000,000
Others P500,000
NO. OF SUBSCRIBERS IN EACH COMMUNICATION AGENCY
Others
Talk and Text
Sun Cellular
Globe Telecommunications
Smart Communications
- 1,000,000.00 2,000,000.00 3,000,000.00 4,000,000.00 5,000,000.00 6,000,000.00
2. The following data represents the digital-mode talk time in hours and battery capacity in
milliampere-hours of cellular phone. Construct a scatter plot. .(Sirug, 2011)
Talk Time 4.50 3.90 4.20 2.80 3.70 2.60 4.80 3.50 3.80
Battery Capacity 850 700 1,000 800 650 700 1,200 600 1,000
Batt ery Capacity
1,400.00
1,200.00
1,000.00
800.00
600.00
400.00
200.00
0.00
2 2.5 3 3.5 4 4.5 5
Holy Name University
City of Tagbilaran
College of Arts and Sciences
Subject: Advanced Statistics with Software Applications
Prepared by: Fe R. Janiola, Ph.D.
ACTIVITY SHEET No. 6
Name: FUDALAN, Dea Viktoria C. Date: Sept. 8,
2021
Course & year: BSA 3 Score:
__________
Skills/Exercise/Drill Summative Performance Task
Topic: Data Presentation or types of graphs.
Learning Outcome: To construct an appropriate graph.
1.The RAJ Travel Agency, a nationwide local travel agency, offers special rates on summer period. The
owner wants additional information on the ages of people taking travel tours. A random sample of 50
customers taking travel tours last summer revealed these ages.
18 29 37 42 47 49 53 57 61 67
19 31 38 44 48 50 54 58 62 68
24 34 39 45 48 51 54 58 63 70
27 36 39 46 48 51 55 59 64 74
28 36 40 46 49 52 56 60 66 77
Construct a stem-and-leaf plot.
Solution: Stem Leaf
1 89
2 4789
3 14667899
4 024566788899
5 0112344567889
6 01234678
7 047
2.LAJ Universal Banking is studying the number of times their Automated Teller Machine (ATM) is used
daily, located at a certain mall. Following is the list of the number of times the teller was used during the
last 40 days.
51 56 62 65 70 72 77 80 83 86
53 58 63 66 71 72 78 81 84 87
54 59 64 67 71 73 79 82 84 87
56 60 64 68 71 76 80 82 85 88
Solution:
Stem Leaf
5 1346689
6 023445678
7 01112236789
8 0012234456778
3.The following data represents the bounced check fee in pesos (in hundreds) for a sample of 50 banks for
direct deposit customers who maintain a P5,000 balance.
12 36 22 38 25 51 30 52 25 49
13 33 23 13 39 25 29 32 34 54
15 31 25 52 40 24 48 55 22 44
16 31 26 25 17 42 36 34 23 11
23 27 18 13 17 16 19 41 46 44
Solution:
Stem Leaf
1 123335667789
2 22333455555679
3 01123446689
4 01244689
5 12245
