Senior High School

Business
Mathematics
Quarter 2 – Module 15:
Spreadsheet for Computation
and Presentation

Writer:
LEAH L. PEREZ
MT II – Lubao National High School
Editors:
JANE P. VALENCIA, Ed.D. – EPS – Mathematics (CHAIRMAN)
CHARIZEL T. ARCILLA – SPST-I Malino National High School
JHOANNA S. MANALOTO – T-II San Juan High School (Mexico)
1
 What I Need to Know

In this module, you will explore a faster and an exciting way of computing salary and
overtime pay- not only through a calculator but a bigger version of it - the electronic
spreadsheet. You will also experience presenting details or particulars of salary in a creative,
colourful and personal manner.

The module is divided into two lesson, namely:

➢ Lesson 1 – E-Spreadsheet for Computing Salary and Overtime Pay
➢ Lesson 2 – Graphical Representation of the Details or Particulars of the Salary

After going through this module, you are expected to:

• identify the most commonly used spreadsheet;
• be familiar with the formula used in a pay slip;
• compute salaries annually, monthly, bi-monthly, weekly and bi-weekly in excel;
• solve total hours of work, overtime pay and gross pay; and
• present graphically the details or particulars of the given salary.

What I Know

Pre-Assessment

Direction: Choose and write the letter of the correct answer on your answer sheet. If the
answer is NOT on the choices, write the correct one.

1. Formula in excel starts with ____

A. = B. + C. - D. *
For numbers 2-6, refer to the choices and improvised payslip below (in excel form).

A. =F34-F40

B. =sum(F36:F39)

C. =E37*F32

D. =E36*F32

E. =F32+F33

2. Formula for the gross compensation.

3. What must be entered on cell F36?
4. How are you going to solve for the PHILHEALTH share?
5. What are you going to press on F40?
6. Formula for the net pay.
7. Charmaine enters in cell A1 and A2 her hourly regular rate and total hours worked on
regular day. If she will compute for her regular pay in cell A3, what will she press?
A. =A1+A2 B. =sum(A1:A2) C. = A1 * 1.25 D. =A1*A2
 8. Joseph will present a given data using pie graph. He entered and highlighted the
appropriate data. What must he do next on the ribbon?
A. click design and click pie graph
B. click insert and click insert pie
C. click file, then save as then insert pie
D. click insert then inset pivotchart

For numbers 9-10, if cell B2 contains your annual salary, how are you going to solve for
the following in excel if you want to put your answer in cell B3 and B4,respectively? Use
the choices below.
A. In B3, =B2/12 C. In B4, =B2/52
B. In B3, = B2 /52 D. In B4, =B2/12
9. Monthly salary
10. Weekly salary
11. If you are about to solve for the total hours of work in a week of 100employees, how are
you going to do it at once?
A. Enter the correct answer in a cell computed in a calculator, then drag down.
B. Enter the correct formula in addition in the uppermost cell, then drag down.
C. Highlight all the cells with the total hours then enter the correct formula at once.
D. Press “=sum(cells to be added)” in one cell, then copy paste to the other cells.

For numbers 12-15. Identify the needed formula that needs to be entered in excel using the
data and choices below. Refer to the choices below.
A. =C2+D2+F2+G2 C. =B2*2*E2
B. =K2+L2+M2 D. =B2*1.25*J2

12. Total Regular Hours

13. Overtime Pay
14. Pay on a Regular Holiday
15. Total Income
 Lesson
Spreadsheet for Computation
1 and Presentation

Have you ever wonder how an accountant or bookkeeper computes for the company’s
payroll? For those number of employees, how do they come up with computing their
wages/salaries at once? They do these using programs like the spreadsheet.

As you go through this module, basic of an electronic spreadsheet will be discussed.

What’s In

Direction: Decode the riddle by matching the terms in Column A with the corresponding
formula/definition in Column B. Write your answer on your answer sheet.

It is one of the most commonly used electronic spreadsheet.

1 5 6 7 3 8 3 10 11 2 4 6 2 9

Column A Column B (Decoder)

1. Net Pay T = Annual salary ÷ 52
2. Total earnings (per piece) C = (gross earnings – deduction) x
certain %
3. Monthly salary M = gross earnings - deduction
4. Additional compensation for overtime L = 1/12 of annual basic salary
5. Semi-monthly salary X = plus 25% of regular wage
6. Taxable income S = 22.5 x P x T
7. Regular holiday R = double pay
8. Retirement Benefit O = Annual salary ÷12
9. 13th month pay F = Annual salary ÷26
10. Bi-weekly salary E = quantity x rate
11. Weekly salary I = annual Salary ÷24
 What’s New

This module will allow you to do hands-on computer application in computing salaries
and overtime. It will introduce electronic spreadsheets, specifically the Microsoft Excel, a
computer program which will help you solve faster and easier.

Tita Pau’s Payslip

Aleli, an ABM student, once observed the payslip of her auntie, Paula, who is working
in a budget and finance department of EY EL PI Company. Shown below is her auntie’s payslip.

Questions:

How is gross compensation computed? ___________________________________________

How do you compute for the GSIS Premium? _____________________________________

In computing for the total deduction, what value should be written first in a cell?
________________________________________________________________________________
What formula should be entered to compute for the net pay (refer to the given)?

Where will you enter the formula in Microsoft Excel? ______________________________

Notes to the Teacher

At this juncture, let students identify

the important parts of the spreadsheet like the
cell, column, etc.
 What is It

You will use excel (this time) in answering the previous problem. But before that,
familiarize yourself with the spreadsheet. To begin with, open your spreadsheet (excel).
Below is a sample.

Next, search on the internet how a “cell” is identified and how “dragging” is done. This
will be the starting point of using the excel. Likewise, be reminded of the following:

• Formula starts with “=”. If 1 + 1 = 2, in excel it is written as =1+1(no spaces)

• Press “enter” after typing the formula
• To add, simply type “=sum(1st cell to be added:last cell to be added)” or =Cell to be
added+anothercell to be added + another cell to be added)
• The symbol used for multipication is the asterisk “*”
• Use “/” for division.
• Spreadsheet is used to solve at once a number of computation of the same problem.
• Only some functions will be intoduced. Searching more on it will be on your part.
• Presentation will only focus on pie graph. Next modules will discuss more on the
presentation.
• Lastly, you are the “master mind” of the computations and presentations in any
spreadsheet. It only follows your command. So, be wise and careful.

Notes to the Teacher

Emphasize that a formula computes the

specific cell following the given command. Thus,
be careful in choosing cells to be computed.
 You are now ready to solve the previous problem. Type in the given data on the previous
problem. (Color is for emphasis only.)

➢ To compute for the gross compensation:

simply add the basic salary (F4) and allowance
(F5). In cell F6, type in the formula “=sum
(F4:F5). Then press enter.

➢ To solve for the total deduction, click the cell

for it (F12), then add the deductions from SSS
Premium to BIR Tax. Type “=sum (highlight the
value from SSS Premium to BIR Tax). Enter.

➢ For Net Pay, click the cell E13, then type in

=. Click on the cell corresponding to the gross
compensation (F6) then the minus symbol (-)
and click the cell that corresponds with the total
deductions (F12). Press Enter.

2. It is very important to identify the percentage corresponding to the different deductions.

For discussion purposes, let us take GSIS- 9%, Philhealth-1.5%, PagIbig-2%. To solve each
of these, simply type in the corresponding cell, “=”, then cell that corresponds to basic salary
time (*) the percentage. Press enter. In the example, simply type the ones shown on the last
column (see figure below).

➢ For the standard deductions, there are specified contribution tables to be followed as
discussed in the previous modules. Another function, the “vlookup” is used. Search more on
it in the internet. Try it in solving for the tax.
More examples:
1. Compute for Tita Pau’s monthly, semi-monthly, weekly and bi-weekly salary using
spreadsheet.
Hint: It is easier to solve this problem if you have the annual salary.
Enter the formula starting with B2 up to F2 (as shown below).

2. In EY EL PI Company, employees are paid 125% of their hourly regular payment in

excess of 8-hour work. Compute for the employees’ total income for the week. See the table
below.

For the Total Hours:

In H2, type “=sum(“, then click on C2 to G2 or type “=sum(C2:G2)”

For Regular Hours:

Since there should be 8 hours in 5 days, type =8*5, then enter

For Overtime hours:

Subtract regular hours from the total hours. Thus, in J2, type =H2-I2, enter.
For the Regular Pay (in a week)

Multiply the hourly rate by the regular hours. Thus, in K2, type =B2*I2,enter.

For the Overtime Pay:

Multiply the hourly rate by the overtime hours by 125%. Thus, in L2, type =B2*J2*1.25,
then enter.

For the Total Income:

Add the regular pay and overtime pay. Thus, in M2, type =K2+L2, then enter, or
=sum(K2:L2) then enter.

DO NOT forget to drag down to compute the rest of employees’ data and get this:
 3. Aleyah and Ayelah works in a factory. They receive hourly rates of Php 50 and Php 60,
respectively for regular days (Monday to Friday). If the factory follows the mandates on the
Labor Code, compute for their gross earnings last week given that they both worked on the
following days except that Ayelah was absent on Thursday.
Monday – 8 hours Wednesday – 10 hours Friday – 12hours
Tuesday – 12 hours Thursday – 7 hours

Solution:

a. First, you need to create pay head and indicate the given data like this:

b. Then enter the formula for:

overtime rates = 125% of hourly rates → In cell C2, type =1.25*B2,enter,drag down

total hours = sum from Monday to Friday →In cell I2,type =sum(D2:H2),enter, drag down

c. Continue the payhead and enter the formula for:

Hourly Overtime Total Regular Overtime Regular Overtime Gross

Name
rates Rates Hours Hours hours Pay Pay Pay

Aleyah ₱50.00 ₱62.50 49 40 9 ₱2,000.00 ₱562.50 ₱2,562.50

Ayelah ₱60.00 ₱75.00 42 40 2 ₱2,400.00 ₱150.00 ₱2,550.00

Regular hours- Cells under this should be the minimum hours per week (8 hours x 5
days )or less. Since both exceed 40hours, one option is to enter 40 on J2 and drag down.
Another is to use “if function”. On cell J2, enter “=IF(I2<=40,I2,40)” and drag down.

Overtime hours = Total Hours – Regular hours. What are you going to type on K2?

Regular Pay = Hourly Rates x Regular hours. Thus type =B2*J2 on L2 then drag.
Overtime Pay = Overtime rates x Overtime hours. Thus type =C2*K2 on M2 then drag.

Gross pay = Regular Pay + Overtime Pay. Thus, type =L2+M2, then drag.

Thus, Aleyah’s gross earnings is Php 2,562.50 while Ayelah’s is Php 2,550.00
ON PRESENTATION…

Other than computing salaries and overtime, you can also present them graphically using
the spreadsheet. Usually, the pie graph is used to represent salaries and overtime. It simply
shows the division of the salary and the percentage allocated to each division. To do this:

1. Enter the data as shown on the left.

2. Highlight the entire data

3. On the ribbon, click the insert function.

4. Look for the insert pie. For this, click the first 2-D pie. Then press Enter.

5. This should appear. You can also choose from the ribbons the design of your pie graph.

6. Click the Chart Title and change to desired title.

7. You may also choose from the options on the design of your pie graph.
 What’s More

Activity 1. Spread my Salary

Direction: The data below shows the partial salary of employees. Complete the table to show
their annual, monthly, semi/weekly and bi-weekly salary. Use excel.

Name Annual Monthly Semi- Weekly Bi-

Salary Salary Monthly Salary weekly
Marites ₱11,538
Janice ₱20,000
Lyn ₱5,000
Leo ₱40,000
Flor ₱96,000

Assessment 1. Spread my Salary

Direction: Using the spreadsheet, compute for the corresponding contributions of the following
employees. Compute also their total deduction.

Activity 2. Pay Sheet

Direction: Indicate the needed formula in solving for the specified cell by completing the
statements below. Write your answers on your answer sheet.

1. In F19, press _____, then enter to solve for the gross compensation.
2. In _____, press =E21*F17 or =E21*.09, then enter to solve for GSIS share
3. In F23, press _____ to solve for ________.
4. Press _____ in cell _____ to compute for the total deduction.
5. For net pay, press _____ on cell _____.
Assessment 2. Pay Sheet
Direction: Complete the table below using spreadsheet

Activity 3. Over the Spreadsheet

Direction: Compute for the total income of the following employees if they are paid Php40/hour
on a 40-hour workweek and an additional of 25% thereof for overtime work. Use excel.

Assessment 3. Over the Spreadsheet

Direction: Compute for the total income of the following employees if they are paid Php40/hour
on regular days (Mon-Fri), an additional of 25% for overtime work and another 30% additional
on Saturdays. Use excel.

What I Have Learned

Answer the following questions and write your answer on your answer sheet.

1. How do you call the spreadsheet that you usually use in computing salaries and wages?
2. In writing a formula in a spreadsheet, what operation do you enter first?
3. What symbol do you use in multiplication?
4. How is “drag down” done?
5. How do you use excel in computing salaries and wages?
6. How do you present salaries and wages using a pie graph?
 What I Can Do

Bhugs Kabiling earns a monthly salary of Php 25,000 plus a Php2,000 allowance. She's
being deducted by 9% of basic pay for GSIS share, Php 100 for PAGIBIG Fund, 1.5% of basic
pay for PhilHealth and 10% tax. She also pays SSS voluntary contribution equivalent to 4% of
her basic salary. For her under time and lates, she was deducted Php3,500. More so, she pays
Php1,500 for her personal loan in a private company. Help her do the following:
• Set up a spreadsheet.
• Enter the necessary data.
• Compute for Bhugs’:
- Gross pay, exact deduction amount, total deduction , net pay
• Present her deductions in a pie graph showing correct percentages, then print.

Assessment

Direction: Choose and write the letter of the correct answer on your answer sheet. If the
answer is NOT on the choices, write the correct one.

1. Formula in excel starts with ____

A. = B. + C. - D. *
For numbers 2-6, refer to the choices and improvised payslip below (in excel form).

A. =F34-F40

B. =sum(F36:F39)

C. =E37*F32

D. =E36*F32

E. =F32+F33

2. Formula for the gross compensation.

3. What must be entered on cell F36?
4. How are you going to solve for the PHILHEALTH share?
5. What are you going to press on F40?
6. Formula for the net pay.

7. Charmaine enters in cell D1 and E1 her hourly regular rate and total hours worked on
regular day. If she will compute for her regular pay in cell A3, what will she press?
A. =D1+E1 C. = A1 * 1.25
B. =sum(A1:A2) D. =D1*E1
8. Joseph will present a given data using pie graph. He entered and highlighted the
appropriate data. What must he do next on the ribbon?
A. click design and click pie graph
B. click insert and click insert pie
C. click file, then save as then insert pie
D. click insert then inset pivotchart
 For number 9-10, If you use excel to compute the gross weekly wage of the following
employees:

9. What formula are you going to enter in cell D2?

A. =B2*C2 B. =B3 * C3 C. =A2*C2 D. = B2*C2
10. How are you going to compute other’s weekly wages in the easiest way?
A. Copy and paste the formula in D2
B. Drag down the formula in D2
C. Enter an easier formula in D3
D. Format the next cells in a new formula

For number 11 and 12. Use excel to present the given data using pie graph and answer the
questions that follow. Use the choices on the right.

A. 55%
B. 41%
C. 45%
D. 1%

11. What is the equivalent percentage for the GSIS Personal Share?
12. Philhealth has a share of how many percent?

13. If you are about to solve for the total hours of work in a week of 100employees, how are
you going to do it at once?
A. Enter the correct answer in a cell computed in a calculator, then drag down.
B. Enter the correct formula in addition in the uppermost cell, then drag down.
C. Highlight all the cells with the total hours then enter the correct formula at once.
D. Press “=sum(cells to be added)” in one cell, then copy paste to the other cells.

For items 14-15. Refer to the problem below.

The following employees are paid per hour at the rate of Php 45.00. L. Malit typed these data
in excel and planned to compute for their total hours and gross pay.

14. In which cell will she start solving for the total hours of work and what will she type in
it?
A. In G1 →=sum(G1:F1) C. In G2→=sum(A2:F2)
B. In G2 →=sum(B2:F2) D. In G3 →=sum(B3:F3)

15. What formula is needed in H4?

A. =sum(B4:F4) C. = H4*45
B. = sum(B4:G4) D. =G4*45
 Additional Activities

I. I am an Accountant!
Direction: Act as an accountant. Enter the given data in excel and compute for the
gross income, exact amount of partial deductions, total deductions and net pay.

II. I am an Accountant! (Still ☺)

Direction: Act as an accountant (again). Compute for the gross earnings of the following
employees who are paid Php 45.00 per hour for the first 40 hours of work-week. They are
given 125% hourly rate in excess of 40hours. Use excel.

Employees Mon Tue Wed Thu Fri

L. Malit 8 8 6 6 12
C. Dabu 8 7 6 7 13
H.Flores 8 7 6 8 12
L.Perez 8 7 6 9 14
I.Gomez 8 7 6 8 15
 Senior High School

Business
Mathematics
Quarter 2 – Module 18:
Presentation and Analysis of
Business Data Using Microsoft Excel

Writer:
WILLIAM M. ELIGIO
Teacher-II Potrero National High School
Editors:
JANE P. VALENCIA, Ed.D. – EPS – Mathematics (CHAIRMAN)
CHARIZEL T. ARCILLA – SPST-I Malino National High School
JHOANNA S. MANALOTO – T-II San Juan High School (Mexico)
 What I Need to Know

This module was designed and written with you in mind. It is here to help you master in
Presentation and analysis of Business Data using Microsoft Excel. The scope of this module
permits it to be used in many different learning situations. The language used recognizes the
diverse vocabulary level of students. The lessons are arranged to follow the standard sequence
of the course. But the order in which you read them can be changed to correspond with the
textbook you are now using.

After going through this module, you are expected to:

1. Give a set of business data; identify the graphs to be use;
2. draw the graph/table and present the data;
3. analyze and interpret the data presented in the graph/table; and
4. use software (i.e., MS Excel, SPSS) programs to computer and presentation of business
data.

What I Know

Pre- Assessment

Direction: Choose the letter of the best answer. Write the chosen letter on your notebook or
on a separate sheet of paper. If you are not aware or unsure of some items, choose the answer
that is best based on your perception. Then go back to those items as you continue with the
lesson.
1. Is a spreadsheet and graphing and database management tool frequently used for
business?
A. Microsoft Excel
B. Microsoft Word
C. Power Point
D. Windows 10
2. Which of the following is a graphical presentation use in business?
A. Bar graph
B. Histogram
C. Line graph
D. All of the above
3. The picture below represents an example of what graphical presentation?

A. Bar graph
B. Line graph
C. Pictograph
D. Pie graph

4. What is the best graph to use if you want to allocate your expenses base on your
salaries?
A. Bar graph
B. Line graph
C. Pictograph
D. Pie graph
2
 5. The picture below represents an example of what graphical presentation?

A. Bar graph
B. Histogram
C. Line graph
D. Pie graph

6. Which graph is the best to use if you were to present the increase or decrease of
company sales for 10 years.
A. Histogram
B. Bar graph
C. Pictograph
D. Pie graph

7. The picture below represents an example of what graphical presentation?

A. Bar graph
B. Line graph
C. Pictograph
D. Pie graph

8. Which graph is the best to use to show kilowatts consumption for a year?
A. Histogram
B. Line graph
C. Pictograph
D. Pie graph

9. Why do businessmen nowadays use Excel in presenting their data?

A. Excel makes the report more colorful that makes it more interesting to the
audience.
B. Excel is a mandatory tool to use in presenting a data.
C. Excel would be much easier to make tables and draw graphs. It is convenient
on their part at the same time.
D. Excel is very popular right now and they want to be in.

10. Which of the following will the first step if we will prepare graphical presentation using
Excel?
A. Choosing different graphs line, bar, pie charts and more
B. Open an Excel WORKSHEET. Encode your data in one column with the
appropriate variable name.
C. Press the desired graph you choose.
D. None of the above
For numbers 11 to 15, write TRUE if the statement is correct or FALSE if the statement is
incorrect.
11. Microsoft Excel is more powerful to use than Microsoft word when it comes to
presenting business data?
12. Excel is friendly. It offers a comprehensive HELP facility and excellent on line facility.
13. Microsoft word is a spreadsheet and a graphing and database management tool.
14. It is not easy to make tables and draw graph in excel so manual drawing is still the
best to use.
15. Excel is not reliable when it comes to presenting business data.

3
 Lesson Presentation and Analysis of
1 Business Data using
Microsoft Excel
Microsoft Excel Defined

• Is a spreadsheet and graphing and database management tool.

• Is a software program produced by Microsoft that allows users to organize, form and
calculate data with formulas using a spreadsheet system.
• It is frequently used for business data.

What’s In

Match each Graph name from column A to the correct Graph picture from column B. Write
your answers on your notebook or on a separate sheet of paper.

Column A Column B
1. Bar Graph A.

2. Pie Graph B.

3. Histogram C.

4. Line Graph
D.

5. Pictograph
E.

4
 What’s New

Are you familiar with spreadsheet? Can you do a list of useful Excel functions/applications
(e.g. basic data input, computations, generating graphs/charts, etc.). Write your answers on
your notebook or on separate sheet of paper.

List down 3 or more useful Excel functions/applications

Fill-up the first two boxes. (What I Know and What I WANT TO Know) in the following KWL
Chart Microsoft Excel.

What I ____________________________________
____________________________________
Want to know
What I ____________________________________
____________________________________
Know
What I ____________________________________
____________________________________
Learned
For around 10 minutes try to recall the different Excel application that you are familiar with
by having on hands-on tasks.

5
 What is It

Graphical Presentation in Excel

1. Open an Excel worksheet. Encode your data in one column with the appropriate
variable name.

2. In the Insert Tab, you can have a choice of different graphs – line, bar, pie charts and
more. Sat we choose line.

3. Press the desired graph

6
Go and experiment the other graphs to have good and captivating presentation!

Descriptive Statistics from Excel

Excel also gives the statistics of measures of central tendency and measures of variation.
Check of DATA ANALYSIS is installed in DATA. If not, it will only take some seconds to
install it.

The following are the steps to install DATA ANALYSIS.

1. From the EXCEL BUTTON, press EXCEL OPTIONS found below the dialogue box.
2. A new window will appear, press ADD INS on the 1st column. Then press GO.
3. Highlight STATISTICAL TOOLPAK – VBA, then press GO.
4. Allow Excel to install the software in less than a minute.
5. If properly installed, DATA ANALYSIS is now available from DATA.

Example:

Let us work on DESCRPTIVE STATISTICS in Excel.

1. Encode your data in one column.
2. Press DATA/DATA ANALYSIS/DESCRIPTIVE STATISTICS.
3. Enter the scores on the INPUT RANGE.
4. Check SUMMARY STATISTICS, then OK.
5. Your statistics will appear in a new sheet.

Step 1:

7
Step 3:

Step 5:

DATA ANALYSIS Gives the summary of descriptive statistics from the measures of location of
the measures of kurtosis.

8
 What’s More

Activity
A. The following data shows Quarter Mile’s Sales for its three products for three
consecutive years (2016-2018).
2016 2017 2018
Product W 900 500 1000
Product Y 1000 600 1200
Product Z 100 700 1700
Total 2000 1800 3900
Present the given data using the appropriate graph. Generate the graph using Excel. Print
your output and paste it in your notebook or pass it directly to your teacher.
B. Calculate the descriptive statistics for the following data sets using Excel.
Grades earned by the students in the final exam is Business Mathematics. Show your
work by taking a screenshot of your output and pasting it on your notebook.
75 81 98 78 94 87 91 92 86 93
90 82 88 84 68 83 91 85 72 63

What I Have Learned

Answer the following questions in no less than two (2) sentences. Write your answers on your
notebook or on a separate sheet of paper.

1. What is Microsoft Excel?

2. Why do businessmen use Microsoft Excel to present their business data?

3. What are the advantages of using Microsoft excel in presenting a business?

Fill-up the last box. (What I Learned) in the following KWL Chart Microsoft Excel.

What I ____________________________________
____________________________________
Want to know
What I ____________________________________
____________________________________
Know
What I ____________________________________
____________________________________
Learned

9
 What I Can Do

The following are the number of days of policies were processed in a savings bank.

73 19 16 64 28 60 56 31 56 22

45 48 17 17 91 51 69 17 92 18

• Prepare any graph you desire to do using these figures in Excel. Take a screenshot of
your work and paste it in your notebook.
• Compute the descriptive measures from Excel.
If a customer enters the bank to purchase a policy, and asks how long the processing will
take, what would you tell him? What statistic will you use?

Assessment

Present the given data using the appropriate graph. Generate a BAR graph using Excel.

15 points for a perfect graph and 1 point will be deducted for each error trace on your graph.
A. The following data shows COVID – 19 Buy and Sell’s Sales for its four products for
four consecutive years (2016-2019).
2017 2018 2019 2020
Alcohol 1000 1200 900 2300
Face Mask 300 450 250 1800
Thermal Scanner 400 500 350 1750
Disinfecting Foot 100 200 500 1200
mop
Total 1700 2150 1500 5850

Additional Activities

Do a survey on high school students (if you have an internet) or with your family member (if
you don’t have internet) using internet or social media on the following categories:
1. Game they usually play
2. Food budget
3. Beverages ordered (soda, milk tea, coffee, ice tea)
4. Number of times to dine in a fast food restaurant before pandemic
5. Usual companion when dining on fast food restaurants (peer group, parents,
boyfriend, girlfriend)
Explore graphically using Excel or your preferred statistical software. Do the measures of
central tendency and measures of variation.

10
 Senior High School

Business
Mathematics
Quarter 2 – Module 17:
Presentation and Analysis of
Business Data

Writer:
MA. CORAZON ALFARO
Teacher II – Potrero National High School
Editors:
JANE P. VALENCIA, Ed.D. – EPS – Mathematics (CHAIRMAN)
CHARIZEL T. ARCILLA – SPST-I Malino National High School
JHOANNA S. MANALOTO – T-II San Juan High School (Mexico)
 What I Need to Know

This module was designed and written with you in mind. It is here to help you master the
Presentation and Analysis of Business Data. The scope of this module permits it to be used in
many different learning situations.

The module has 1 lesson, namely:

• Lesson 1 – Kinds of Graphs for Data Presentation

After going through this module, you are expected to:

1. Compare and contrast different graphs;
2. recognize that circle graphs are best used to compare the parts of a whole;
3. recognize that bar graphs are used to compare facts;
4. recognize that a line graph is used to show changes over time;
5. determine which type of graph is appropriate for representing a given set of data
presented; and
6. connect graphs to data found in the real world.

What I Know

Pre-Assessment
Direction: Choose the letter of the best answer. Write the chosen letter on your notebook or
on a separate sheet of paper. If you are not aware or unsure of some items, choose the answer
that is best based on your perception. Then go back to those items as you continue with the
lesson.

1. Which of the following graphs uses line segments to connect data points?
a. Line graph c. Bar graph
b. Pie chart d. Histogram
2. Which of the following graphs uses rectangles erected on the horizontal axis to
summarize a set of quantitative data?
a. Line graph c. Bar graph
b. Pie chart d. Histogram
3. Which of the following is a circular-pie-like graphic representation with wedges or
sectors that show how much of the whole each part makes up?
a. Line graph c. Bar graph
b. Pie chart d. Histogram
4. Which graph uses shaded region to display quantitative data graphically and
independently?
a. Line graph
b. Pie chart
c. Bar graph
d. Histogram

2
5. Which type of graph is this?

a. Line graph
b. Pie chart
c. Bar graph
d. Histogram

6.What does a pie chart allow you to see?

a. information about the proportion of parts relative to the whole.
b. the total number of each category
c. how much data occurs within a range of numbers
d. the spread of the data
7. Which chart will show the direction of change in numbers over a period of time by
connecting data points?
a. Line graph c. Bar graph
b. Pie chart d. Histogram
8. The type of chart that best represents percentages of a whole is:
a. Line graph c. Bar graph
b. Pie chart d. Histogram
9. Which type of chart displays bars side by side?
a. Line graph c. Bar graph
b. Pie chart d. Histogram
10. The type of chart where the height of the bar represents a value is called:
a. Line graph c. Bar graph
b. Pie chart d. Histogram
11. Bar charts are MOST effectively used to:
a. present scientific data
b. compare groups of data
c. show parts of a whole
d. show an activity of an item over a period of time
12. The timeline shows the months that an amusement park is open. On which date is
the park not open?

a. October 15 c. April 5
b. June 1 d. August 31
13. Which chart/graph can track and compare measurements, such as temperature, and
show trends and comparisons?
a. Line graph c. Bar graph
b. Pie chart d. Histogram
14. Choose the graph that best fits with this statement: "The TV license has been frozen
for the next 3 years".

a. b. c. d.

15. What is the other term for pie chart?

a. Circle chart c. Circle graph
b. Pie graph d. Pie circle chart

3
 Lesson
Kinds of Graphs for Data
1 Presentation

A good graphical display is pleasing to the eye and, therefore, can have the effect of
impressing the viewer and encourage them to read more of a page or site. Such an informative
graph has a positive impression on the website.

What’s In

A graph is an alternative way to present data. It involves a lot of communication power.

A quick look of these graphs may enable the reader to have an instant and meaningful picture
of the vast amount of data.

Different data call for different graphs. The graphs may all look brilliant, but is it the right
graph for the data? In this lesson, we will learn how to compare and contrast different graphs
and determine which type of graph is appropriate for representing a given set of data presented.

As a form of recall, kindly enumerate the three different types data presentation. Include the
different types of graphs you remember from your previous years taking mathematics. Write
your answers on your notebook.

What’s New

Andrei’s school has announced that they will be cancelling wood shop because not enough
students are interested. Over the next few weeks, Andrei and his friends gathered data about
wood shop. They learned that in 2008, there were 30 out of 100 seventh graders and 40 out of
100 eighth graders who had participated in wood shop. Then in 2009, the numbers had
increased. There were 40 seventh graders and 58 eighth graders who had participated. Andrei
and his friends believe the data suggests that wood shop is increasing in popularity and should
not be cancelled. How can the students clearly show the information they have gathered on a
chart?

A bar graph consists of rectangular bars and a corresponding category. The above table of
the ages can be used to create the bar graph.

Let’s try constructing a bar graph. Follow the steps provided below and write/draw your graph
in your notebook or on a separate sheet of paper.

First, draw the horizontal axis and the vertical axis.

Next, label the horizontal axis with the years 2008 and 2009.

Next, label the vertical axis with a scale to represent the number of students. Since there are
100 students in grade seven and 100 in grade eight use increments of 10 for your scale.

4
Next, label the bar graph with a suitable title that tells what the bar graph represents.

Next, include a legend with your bar graph showing the color of the bar for 7 th grade and the
color of the bar for 8th grade.

Then, draw the bar graph such that each year has two bars displayed below.

What is It

Definition of Graph
• It is an alternative way to present data.
• It involves a lot of communication power.
• In businesses, it is used to help them convey information and to make sense of
data.
• It always describes something about business.
Most commonly used different kinds of graphs
• Line graph - uses line segments to connect data points. It is useful in showing the trends
or in determining relationships between two variables. It can also be applied if the
variable plotted along the X-axis (horizontal line) is related to time (year, month, day,
clock time).
• Bar graph - uses rectangles erected om the horizontal axis to summarize a set of
quantitative data. Here, the height of the bar represents the measured value or
frequency; that is. The higher or taller the bar, the greater the value.
• Histogram - is a graphical representation of the frequency distribution. It is a
representation of tabulated frequencies (Y-axis) using adjacent erected rectangles with
their corresponding class intervals (X-axis).
• Pie graph - is also called a circle graph. It is a circle with the wedges or sectors to show
how much of the whole each part makes up. Each slice of the pie is written as a
percentage. To get the measure of each sector in the chart, we compute the following:
amount of item over the total amount of all items multiplied by 360°.

5
Sample Representations of the Different Kinds of Graphs
• a. Line Graph
o Example 5.2.1

• a. Title: The title is the heading written on top of the graph.

• b. Scale: Do not forget the numbers on the X-axis which indicates the units of time. On
the Y-axis, the numbers indicate the units of frequency. Be cautious on the scale of
the Y-axis. If the scale is set too high or too low, the trends in the data can be
misleading.
• c. Labels: Identify the variables on the X- and Y-axes.
• d. Data points: Plot all the data points on the X- and Y-axes. Each data point is
connected to the next point by a line.
• e. Line: Create the line by connecting all data points.
• f. Description: It will be helpful if you will have an explanation of your graph.

In example 5.2.1, the line escalates every week. But a tremendous increase was shown from
Week 5 to Week 6.

• Example 5.2.2

The sales trend of product X in Store A and Store B can be seen in one graph. It is easier to
compare trends when they are represented on the same graph. The sales of product X in
Store A is consistently higher than the sales of product in Store B.

6
b. Bar Graph
Example 5.2.3

The high school students were asked on their preferred dishes. The number of dishes is plotted
on the vertical axis while the type of dish is plotted on the horizontal axis. Most students prefer
chicken barbecue while on the other hand, fish fillet is the least preferred dish.
Example 5.2.4

Aura Pension House offers three types of rooms, Traveler, Executive, and Superior. The sales
of each type are plotted on the vertical axis, and the types of room are on the horizontal axis.
It is easy to compare the trends of each type over a three-year period. Superior is the highest
selling among three, but has dropped off over the three-year period, while sales of the other
two have continued to grow.
Which graphical presentation can approximately model this observation?

Of course, a line graph can also represent this data set.

7
In general, line graphs are used for quantitative continuous data, whereas bar are used for
quantitative discontinuous data. Line graphs are appropriate with frequency data, while bar
graphs are commonly used to display information from surveys or from summary scores.

When you need more spaces to describe the measured variable, it is advised to represent
the data by horizontal bar graphs. The variables can be written on the vertical axis and the
horizontal axis assumes the continuous data.

c. Histogram is a graphical representation of the frequency distribution. It is a representation

of tabulated frequencies (Y-axis) using adjacent erected rectangles with their corresponding
class intervals (X-axis). The rectangles are of equal width since the class mark is used to
represent the class intervals. When you need more spaces to describe the measured variable,
it is advised to represent the data by horizontal bar graphs. The variables can be written on
the vertical axis and the horizontal axis assumes the continuous data.
Example 5.2.5

d. Pie graph is also called a circle graph. It is a circle with the wedges or sectors to
show how much of the whole each part makes up. Each slice of the pie is written as
percentage. To get the measure of each sector in the chart, we compute the following:
amount of an item
x 360⁰
total amount of all items

8
Example 5.2.6

What’s More

Activity 1.1

You have been given a list of ages in years, and you need to show them in a graph. Write or
draw your answer on your notebook or on a separate sheet of paper.

The ages are:

5, 12, 23, 22, 28, 17, 11, 21, 25, 23, 7, 16, 13, 39, 35, 42, 24, 31, 35, 36, 35, 34, 37, 44, 51,
53, 46, 45, and 57.

You can choose to group them into ten-year age categories, 0–10, 11–20, 21–30 and so on:

Note: To show this data in a histogram, your x-axis would be numbered in 10s from 0 to
your highest age, your y-axis from 0 to 8 (the highest number of people in any group), and
there would be no gaps between the bars, because there are no gaps between the age ranges.

Activity 1.2
The data shows the sales figures for a year, broken down by quarters:

Quarterly Sales Figures 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr

8.2 3.2 1.4 1.2

Use a pie chart or a line graph on illustrating the data above. Use your notebook in illustrating
the given.

9
 What I Have Learned

A. Fill the spaces with appropriate answer base on the discussion about kinds of data
presentation. Write your answers on your notebook or on a separate sheet of paper.

1. _______________ is a graph wherein the height of the bar represents the measured value
or frequency; that is. The higher or taller the bar, the greater the value.

2. _______________ is a representation of tabulated frequencies (Y-axis) using adjacent

erected rectangles with their corresponding class intervals (X-axis).

3. _______________ uses line segments to connect data points.

4. _______________ gets the measure of each sector in the chart by computing the amount
of item over the total amount of all items multiplied by 360°.

B. Answer the following questions about bar graphs provided.

1. Which make of car was the most popular?

a. Nissan b. Vauxhall c. Peugeot d. Toyota

2. Which 2 makes of car sold over 150 each?

a. Toyota and MG Rover c.Vauxhall and Peugeot

b. Toyota and Vauxhall d. Peugeot and MG Rover

3. Which was the lowest selling make?

a. Land Rover b. BMW c. Jaguar d. Nissan

C. Answer the following questions about line graph below.

1. Which month had the highest average

temperature?
a. June b. July c. August

2. Which month had the lowest average

temperature?
a. January b. February c. March

3. April and May have the same average temperature

as June and July.
a. True b. False

10
D. Answer the following questions about pie chart.

1. Here's how I spent the past 24 hours? Match the table and pie chart to find out what I
spent the most time on.
a. working b. sleeping c. getting dressed
2. I spent more time on meals than travel and getting dressed combined.
a. True b. False
3. I spent less time watching TV than on doing my household chores.
a. True b. False
4. What did I spend the least amount of time doing?
a. swimming b. getting dressed c. household chores

11
 What I Can Do

For 1.1 to 1.2. Use bar graph and pie chart by using the given data below. After making
the graphs, answer the following questions.
Note: Be guided with the following samples above.
A survey of students' favorite after-school activities was conducted at a school. The
table below shows the results of this survey.

Students' Favorite After-School Activities

Activity Number of Students
Play Sports 45
Talk on Phone 53
Visit With Friends 99
Earn Money 44
Chat Online 66
School Clubs 22

1.1 Make a bar graph using the given data.

1.2 Make a pie chart using the given data.

Questions:
1. What is the title of this graph?

___________________________________________________________________

2. What is the range of values on the (horizontal) scale?

___________________________________________________________________

3. How many categories are in the graph?

___________________________________________________________________
4. Which after-school activity do students like most?

___________________________________________________________________

5. Which after-school activity do students like least?

___________________________________________________________________

6. How many students like to talk on the phone?7.

___________________________________________________________________
7. How many students like to earn money?

___________________________________________________________________

8. Which two activities are liked almost equally?

___________________________________________________________________
9. List the categories in the graph from greatest to least.

___________________________________________________________________

12
 Assessment

Instructions: Write the letter of the correct answer on your notebook or on a separate sheet of
paper. Use the given charts as a reference for you to be able to answer the questions
correctly.
For numbers 1-2, use the given pie chart.
1. What service does the Council spend on the most?
a. Cultural, Environmental and Planning Services
b. Education Services
c. Adult Community Care

2. What percentage of the Council's income is spent

on Education?
a. less than 15%
b. more than on Children and Families
c. less than on "other" services

For numbers 3-6, use the given bar graph.

3. What is the second most popular color of shoes
amongst men?
a. black b. brown c. red

4. What is the second most popular color of shoes

amongst women?
a. black b. brown c. red

5. How many adults wore white shoes?

a. 1 b. 2 c. 3

6. What is the total number of women who took part

in the survey of shoe colours?
a. 30 b. 17
c. 15 d. 13
For numbers 7-10, use the given line graph.

7. Which of these statements best describes what is

shown in the graph?
a. The number of learners we’ve had in our college has
dropped significantly over the last five years
b. There has been a small decrease in the number of
learners in our college over the last five years
c. There has been no significant change in the number
of learners in the last five years
8. What was the decrease in the number of learners
between Years 1 and 2?
a. 10 b. 15 c. 20
9. There was a small increase in numbers between
Years 2 and 3.
a. True b. False
10. Which of these statements best describes what is shown in the graph?
a. The number of learners we’ve had in our college has dropped by over a 100 over the last
five years
b. There has been a small increase in the number of learners in our college over the last five
years
c. There has been no significant change in the number of learners in the last five years

13
11. The following data shows customer waiting time in seconds of a fast food chain. The
manager wants to construct a histogram from this given data.

How many customers are waiting at the interval 16-20 seconds?

a. 4 b. 5 c. 6 d. 7

For numbers 12-13, use the given histogram below.

The annual amount of rainfall for 25 cities was recorded and is shown in the histogram
below.

12. How many cities could have an annual

rainfall of 28.5 in – 32.5 in?

a. 6 b. 9 c. 8 d. 12
13. How many intervals could represent an
annual rainfall of 30 in – 36 in?

a. 2 b. 4 c. 3 d. 5

For numbers 14-15, use the given histogram below.

14. If 85 is the lowest score a student can

earn to receive a B, how many students
received at least a B?

a. 4 b. 10 c. 6 d. 15
15. How many students scored a 77 on the
test?

a. 0 c. 6
b. 1 d. cannot be determined

Additional Activities

Instructions: Use the given data below to make graphs. Note: Use all graphs that are
appropriate to the given data. Draw your graphs in your notebook or on a separate sheet of
paper.

14
 Senior High School

Business
Mathematics
Quarter 2 – Module 16:
Measures of Central Tendency
and Variability

Writer:
WILLIAM M. ELIGIO
Teacher-II Potrero National High School
Editors:
JANE P. VALENCIA, Ed.D. – EPS – Mathematics (CHAIRMAN)
CHARIZEL T. ARCILLA – SPST-I Malino National High School
JHOANNA S. MANALOTO – T-II San Juan High School (Mexico)
 What I Need to Know

This module was designed and written with you in mind. It is here to help you master the
Measures of Central Tendency and Variability.

After going through this module, you are expected to:

1. Compare forms (textual, tabular, and graphical) of data;

2. identify the essential parts of a table;
3. draw the table to present the data; and
4. analyze and interprets the data presented in the table using measures of central
tendency;

What I Know

Pre- Assessment

Direction: Choose the letter of the best answer. Write the chosen letter on your notebook or
on a separate sheet of paper. If you are not aware or unsure of some items, choose the answer
that is best based on your perception. Then go back to those items as you continue with the
lesson.
1. Is the quotient of the sum of the quality and the number of quantities?
a. Mean b. Median c. Mode d. Variability

2. Is the most frequently occurring entry?

a. Mean b. Median c. Mode d. Variability

3. Is the middle score of an ordered list data?

a. Mean b. Median c. Mode d. Variability

4. It is the positional average and not easy to influenced by extreme scores.

a. Mean b. Median c. Mode d. Variability

5. The scores of 15 students in Math tests are 7, 9, 10, 6, 15, 12, 11, 11, 11, 12, 14, 10,
9, 7, 6. Find the mean.
a. 13 b. 12 c. 11 d. 10

6. The sum of 10 test scores is 400. What is the mean score?

a. 50 b. 45 c. 40 d. 35

7. Most reliable to use and easily influenced by extreme scores.

a. Mean b. Median c. Mode d. Variability
For numbers 8-10, determine the Mean, Median and Mode from the set of data. (2,4,5,7,7,8,9)

8. Mean
a. 5 b. 6 c. 7 d. 8
9. Mode
a. 4 b. 5 c. 6 d. 7
10. Median
a. 5 b. 7 c. 8 d. 9

2
 11. Is a value that is used to describe the spread of a set of data.
a. Measures of central tendency c. measures of equipment
b. Measures of equivalents d. Measures of Variation
12. It is the difference between the highest and the lowest.
a. Mean b. Median c. Quartiles d. Range
13. The points which the set of data into four parts.
a. Mean b. Median c. Quartiles d. Range
14. It is the difference between the third quartile and the first quartile.
a. First quartile c. Variables
b. Interquartile Range d. Second quartile Range
15. Which of the following is NOT present all the time in a set of data?
a. Mean b. Median c. Mode d. Variability

Lesson
Measures of Central
1 Tendency and Variability

Measures of central Tendency and Variability

As you go to this lesson try to analyze the importance of studying the different ways of
presenting business data, how to interpret and construct charts and graphs for any given
data. By developing the necessary knowledge and skills, you will be able to solve real-life
word problems involving business data.

What’s In

Direction: As a recall on the previous lesson on spreadsheet for computation and presentation,
complete the table below using spreadsheet.

NAME INCOME DEDUCTIONS Net

BASIC ALLOW GROSS GSIS PHIL PAG- TAX TOTAL Income
SALARY ANCE INCOME 9% HEAL IBIG 11% DEDUCTIO
TH 2% 1% N
Quarantino 15,000 2,000
Coronalyn 20,000 2,000
Pandemicah 25,000 2,000
Locke Dawne 40,000 2,000
Mark Encob 50,000 2,000

3
 What’s New

The following data are the daily earnings from sales of two stores:
Let us analyze the data and answer the following question on your notebook or on a separate
sheet of paper.

Daily 200 10 380 0 20 390 400 200

Earnings
Store A
Daily 199 200 200 195 210 201 190 205
Earnings
Store B

1. Which store has more earnings? Why?

2. Which of the two stores gas more consistent daily earnings? Why?

3. What is the mean, median and mode of store A?

4. What is the mean, median and mode of Store B?

5. Compare the computed averages of the daily earnings from sales of sari-sari store A
and B.

What is It

PRESENTATION OF DATA
• This refers to the organization of data into tables, graphs or charts, so that logical and
statistical conclusions can be derived from the collected measurements.

• Data may be presented in three methods

o Textual o Tabular o Graphical

• Textual presentation – the data gathered are presented in paragraph forms. The data
are written and read and it is a combination of texts and figures.
Example:
Of the 150 sample interviewed, the following complaints were noted: 27 for lack
of books in the library, 25 for a dirty playground, 20 lack of laboratory equipment, 17
for not well maintained university buildings.

• Tabular presentation – methods pf presenting data using the statistical table. A

systematic organization of data in columns and rows.

4
 • Graphical Presentation – Presentation using graphs
Kinds of graphs: Bar graph, Pie or circle graph, Line graph and Pictograph

Bar Graph

Pie or Circle graph

Line Graph

Pictograph

Presentation of data can be interpreted and analyze by using Measures of Central Tendency
and Measures of Variation

Measures of Central Tendency Defined

• A single number that can represent the entire number or set of values.
• A single figure which is the representative or summary of the characteristics of a given
set of data.

Most commonly used measures of central tendency

• Mean - is defined as the sum of all items or terms divided by the total number of
items or terms.
• Median - is the middlemost number/term that divides an arranged (either ascending
or descending order) distribution into two equal parts.

5
 • Mode - is the number that occurs most frequently more than any other number in a
given set of data.

FORMULA IN COMPUTING THE MEAN Characteristic of Mean

• Easy to compute.
• Most reliable.
• Influenced by extreme scores
(outliers)

MEDIAN

Steps and formula in computing the median

Characteristics of Median

• Is the middle score

• It is a positional average
• Most stable
• It is not easily influenced
by extremes scores.

MODE

• Most occurring number in an array of data

• An array of data can have no mode
• Find the most frequent number to identify the mod

Three types of modes

1 mode = Unimodal; 2 modes = Bimodal; 3 or more modes = Multimodal

MEASURES OF VARIATION
• Is a value that is used to describe the spread of a set of data. If a measure of central
tendency gets the typical value, the measures of variation determine the discrepancy
or difference between the data.

• Range – It is the difference between the highest and the lowest entries.

• Quartiles are points which divide the set of data into four equal parts.

• There are three quartiles: Q1 Q2 Q3

• Q1 – The first quartile or the lower quartile is the value that separates the lower
25% from the higher 75% of the scores: Q1 = ¼ x N

• Q3 – The third quartile or the higher quartile is the value that separates the lower
75% from the higher 25% of the scores:
Q3 = ¾ x N

• Q2 – The second quartile is the median Q2 = Median

• Interquartile Range (IQR): It is the difference between the third quartile and the first
quartile.
IQR = Q3 – Q1
Note: the quartiles are computed similar to the median.

6
 What’s More

Activity 1.1 Computation of mean

Suppose you have six scores in your Mathematics quizzes: 12, 10, 18, 16, 20, and 14. What
will be your mean score now?

Formula
MEAN = Sum of all scores / Number of cases

Activity 1.2 Computation of median

Find the median from the fruits sold from the month

Formula

MEDIAN = (n + 1) / 2
Activity 1.3 Find the mode

The following are your kilowatts consumption from your home for 2019

Chuckie Chan keeps the record of seamen’s remittances. Listed below are the remittances (in
thousands of pesos) of the seaman for the first three quarters of 2019

month Jan Feb Mar Apr May Jun Jul Aug Sept
Remittance 34 27 50 54 40 43 65 63 59

Find the median, range, and interquartile.

7
 What I Have Learned

Fill the spaces with appropriate answer base on the discussion about presenting data using
measures of central tendency and measures of variation. Write your answers in your notebook
or on a separate sheet of paper.

1.___________ is a single number that can represent the entire number or set of values.

2.___________ is defined as the sum of all items or terms divided by the total number of items
or terms.

3.___________ is the middlemost number/term that divides an arranged (either ascending or

descending order) distribution into two equal parts.

4.___________ is the number that occurs most frequently more than any other number in a
given set of data.
5.____________ is a value that is used to describe the spread of a set of data.

6.____________ is the difference between the highest and the lowest entries

What I Can Do

In Betty Book library four students (Ayudalyn, Coronaliza, Socialito, and Distantino) borrow
books every day.
Monday (Ayudalyn 12, Coronaliza 7, Socialito 10 and Distantino 3)

Tuesday (Ayudalyn 14, Coronaliza 11, Socialito 13 and Distantino 15)

Wednesday (Ayudalyn 16, Coronaliza 16, Socialito 12 and Distantino 18)

Thursday (Ayudalyn 10, Coronaliza 6, Socialito 5 and Distantino 12)

Friday (Ayudalyn 8, Coronaliza 2, Socialito 3 and Distantino 8)

Name Monday Tuesday Wednesday Thursday Friday

Ayudalyn

Coronaliza

Socialito

Distantino

Fill up the boxes using the data from Betty Book Library (5pts) and answer the following
questions on your notebook or on a separate sheet of paper. Don’t forget to show your
complete solution.
1. What is the mean from the total books borrowed on Monday?
2. What is the mode from the borrowed books on Wednesday?
3. What is the median from the borrowed books of Socialito?
4. What is the mean from the borrowed books of Ayudalyn?
5. What is the mode from the total borrowed books for the week?
8
 Assessment

A. Write TRUE if the statement is correct; otherwise, write false.

1. The mean is the average of the values in a set of data.
2. The median and the mode are always the same in a given set of data.
3. The mode is the data value that occurs most frequently in a set of data.
4. The median is the value that occurs most often in a set of data.
5. If the sets of data have the same mean, median, and mode, then they exactly the same
data values.

B. Refer to the given table below.

Number of Pieces of Fruit Sold in a Week
Fruit Monday Tuesday Wednesday Thursday Friday
Apple 35 40 20 45 30
Orange 32 42 25 38 23
Mango 35 45 40 40 30
Grapes 35 46 35 36 30
Strawberry 30 40 20 34 28

Determine the following

a. Mean of the sold apples in the whole week

b. Median of the sold mangoes in the whole week
c. Mode of the sold fruits on Monday
d. Median of the sold fruits on Thursday
e. Mean of the sold fruits on Wednesday
f. Median of the sold Mango in the whole week
g. Mode of the sold Grapes for the week
h. Mean of the sold Strawberry for the week
i. Mode of the sold fruit on Friday
j. Median of the sold fruit on Wednesday

Additional Activities

Fill in the question mark following the proper way of computing mean median and
mode

3 5 3 2 MODE=?

8 10 ? 13 MEAN =9

1 ? 6 10 MEDIAN=5

5 5 13 ? NO MODE

10 10 10 ? MEAN = 11