Bis Math 2nd Quarter
Bis Math 2nd Quarter
Bis Math 2nd Quarter
Quarter 2 - Module 2
Prepared by:
Hernono D. Lopez Sr., DM
Legal History
TESDA: Technical-Vocational
St. Ignatius Technical College, Inc. with business address at Zone 11, National
school for secondary graduates who intend to pursue technical studies on Computer
Commission on October 29, 2003 through its Registration No. CN 200322733. The school
started its operation by offering TESDA courses namely: Two Years Diploma in Computer
Technician and Two Years Diploma in Computer Programming. SITC has run these
programs for almost three years before each respective title was changed.
In 2007, TESDA Director General issued a directive that all diploma courses will
be delivered based on the number of hours as determined and prescribed by the technical
school management. Consequently, SITC diploma courses were changed from Diploma
successfully delivered the same computer courses under their new titles until 2011.
Another mandate was released by TESDA Director General in 2011, limiting the
With such mandate, Computer Hardware Servicing NC II with 1,800 hours duration of
course delivery was limited to 292 hours only, since that year up to the present. TESDA
the program. SITC continue its operation with only one program being offered to students.
In 2015, when the demand for Bookkeeping NC III was rising, SITC management
endeavored to apply with TESDA R10 to offer the course and luckily the Tech- Voc
agency on April 23, 2015 granted a Registration No 201510043033, WTR 2436 for
Bookkeeping NC III 292 hours duration of course delivery. Since May 2015 up to the
In July, 2015 when the Department of Education (DepEd) encouraged the private
school owners to participate in the delivery of the new program of the basic education
which was the senior high curriculum, SITC management endeavored to apply through
DepEd Central Office. After compliance with all the requirements asked by the education
agency submitted through DepEd regional and provincial offices, the school was granted
a Government Permit No. 230, s. 2015 on December 10, 2015 to operate one Academic
During SY 2016-2017, while the delivery of two senior high school tracks were
going on, many parents as well as graduating junior high students kept on requesting
SITC management to offer another academic track which was Humanities and Social
apply to offer HUMSS for the next SY 2017-2018. Luckily, on May 8, 2017 DepEd, RO-
Again, owing to the persistent demand of many prospective senior high students
endeavored to apply for a new permit to deliver Automotive Servicing NC I & NC II. On
July 19, 2019, a DepEd RO-X, Government Permit SHS P-155, s. 2019 was granted to
To date, SITC is delivering four tracks: two academics (ABM and HUMSS) and two
Vision Statement
St. Ignatius Technical College, Inc. will be a premier private institution in Tagoloan,
senior high school tracks and technical training and prepare our diverse student body for
emerging technical areas as well as general knowledge that fosters a life of learning.
Mission Statement
St. Ignatius Technical College, Inc. strives to prepare all students to become
lifelong learners, law-abiding and responsible citizens ready to face the challenges of the
opportunities for students-both inside and outside the classroom – that help them develop
the knowledge, critical thinking skills, and human behavior needed to succeed in a
technologically advanced world; thus, realizing our value proposition of “Real Learning,
Core Values
To fulfil its mission, St. Ignatius Technical College, Inc. is committed to the
following values:
that our students are well positioned for success in career and technical fields,
taking attitude.
Page
St. Ignatius Technical College Inc. Vision, Mission and Core Values iv-v
Introduction 1-2
References 89
You are about to start your study on Module 2 for your subject BUSINESS
MATHEMATICS. To get much result from your effort, please observe the following:
3. Ensure that you have a scientific calculator at hand always when you start
5. Read your lesson at least three times (3X) to ensure you have understood the
concept and ideas presented in the lesson.
7. If you think you have digested the lesson very well, you may now take your
quizzes and assessments.
8. Perform all the Pre-Tests as well as the Practice Exercises and study very well
the sample problems and solutions to increase your math skill.
9. Do not attempt to copy the answer from your lesson. This is a home study
method; you will learn nothing if you cheat as you are just fooling yourself. Study honestly.
10. Follow all the instructions stipulated in each activity and quiz.
13. You are only allowed to contact your subject teacher during the subject
schedule. Only relevant topics will be entertained and treated as an official interaction
between you and the teacher. Personal matters are prohibited.
15. All hard copies of your outputs should be filed in a long white folder with plastic
cover and fastener. This will serve as your portfolio and a requirement for this subject and
will be submitted at the end of the quarter.
17. Any question on any part of your lesson(s), just call or text this cell number:
09356521692 – Ma’am Jessa B. Manglay
Learning Competencies
Lesson Objectives
General Instructions
Plain Commission
Most sales agents earn commissions only. They are not paid any salary. Therefore, they exert their
best effort to increase their sales because the more they sell, the more they earn. Computation of the
commission makes use of the basic formula we learned, P = BR. The commission is the percentage (P),
the sales is the base (B), and the commission rate is the rate (R).
Examples:
1. Carmen Yambao is a sales agent for the High Ace Realty. She is paid based on commission
only. She is given a 2% commission on her sales. For the current month, her sales was ₱1 035
000.00. Her commission (which is also her gross earning) would be:
Commission = ₱1 035 000.00 x 2%
= ₱20 700
2. Jed Montenegro is a car sales agent. He is paid commission only at the rate of 2.5%. For the
current month, he sold two cars totaling ₱1 875 000.00. His commission (gross earnings) would
be:
Commission = ₱1 875 000.00 x 2.5%
= ₱46 875.00
Using our foregoing example for commission only, and assuming that Carmen Yambao and Jed
Montenegro are employees with basic salary, the gross earnings of Carmen and Jed would be as follows.
1. Carmen Yambao’s gross earnings assuming a basic salary of ₱10 000.00 per month:
Gross Earning = Basic Salary + Commission
= ₱10 000 + ₱1 035 000 x 2%
= ₱10 000 + ₱20 907
= ₱30 907
2. Jed Montenegro’s gross earnings assuming a basic salary of ₱12 500.00 per year month:
Gross Earnings = Basic Salary + Commission
= ₱12 500 + ₱1 875 000 x 2.5%
= ₱12 500 + ₱46 875
= ₱59 375
In certain cases, however, a sales employee that is given a basic salary earns commission on sales
above a certain figure. For example, Eugene Tito is a sales representative earning a basic salary of ₱18
000.00 a month plus 3% commission on his sales exceeding his quota of ₱15 000.00. Assume he made a
total sales of ₱36 000.00 for the current month. Find his gross earnings.
Compute for her gross earning if she sells a total of ₱75 360.00 for the past month.
For people who have people under them doing the sales, overrides are given by their companies
in addition to their basic salary. Product managers and sales or marketing managers earn overrides. For
example:
M. Coronilia is a product manager with five sales representatives under him. The company gives
1
him an annual salary of ₱126 000.00; commission of 5% on his own sales; and an override of 2% on his
men’s sales. Find his gross earnings for the month if his total sales is ₱365 500 with his men able to sell a
total of ₱1 548 263 for the month.
Solution:
Annual salary
Basic salary = 12
₱126 000
= 12
= ₱36 516.32
In certain cases, managers, and even salespersons are given transportation allowance and/or
representation allowance. Just remember that any allowance given a person is in addition to the basic
salary, commission, and override that he or she is entitled to. Let us take the following example:
Emmanuel Joshua is a marketing manager. He earns a basic salary of ₱12 500.00 per month. He
earns a 3% commission on his own sales and a 1% override on the sales of his men. In addition, he is
granted a transportation/representation allowance of ₱1 000.00 per month. For the current month, his men
= ₱20 200
What we have so far are commissions on cash basis, that is, for cash sales. If the sales are on
installment basis, companies do not give commission based on sales. Rather, they are given commission
based on collection, that is, payment made by the buyers. Assuming a sale of ₱120 000.00 paid in monthly
installments of ₱10 000.00, the commission is based on the ₱10 000.00 payment made by the buyer.
Therefore, if the commission paid is, say, 3%, the monthly commission would be 3% x ₱10 000 = ₱300.
QUIZ 1
1. Abram is a sales representative receiving an annual salary of ₱180 000.00 plus commission on all
his sales above quota of ₱30 000.00 in accordance with the following schedule.
1
First ₱30 000 above quota - %
2
Next ₱50 000 - 1%
Next ₱70 000 - 2%
Over ₱150 000 - 3%
Compute for his gross earnings if his sales for the month:
a. ₱28 500
b. ₱37 900
c. ₱58 200
d. ₱92 300
2. Jan is a sales manager receiving a monthly salary of ₱18 000.00, a commission on his 5% on his
sales, and a monthly transportation allowance of ₱5 000.00. He is also given an override of 1% on
his men’s sales. For the month of August, Jan sold a total of ₱110 000.00. His men sold a total of
₱380 500.00. Compute for his gross earnings.
Lesson Summary
• Sales agents and brokers are generally paid commissions as incentives for increasing a firm’s
sales. Some of these sales agents or broker are paid solely through commission or what is termed
as plain commission. Their gross earnings would be their total commission.
• Other sales agents and brokers are paid basic pay plus commission. Their gross earnings would
be their basic pay plus their commission.
LESSON 1 ASSESSMENT
1
1. Peter is a broker who earns commission of 3 2 % on all securities sales that he makes. For the past
year, he closed sales totaling ₱928 867. Find the amount of commission he earned for the year.
2. Roger is a sales engineer receiving a basic monthly compensation of ₱13 500.00 and commission
on all sales of 1%. Compute for his gross earnings for the month if he sold ₱124 580.00.
3. Alex is a straight commission salesman. He is given commission on the basis of the following
schedule:
Monthly Sales
Less than ₱50 000 ……………………………….. 1%
₱50 000 – 99 999 ………………………………… 2%
₱100 000 – 149 999 …………………………….. 3%
₱150 000 and above ……………………………. 4%
Compute for his commission assuming his total sales is:
a. ₱75 800
b. ₱49 900
c. ₱151 200
d. ₱123 500
4. Moses is a sales representative receiving an annual salary of ₱130 000.00 plus commission on all
his sales above quota of ₱25 000.00 in accordance with the following schedule:
1
First ₱30 000 above quota - %
2
Next ₱50 000 - 1%
Next ₱70 000 - 2%
Next ₱150 000 - 3%
Compute for his gross earnings if his sales for the month:
a. ₱24 800
b. ₱57 600
c. ₱67 700
d. ₱120 300
5. Engelbert is a Marketing Manager earning an annual salary of ₱150 000, a commission in his own
1 1
sales of 2%, and on override of 2 % on his men’s sales. His men are entitled to 4 4 % commission
on their own sales plus a basic monthly of ₱8 600 and transportation allowance of ₱1 200.
Compute for the gross earnings of Engelbert and each of his men.
Learning Competencies
Employment law does not provide a specific definition of a wage or salary earner.
However, generally speaking, the term “wages” is used where the amount of money the
employee receives may vary from one pay period to the next, as the amount paid is
directly dependent on the amount of hours worked; and the term “salary” refers to an
agreed and fixed annual amount of money the employee receives regardless of the hours
worked.
Wages
Piece Rate
Examples:
1. Tammy is paid on a per-piece basis at the rate of ₱1.20 per piece. If she
finishes 360 pieces a week, how much is her total earnings?
Given: Rate = ₱1.20 per piece
Quantity produced = 360 pieces (base)
Find: Total earnings
Solution: Total earnings = Quantity x Rate
= 360 x ₱1.20
= ₱432.00
2. Linda is employed to repack and seal pepper. She is paid on the following
differential pay plan schedule:
For the week, Linda repacked the following quantities: Monday, 95;
Tuesday, 102; Wednesday, 130; Thursday, 152; and Friday, 201. Compute for her
total wage for the week.
Solution:
Total
₱723.10
Rake note that dividing by 100, we move the decimal point two places to
the left, so 10 710 becomes 107.10; 13 650 becomes 136.50; 16 340 becomes 163.40;
and 22 110 becomes 221.10.
OR
Then, we multiply the quantity produced by the piece rate thus obtained:
Total ₱723.10
Hourly Rate
Many employees are paid on an hourly basis. To compute for the pay, we simply
multiply the number of hours of work by the hourly rate. For example, if an employee
worked for 40 hours during the week and his or her rate is ₱10.00 per hour, his or her
wage is 40 hours x ₱10.00/hour = ₱400.00.
Employees who work more than the required number of hours are entitled to
overtime pay. Overtime premium refers to the excess payment over the regular rate. The
following are the different articles of the Labor Code relevant to normal hours and
overtime work.
1. Article 83 of the Labor Code enunciates that the normal hours of work of any
employee shall not exceed eight (8) hours a day. This is exclusive of the one
(1) hour lunch break. Article 85 provides that subject to such regulations as the
Secretary of Labor may prescribe, it shall be the duty of every employer to give
his or her employees not less than sixty (60) minutes time-off for their regular
meals.
2. Article 87 provides that work may be performed beyond (8) hours a day
provided that the employee is paid for the overtime work an additional
compensation equivalent to his regular wage plus at least twenty-five percent
(25%) thereof. Work performed beyond eight hours on a holiday or rest day
shall be paid an additional compensation equivalent to the rate of the first eight
hours on a holiday or rest day plus at least thirty percent (30%) thereof.
3. Article 93 provides that:
a. Where an employee is made or permitted to work on his or her scheduled
rest day, he or she shall be paid an additional compensation of at least thirty
percent (30%) of his or her regular wage. An employee shall be entitled to
Assuming that the minimum daily wage rate is ₱340.00, how much is the overtime
rate per hour?
On Ordinary Day
= ₱340.00 + ₱106.25
= ₱446.25
Employees generally have their rest days, which may not fall on a Sunday. If an
employee is made to work on a Sunday, his or her rest day could be Monday or any other
day of the week to compensate for the Sunday that he or she worked. If an employee is
made to work on his or her rest day or an a special holiday like Maundy Thursday or Good
Friday, which dates are not fixed, the computation of his or her pay would be as follows:
Compute the hourly rate of the employee on a rest day or special day. The hourly
rate on rest day and special days is 130% of the regular rates:
Overtime rate = Hourly rate on rest day + 30% Hourly rate on rest day
= ₱55.25 + ₱16.575
= ₱71.825
= ₱442.00 + (2 x ₱71.825)
= ₱585.65
Compute the hourly rate of the employee on a rest day which falls on a special
day:
Overtime rate = Hourly rate on rest day + 30% of Hourly rate on rest day
Alternatively,
a. She worked for 8 hours. Her total pay for the day would be:
Total pay for the day = 8 hours x Regular hourly rate x 150%
=8 x (₱42.50 x 150%)
=8 x ₱63.75
= ₱510.00
b. She worked for 10 hours. Her total pay for the day would be:
Total pay for the day = [8 hr. x (₱42.50 x 150%)] + (2 hr. x [(₱42.50 x 150%) x
130%)]
= 8 hr. x ₱63.75 + 2 hr. x (₱63.75 x 130%)
= ₱510 + (2 x ₱82.875)
= ₱510 + ₱165.75
= ₱675.75
On a Regular Holiday
= ₱85.00 + ₱25.50
= ₱110.50
Alternatively,
= ₱85.00 x 130%
= ₱110.50
a. She worked for 8 hours. Her total pay for the day would be:
Total pay for the day = 8 hours x 200% of Regular hourly rate
= 8 x 200% x ₱42.50
= 8 x ₱85.00
= ₱680.00
b. She worked for 10 hours. Her total pay for the day would be:
Total pay for the day = [(8 hours x 200% of Regular hourly rate + {2 hours x (200%
of
Regular hourly rate x 130%)}]
= (8 x ₱42.50 x 200%) + {2 x (₱42.50 x 200% x 130%)}]
= (8 x ₱85.00) + (2 x ₱110.50)
= ₱680.00 + ₱221.00
= ₱901.00
Hourly rate = 260% of Regular hourly rate (on a rest day which falls on a regular
holiday)
= 260% x ₱42.50
= ₱110.50
Overtime rate = Hourly rate on rest day + 30% of Hourly rate which falls on a
regular
holiday
= ₱110.50 + ₱33.15
= ₱143.65
Alternatively,
Overtime rate = Hourly rate on rest day which falls on regular holiday x 130%
= ₱110.50 x 130%
Example: Teresita earns the regular daily rate of ₱340.00 giving her an hourly rate
of ₱42.50. She was requested by her boss to work on December 30, Rizal Day,
which is a regular holiday. However, Rizal Day fell on a Monday, which was
Teresita’s rest day.
a. Teresita worked for eight hours. Her total pay for the day would be:
Total pay for the day = 8 hours x Regular hourly rate x 260%
= 8 x ₱42.50 x 260%
= ₱884
b. She worked for 10 hours. Her total pay for the day would be:
Total pay for the day = [(8 hours x Regular hourly rate x 260%) +(2 hours
x
{Regular hourly rate x 260%} x 130%]
= (8 x ₱110.50) + (2 x ₱143.65)
= ₱884.00 + ₱287.30
= ₱1 171.30
For the following exercises and assignments, the premiums therein stated are
theoretical and strictly used for problem-solving purposes and may not follow rates set by
law. In practice, companies may pay more than what is prescribed by law, but never below
the same.
Examples:
1. Joselito is paid on an hourly basis. Forty hours a week is considered his regular
hours and anything in excess is considered overtime. His regular rate is ₱15.00
per hour and he is paid 25% premium on overtime. He worked for the following
hours for the past week:
Monday - 8 hours Thursday - 10 hours
Tuesday - 4 hours Friday - 8 hours
Wednesday - 8 hours
Required: Compute for his gross earnings using the formula: Gross earnings
= Number of hours worked x Hourly rate.
Monday -8
Wednesday - 8
Thursday - 10
Friday -8
x ₱15/hour
2. Assuming that instead of 8 hours for Wednesday and Friday, Joselito worked
10 hours for those days. To get the total hours worked, we add 8 + 4 + 10 + 10
+ 10 to get 42.
Gross earnings = Regular pay + Overtime pay
OR
OR
We can multiply the regular rate by the premium, hence, ₱15 x 1.25 =
₱18.75. ₱18.75 is, therefore, the employee’s overtime rate. Therefore, to
compute for total pay,
3. In example (1), if Joselito is paid overtime on all hours in excess of 8 hours per
day, how much is his gross earnings?
Joselito only worked more than 8 hours on Thursday (10 hours).
Solution: Regular earnings = (8 + 4 + 8 + 8 + 8) ₱15.00
= 36 hours x ₱15.00
= ₱540.00
Overtime earnings = 10 – 8 = 2 hours x ₱15 x 1.25 = ₱37.50
Total earnings = Regular earnings + Overtime earnings
= ₱540.00 + ₱37.50
= ₱577.50
Note: Joselito is entitled to overtime (OT) pay on the 2 hours excess he worked
on Thursday (10 hours – 8 hours).
To find his overtime rate, we simply multiply his regular by 1.25, thus,
₱15.00 x 1.25 = ₱18.75.
To use this, we compute for
Regular earnings = 36 hours x ₱15.00 = ₱540.00
Overtime earnings = 2 hours x ₱18.75 = 37.50
Total earnings = 38 hours = ₱577.50
Salary
1 month = 2 semi-monthly
2
semi-monthly = every month
5
Let us study the following conversions, assuming an annual salary of ₱72 000:
Annual salary ₱72 000
1. Monthly salary = = = ₱6 000
12 12
Annual salary ₱72 000
2. Semi-monthly salary = = = ₱3 000
24 24
OR
Annual salary ₱72 000
3. Weekly salary = = = ₱1 348.62
52 26
Annual salary ₱72 000
4. Bi-weekly salary = 26
= 26
= ₱2 769.23
OR
= Weekly salary x 2 = ₱1 348.62 x 2
= ₱2 769.24*
To convert monthly salary into hourly rate, we first determine the number of regular
hours in a workweek. Some companies have 40-hour workweek while others have 48-
hour workweek.
₱1 384.62
= = ₱34.6155 = ₱34.62
40
₱1 384.62
= = ₱28.84625 = ₱28.85
48
Income is a broader term than wages or salary. Wages and salaries are income to
the persons receiving it. However, for people who are not employees, their income may
not be in the form of wages or salaries. They can have their commission income if they
are paid for the commission on sales they make, rental income if they have properties
they rent out, dividend income if they are stockholders, royalties if they are authors, and
other income for whatever endeavor they engage in including profit-making business. A
business firm’s income is in the form of profits that the business earns that we have
studied in the preceding chapter.
Examples:
1. Janine is a stockholder of the Wisdom Corporation. For the current year, the
corporation declared 10% cash dividend to stockholders. Janine owns 1 000
shares of the company’s ₱10.00 par value shares. To compute for her dividend
income, Janine’s dividend income = No. of shares x Par value x Dividend rate
= 1 000 shares x ₱10.00 x 10% = ₱1 000
2. John Abram is an author and his book sold 10 000 copies for the first semester.
His book sells at ₱375 per copy. He receives a 22% royalty from his publisher.
His royalty income would be:
John Abram’s royalty = 2 500 x ₱375 x 22% = ₱206 250
Employee Benefits
Employee benefits cover remuneration other than basic pay. It includes vacation
and sick leaves, medical and hospitalization benefits, meal allowance, transportation
allowance, clothing allowance, etc., and incentive pay for the productivity such as
commission, overrides, bonuses, and profit-sharing. For the Philippines, the following
benefits are given to employees:
• Vacation pay: Thirteen (13) vacation days, with additional one vacation day every
year starting on second year of service and convertible to cash at the end of each
year. Maximum total vacation leave is 18 days.
• Sick leave: Twelve (12) days per year for the first two years of service. With
additional one sick leave every year starting on second year of service. Maximum
total sick leave is 15 days. All unused leave days are convertible to cash in
December of each year.
• Holiday pay: (Please see Appendix F for the list of Philippine Holidays for 2016.)
In lieu of vacation pay, Article 95 of the Labor Code provides for service incentive
leave for every employee who has rendered at least one year of service of 5 days with
pay.
The BIR issued Revenue Regulations No. 5-2011 limiting the items of ‘de minimis’
benefits that are exempt from withholding tax on compensation (WTC) or to Fringe
Benefits Tax (FBT) to the following:
QUIZ 2
1. Carmen is a worker in a textile firm. She is paid a regular hourly rate of ₱12.00.
She is paid “time-and-a-half=” for regular overtime (overtime done on regular
days) and “double-time” for overtime done on Sundays and holidays. The firm
has regular working days from Monday to Saturday. Carmen worked for the
following hours of the week:
2. In the above example (1), assume that the company considers overtime any
hours worked over 40 hours in a week. Let us recomputed Carmen’s earnings.
Lesson Summary
1. Compute the gross earning of the following piece-work employees. Check your
work using Excel.
Quantity Produced Pay Plan Total Earnings
a. 3 125 ₱0.25 per piece
b. 1 034 ₱0.275 per piece
c. 125 ₱1.05 for first 100,
₱1.15 for all others
d. 250 ₱0.50 for first 100,
₱0.65 for next 100,
₱0.80 in excess of 200
e. 86 First 20 - ₱0.30
21 – 30 -
0.32
31 – 40 - 0.35
41 – 50 -
0.39
51 – 60 -
0.44
61 – 70 - 0.50
Above 70 - 0.57
2. Find the gross weekly wage of the following employees. Check your work using
Excel.
Employees Production Piece Rate Gross Earnings
a. F. Morato 105 ₱0.30
b. A. Obidos 75 ₱2.50
c. I. Reyes 236 ₱1.15
d. T. Abad 25 ₱10.50
e. H. Lopez 6 ₱25.00
3. Rociano has a total production of 625 pieces. Find his gross earnings under the
following piece-rate plan:
a. ₱0.98 per piece
b. ₱1.1125 for the first 200 pieces
₱1.535 for the next 200 pieces
₱1.80 for all others
c. Less than 200 at ₱0.95/pc.
200 – 300 at ₱0.98/pc.
301 – 400 at ₱1.00/pc.
401 – 500 at ₱1.05/pc.
4. Carissa, Erika, Mervin, and Rhogel are working in a factory producing different
products and are paid on a per-piece basis weekly. Following are their production
for the week:
Quantity Rate/100 pc.
B ₱11.25 8 8 4 12 12
C ₱12.75 - 10 10 10 8
a) Place your computation on a yellow legal pad paper.
b) Use excel.
2. Using date in (1) above, compute for the gross earnings of A, B, and C assuming that
overtime is paid for time in excess of 8 hours a day.
a) Place your computation on a yellow legal pad paper.
b) Use Excel.
A
B
C
3. E. Razon is waiter at the Kalye Fiesta. His rest day is Wednesday. He is paid overtime
in excess of 40 hours a week. His hourly rate is ₱13.75. For the week, he worked for
1
50 hours, excluding the 5 2 hours he rendered on Wednesday. His regular overtime
premium is 25% and his holiday overtime premium is 100%. Compute his gross
earnings.
1
17 – 30 minutes - hour deduction
2
3
31 – 45 minutes - hour deduction
4
In Out In Out
5. Vida M. works for a company that pays for hours worked over 48 in a week. For regular
overtime (hours over 48 in a week), the company pays time and a half. For overtime
on Sundays and holidays, the company pays double-time. Compute for Vida M.’s
earnings for the week detailing her regular pay, her regular overtime pay, and her
Sunday/holiday pay given the following:
Monday 8 hours
Tuesday 10 hours
Wednesday 12 hours
Thursday 8.5 hours
Friday 10.5 hours
Saturday 5 hours
Sunday 5 hours
PAYROLL DEDUCTIONS
Learning Competencies
An employee generally does not receive his or her gross earnings intact every
payday. There are certain deductions from gross earnings to arrive at or compute for an
employee’s net pay or take-home pay. These deductions may include, among others, the
following:
All employees of private enterprises are covered by the Social Security Service.
Self-employed individuals can also become members. The monthly contributions are
based on the compensation of members. The current SSS contribution rate is 11% of the
monthly salary credit not exceeding ₱16 000.00 and this is being shared by the employer
(7.37%) and the employee (3.63%). The table of SSS contributions is in Appendix C.
Self-employed and voluntary member pays 11% of the monthly salary credit (MSC)
based on the monthly earnings declared at the time of registration. For OFWs, the
minimum monthly salary credit is pegged at ₱5 000.00. For the non-working spouse, the
contribution will be based on 50% of the working spouses last posted monthly salary
credit but in no case shall it be lower than ₱1 000.00.
Withholding Taxes
To be able to compute your BIR Withholding Tax for the month, the following
information are needed. You may want to check out your pay slips for the other
information.
That would be the result of ₱15 000 + ₱2 500 - ₱500 - ₱500 - ₱250 - ₱100.
Your tax will be computed based on your taxable income. The tax can be computed
with the help of the BIR Withholding Tax Table.
Using the BIR Withholding Tax Table, look for the nearest amount to your taxable
income which is ₱16 150. Look under the monthly category.
In this case, the nearest value is the ₱15 833. Take note of the tax rates above and
the amount above it. Now, we got three important factors in computing your BIR
Withholding Tax Table: ₱15 833, ₱1 875, and lastly the +25% over.
₱79.25 + ₱1 875.00 = ₱1 94.25 your BIR Withholding Tax for the month
The Home Development Mutual Fund (HDMF), more popularly known as the Pag-
Ibig Fund, was established to provide a national savings program and affordable shelter
financing for the Filipino workers. The Fund offers its members short-term loans and
access to housing programs. It is mandatory for all SSS- and GSIS-covered employees;
uniformed members of the AFP, BFP, BJMP, and PNP; as well as Filipinos employed by
foreign-based employers. With the signing of Republic Act No. 9679, membership to the
Fund shall be mandatory for the following:
Example: Joy receives a basic pay of ₱8 500.00 a month and a 1% commission on her
sales. She sold ₱65 000.00 for the month. Her deductions are: 4% for SSS based on her
basic monthly pay; ₱100.00 for PhilHealth; Pag-Ibig, 2%; and 10% Withholding Tax based
on gross earnings. Compute for her net pay.
= ₱9 150
= ₱9 150 - ₱1 538
= ₱7 612
Salary Graph
We can graphically resent details of a person’s gross earnings. This is best shown
using a pie graph. We simply have to compute the corresponding percent of the
deductions and the net pay with the gross earnings representing 100%. For our example
above regarding Joy’s earnings, let us summarize the data:
PhilHealth
Pag-Ibig
W Tax
Net Pay
SSS
QUIZ 4
1. Find the gross earnings of each of the following employees using Excel:
No. of Article Total Piece Gross
Employee M T W Th F Articles Rate Earnings
Aireen 26 13 22 25 30 _______ ₱2.05
_______
Beverly 18 28 25 19 22 _______ ₱3.98
_______
Catherine 9 12 15 8 10 _______ ₱10.75
_______
David 110 95 97 122 112 _______ ₱0.97
_______
2. Michaela receives a monthly salary of ₱28 500.00. Compute for her:
a. Annual salary d. semi-monthly salary
ST. IGNATIUS TECHNICAL COLLEGE, INC. NOT FOR SALE 37
b. Weekly salary e. bi-weekly salary
c. Daily rate for 5-day week f. hourly rate for 40-hour week
Lesson Summary
• The take-home pay of an employee is his or her gross earnings less certain payroll
deductions.
• The monthly contributions are based on the compensation of members. The
current SSS contribution rate is 11% of the monthly salary credit not exceeding
₱16 000 and this is being shared by the employer (7.37%) and the employee
(3.63%).
• PhilHealth contributions are intended for employees and their beneficiaries should
they have problems with their health. Employee share represents half of the total
monthly premium while the other half is shouldered by the employer. For
kasambahay or helper receiving a wage of less than five thousand pesos (₱5
000.00) per month, the employer will shoulder both the employee and employer
share based on the premium schedule.
• All government employees holding permanent and non-permanent positions are
members of the GSIS. Premium contributions are based on monthly
compensation.
• Withholding tax on compensation is the tax withheld from income payments to
individuals arising from an employer-employee relationship. Withholding Tax table
is also available from the BIR and in the Internet.
• With the signing of Republic Act No. 9679, membership to the fund shall be
mandatory.
LESSON 4 ASSESSMENTS
1. Myra is paid based on the number of pages she types. She is paid ₱5.00 per page
plus free meals. For the week, she typed 375 pages. The week being the last week
of the month, deductions are made from an employee’s gross earnings equivalent
to 4% of monthly earnings for SSS, ₱10.50 for Medicare, and 2% of monthly
earnings for Withholding tax. Myra had an advance which she is paying at the rate
of ₱5.00 per week. Myra’s earnings for the current month including the current
week is ₱8 000.00. Compute for Myra’s take-home pay.
2. Find the gross earnings of each of the following employees using Excel:
No. of Article Total Piece Gross
Employee M T W Th F Articles Rate Earnings
3. Esperanza is paid on a daily basis. She is paid ₱312.00 a day plus commission of
1.5% on all her sales. Her total sales for the month are ₱38 235.00. She worked
1 1
for a total of 24 days. Monthly deductions are 4 2% of the total monthly pay for
2
SSS, ₱75.00 for Medicare, and 3% of total monthly pay for Withholding tax. Union
dues every month is ₱20.00. Compute for her net pay.
1
6. Yo T. Amo worked for 452 hours during a regular week. In addition, she worked 4
1
hours on Saturday and 3 hours on Sunday. All hours spent over 40 hours during
2
the regular week (Monday to Friday) is paid 50% premium. Saturday work is paid
7. Below are the employees of the Summit Co., Inc. indicating their basic salary per
month. Consult the Appendices for the SSS contributions, PhilHealth contributions,
Pag-Ibig contributions, Withholding tax table. Compute for their net pay using
Excel.
Basic Monthly Salary
8. Atty. Aileen Montenegro derives income from several sources. She receives ₱25
000.00 a month as a part-time consultant to a law firm. She owns stocks of a
company that has currently declared a 15% cash dividend. She owns 1 000 shares
of the ₱100.00 par value stocks of the company. In addition, she owns a sole
proprietorship that earned ₱52 000.00 for the month. She also has investments in
various securities for which she earned a total of ₱5 680.00 for the month. Prepare
a pie chart that will show the composition of her total income for the month.
9. Baby Fernando has a basic annual salary of ₱720 000.00 she generally pays a
10% Withholding tax on her salary. She pays the regular 3.63% for SSS, ₱437.50
for PhilHealth, and 2% for Pag-Ibig. Prepare a pie chart to show the composition
of her gross earnings.
Lesson Competency
We talked about tables, graphs, and charts. How are they different from each
other?
This line graph shows that the topics learned increase as time passses by.
Let us plot the kinds of movies that selected teenagers prefer given the following data:
Movie Genre Number of Teenagers
Comedy 8
Action 10
Romance 12
Drama 2
Sci-fi 8
We can see from the chart that more teenagers (12) like romance the movies
least ofwhile
the
movies liked by
teenagers is
drama movies. Comedy
and Sci-fi are equally liked
by 8 teenagers totalling 16 teenagers in all. Ten teenagers like action movies.
3. Pie chart/graph – circular chart used to compare parts of the whole. It is divided
into sections representing certain quantities. The salary of a person can be
represented by a whole circle. It can be divided into portions representing items
for which the salary was spent like food, rent, clothing, transportation, etc. The
following pie chart shows the percentage ownership of pets. 4
55%
30%
The pie chart shows 55% of the people surveyed own dogs, 30% own cats, 6%
own fish, 5% own rabbits, and 4% own rodents. Therefore, we can conclude that majority
of the people surveyed own dogs.
Part of the Table
Tables are easily constructed using the Word processor’s table function or a
spreadsheet program like Excel. You can use Excel to compute for the net pay given
gross earnings and payroll deductions. You can also use Excel to compute for gross
earnings given salary, commission, and override. Even without computation, Excel is
excellent for making tables due to its format.
Tables have distinct parts. Emathzone.com has shared the following relative parts
of a table and pointers in making tables.
A statistical table has at least four major parts and some other minor parts. 5
1) The Title
2) The Box Head (column captions)
3) The Stub (row captions)
4) The Body
5) Prefatory Notes
6) Footnotes
7) Source Notes
1) The Title
A title is the main heading written in capital shown at the top of the
table. It must explain the contents of the table and throw light on the
table as whole. Different parts of the heading can be separated by
commas.
• A table should be simple and attractive. There should be no need for further
explanation.
• There should be proper and clear headings for columns and rows.
• Suitable approximation may be adopted and figures may be rounded.
• The unit of measurement should be well defined.
• If the observations are large in number, they can be broken into two or more or
three tables.
• Thick lines should be used to separate the data under big classes and thin line to
separate the subclasses of data.
Parts of a Chart or Graph
Beacon Learning Center discussed the different parts of chart/graph in its website. 6
A line graph uses points connected by a line to show data. Five parts of the line
graph must be present for the graph to be complete:
Pet Ownership
5%4%
6%
30% 55%
A histogram is a special kind of bar graph that uses data shown as numbers in
order. Four parts of the histogram must be present for the graph to be complete.
1. Check the data. If your data is weak, your graph is weak, so make sure it makes
sense.
2. Explain encodings. Provide a legend, directly labelling shapes or describing
your graphic in a lead-in paragraph.
3. Label axes. Label your axes so that the readers know what scale points are
plotted on.
4. Include units. Indicate the unit of the numbers or values in the graph. It could
be hours, ages, units, or even currency.
5. Keep your geometry in check. Size circles and other two-dimensional shapes
by area, unless it is a bar graph or something like that.
6. Include your sources. Always include where the data is from.
7. Consider your audience. Take into account who and what your graphs and
charts are for, and design accordingly.
QUIZ 5
Elaine earns ₱24 500.00 a month. She spend 55% for rent, 18% for food, 12% for
clothing, 10% for utilities, 7% for savings, and 3% for transportation.
LESSON 5 ASSESSMENT
1. A survey of 25 people living in an urban area and 25 people living in a rural area
revealed the following relative to marital status:
Single Married Live-in Separated Divorced Widowed
Urban area 5 7 8 3 1 1
Rural area 8 10 2 1 0 4
a. Prepare a bar graph to depict the date in the table. Colour-code your bars.
Label the parts of the graph.
b. What do the numbers in the vertical axis represent?
c. What do the numbers in the horizontal axis represent?
d. Which item is used on weekends with twice as many hours on weekdays?
e. Aside from the refrigerator, which item is used most on weekdays?
Weekends?
f. What conclusions will you draw from your graph?
6. You were given the following data on the hours Edith spent on activities in a day:
Activity Number of Hours Spent
Work 8
Sleep 7
Meals 2
Learning Competencies
• Analyse and interprets the data presented in the table using measures of central
tendency
• Contrast mean, median, and mode
• Solve problems involving mean, median and mode
Lesson Objectives
At the end of this lesson, you are able to:
1. Mean (x̅)
2. Median (Md)
3. Mode (Mo)
The Mean (x̅)
We will use the same data from our frequency table on the age of retirement.
To find the mean, add up all the numbers, then divide by how many numbers there
are. This also known as the arithmetic average. Looking at the retirement age distribution,
the mean is calculated by adding together all the values and dividing by the number of
observations.
∑x
x̅ = n
= 54 + 54 + 54 + 55 + 56 + 57 + 57 + 58 + 58 + 60 + 60
11
= 623
11
= 56.6 years
The mean is at the center of the distribution. In physics, we can say it is at the
fulcrum, the center of gravity, or the equilibrium point.
Score Frequency
70 – 74 13
75 – 79 13
80 – 84 19
85 – 89 8
90 – 94 7
Total 60
= (75 + 79) / 2 = 77
= (80 + 84) / 2 = 82
= (85 + 89) / 2 = 87
= (90 + 94) / 2 = 92
Then we multiply the x and that we got for each class by its frequency to get the fx
shown in the table. Adding all the fxs, we get 4 819. The mean would be:
∑x 4 835
x̅ = = = 80.58
n 60
Note that the mean is within the class (80 – 84) with the highest frequency (19).
The median is the middle value or midpoint in a distribution when the values are
arranged in ascending or descending order. The median divides the distribution in half
(there are 50% of observations on neither side of the median value). These halves meet
ST. IGNATIUS TECHNICAL COLLEGE, INC. NOT FOR SALE 54
at the median position. If the number of observations is odd, the median fits perfectly and
the depth of the median position will be a whole number. If the number of observations is
even, the depth of the median position will include a decimal. Looking at the retirement
age distribution (which has 11 observations), the median is the middle value, which is 57
years.
54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60
When the distribution has an even number of observations like the following:
52, 54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60
The median value is the mean of the two middle values. In the foregoing distribution, the
two middle values are 56 and 57, therefore, the median = [(56 + 57) / 2] = 56.5 years.
The median is in the class where the cumulative frequency reaches half the sum
of the absolute frequencies. The following is adopted from:
n/2−cfi
Md = Lm + [ ]
fm
Lm = 79.5 (between the 79 upper limit of the class above the median class and
the 80 lower limit of the median class)
60
n/2 = = 30
2
cf = 26
fm = 19
i=5
30−26
Md = 79.5 + = 79.5 + (4 / 19)5 = 79.5 + 1 = 80.5
19
Take note that our mean for the same grouped data of 80.32 is very near the
median. The median falls within the median class, which has the highest frequency, 80 –
84.
To find the mode or modal value, place the numbers in value order (either
ascending or descending), then count how many are there for each number. The mode
is the number which appears most often (the one with the highest frequency). In our
retirement age frequency distribution, the most commonly occurring value or highest
frequency (3) is 54; therefore, the mode of this distribution is 54 years. If all values occur
only once, there would be no mode; however, there can be more than one mode. If you
have a series of number and, say, all of 8, 5, and 3 appear 3 times, then 8, 8, and 3 are
the modes.
When data are grouped, the mode is defined as the midpoint of the interval
containing the largest number of cases. In our set of data of scores on an accounting
quiz:
Score Frequency
70 – 74 13
75 – 79 13
80 – 84 19
85 – 89 8
90 – 94 7
Total 60
Example: Abigail Monte Vista manages a coffee house called Our Snack Bar. The owner wants
to know the average length of employment at the coffee house. Abigail gathered the data
relative to those who left the coffee house for the past 5 years. There were only eight
employees who left the coffee house for the said period. Below are the lengths of time
the said employees stayed with the coffee house:
Let us compute the mean, median, and the mode. The mean would be the sum of
the lengths of time divided by 8, which would be:
Mean = 60 + 45 + 32 + 8 + 13 + 32 + 20 + 32
8
= 242
8
= 30.25 months
The median would be the middle of the values; therefore, if we arrange the
figures:
8 13 20 32 32 32 45 60
Since there are 8 figures, to get the median, we get the mean of the two middle
values, which are 32 and 32 which will give us 32 [(32 + 32) / 2]. The mode is the one
with the highest frequency, which in this case is also 32.
Jorge owned a service station. For the past 6 days, his record showed the
number of tune ups he did:
Day Number of Tune Ups
Monday 6
Tuesday 5
Wednesday 6
Thursday 8
Friday 9
Saturday 11
1. Find the range, the mean, the median, and the mode.
2. Double the value of each number in the set. Find the range, the mean, the
median, and the mode.
3. How does doubling the number affect the range, the mean, the median, and
the mode?
Lesson Summary
• A measure of central tendency (also referred to as measure of center or central
location) is a summary measure that attempts to describe a whole set of data with
a single value that represents the middle or center of its distribution.
• There are three main measures of central tendency: the mean, the median, and
the mode. Each of these measures descries a different indication of the typical or
central value in the distribution.
• The mean also known as the arithmetic average, is the result of adding up all the
numbers, then dividing the result by how many numbers there are.
∑x
❖ The mean for an ungrouped data is x̅ = n
∑x
❖ The mean for a grouped data is x = n
• The median is the middle value or midpoint in a distribution when the values are
arranged in ascending or descending order. For a grouped data, the median is in
the class where the cumulative frequency reaches half the sum of the absolute
frequencies. The following is used:
n/2−cfi
Md = Lm + [ ]
fm
• The mode is the number which appears most often (the one with the highest
frequency). When data are grouped, the mode is defined as the midpoint of the
interval containing the largest number of cases.
LESSON 6 ASSESSMENTS
1. Find the range assuming that you were given the following speed of some
animals in miles per hour (mph).
30 75 20 85 65 95
Find:
a. Mean
b. Median
c. Mode
3. Scientists measured the speed at which six monkeys ran tree course at miles
per hour.
Monkey 1 2 3 4 5 6
Speed 20 50 35 25 45 40
Find:
a. Mean
b. Median
c. Mode
Find:
a. Mean
a. Frequency polygon
b. Frequency distribution table
Find the:
a. Mean
b. Median
c. Mode
6. You were given the following hypothetical data relative to the gross monthly
income of certain occupation in the Philippines.
Occupation Average Gross Monthly Income
Airline Pilot ₱98 575.00
Engineer ₱57 899.00
Professor ₱49 524.00
Accountant ₱47 997.00
Teacher ₱44 991.00
Flight Attendant ₱32 530.00
Messenger ₱18 448.00
Bus Driver ₱18 802.00
Hotel Receptionist ₱18 754.00
Car Mechanic ₱18 711.00
Professional Nurse ₱23 669.00
Chambermaid ₱17 843.00
Find the:
a. Mean
b. Median
Find:
a. Mean
b. Median
c. Mode
Find:
a. Mean
b. Median
c. Mode
9. The ages of the 107 people who live in a nice place by the sea are grouped
according to age as follows:
Age Number of People
0-9 15
10 – 19 20
20 – 29 25
30 – 39 16
40 – 49 10
ST. IGNATIUS TECHNICAL COLLEGE, INC. NOT FOR SALE 61
50 – 59 10
60 – 69 7
70 – 79 3
80 – 89 1
Find:
a. Mean
b. Median
c. Mode
VARIABILITY
Learning Competencies
Variability
Variability refers to how spread out a group of scores is. In other words, variability
measures how much your scores differ from each other. The terms variability, spread,
and dispersion are synonyms. Data sets with similar values are said to have little
variability, while data sets that have values that are spread put have high variability.
There are four frequently used measures of variability: range, interquartile range,
variance, and standard deviation.
Range
The range is the simplest measure of variability. To calculate the range, you take
the smallest number and subtract it from the highest number. This allows us to know the
spread of our data. Although it is simple to calculate, the range is sensitive to outliers or
values that are significantly higher or lower than the rest of the data set, and should not
be used when present. Authors differ a little on the computation of range. Walpole defined
range as “the difference between the largest and the smallest number in the set” while
Downie and Heath defined it as “highest minus lowest plus one.” However, Walpole’s
definition is adopted by many. In formula form, that would be
Range = H – L
We can see that Warpole and the other websites did not add one in computing for
the range, which we will follow.
Since range should not be used when outliers are present, the alternative measure
to use would be the interquartile range (IQR). Interquartile range (IQR) is a measure of
variability based on dividing a data set into quartiles. Quartiles divide a rank-ordered data
set into four equal parts. The values that divide each part are called the first, second, and
third quartiles and they are denoted by Q1, Q2, and Q3, respectively.
• Q1 is the middle value in the first half of the rank-ordered data set.
• Q2 is the median value in the set.
• Q3 is the middle value in the second half of the rank-ordered data set.
The formula to find the interquartile range is
Let us assume the following data on the midterm exam of a certain class:
52, 71, 55, 75, 81, 85, 100, 89, 83, 90, 90, 99, 100
For a set of number with an odd number of data points, find the IQR, we follow the
following steps.
3. Place brackets around the numbers above and below the median. Do not place
brackets around the median.
First half Median Second half
(52, 55, 71, 75, 81, 83) 85 (89, 90, 90, 99, 100, 100)
For a set of data with even number of data points, the middle value is the
average of the two middle values for the representative quartiles. For example,
consider the following numbers:
1 3 4 5 5 6 7 11
Q1 is the middle value in the first half of the data set. Since the number of
figures is even, the first half would be:
1 3 4 5
To get Q1, the two middle figures 3 and 4 and the average of 3 and 4 would
be:
Q1 = (3 + 4) / 2 = 3.5
The two middle figure are 6 and 7 and the average of 6 and 7 would be Q3:
Q3 = (6 + 7) / 2 = 6.5
Now that we have Q1 and Q3, we can now solve for the IQR:
Alternatively, the IQR can be defined as the difference between the largest
and smallest values in the middle 50%of a set data. This will require that we
remove observations in the lower and upper quartile. In our example of
1 3 4 5 5 6 7 11
We remove 1 and 3 from the first half and 7 and 11 from the second half.
We are left with
4 5 5 6
IQR = 6 – 4 = 2
Variance
The variance is a measure of how close the scores in the data set are to the middle
of the distribution. It is mainly used to calculate the standard deviation and other statistics.
The variance is defined as the average of the squared differences from the mean.
The variance of a population mean is denoted by ơ2; and the variance of a sample
mean, by s2.
The variance of a population mean is the average squared deviation from the
population mean, as defined by the following formula:
where:
Example: A population consists of four observations: (1, 3, 5, 7). What is the variance?
Solution:
µ=4
2. Then, we plug all known values in the formula for the variance of a population:
ơ2 = ∑ (𝑋i − µ)2 / n
[(1−4)2 +(3−4)2+(5−4)2 +(7−4)2 ]
ơ2 = 4
[(−3)2 +(−1)2 +(1)2+(3)2
ơ2 = 4
[9+1+1+9]
ơ2 = 4
20
ơ2 = 4
ơ2 = 5
∑(𝑋i − µ)2
s2 = (n−1)
where:
If you are working with a simple random sample, the sample variance can be
considered an unbiased estimate of the true population variance. Therefore, if you want
to estimate the unknown population variance, based on known data from a simple random
sample, sue this formula.
Solution: This problem can be handled exactly like the previous problem,
except that we use the formula for calculating sample variance.
∑(𝑋i − µ)2
s2 = (n−1)
4. Divide the sum of squares by the total number of data in the set.
108 520
f = 21 704
5
Standard Deviation
The standard deviation is a measure of how spread out numbers are. Its symbol
is ơ (the Greek letter sigma). Square root of the variance. Therefore, in our foregoing
2
For example on the variance of population mean, which was 5, the standard
deviation would be the √5 = 2.236068 and for the example on the variance of sample
mean, which was 6.667, the standard deviation would be √6.667 = 2.5820534.
The Internet has square root calculators. Scientific calculators can also be used to
compute for standard deviation.
Find the range, interquartile range, variance, and standard deviation for the
average prices of certain commodities shown.
Average Price
Lesson Summary
• Variability means how much your scores differ from each other. The terms
variability, spread, and dispersion are synonymous.
• There are four frequently used measures of variability: the range, interquartile
range, variance, and standard deviation.
• The range is the simplest measure of variability. It is the difference between the
smallest number and the largest number.
• The interquartile range (IQR) is used when sets of data contain outliers. The IQR,
or the middle fifty, is the range for the middle fifty percent of the data. The IQR only
considers middle values, so it is not affected by outliers.
• The variance is a measure of how close the scores in the data set are to the middle
of the distribution or the mean. It is mainly used to calculate the standard deviation
and other statistics. It is also defined as the average of the squared differences
from the mean.
• The standard deviation is a measure of how far numbers in a data set are from
each other. Its symbol is ơ2 (Greek letter sigma). Square the root of the variance.
a. What are the mean and median IQs for the class?
b. Find the:
(1) range
(3) variance
∑x = 40
Find the:
a. Range
b. Interquartile range
c. Variance
d. Standard deviation
5. Abram and his friends love cats. They decided to measure how tall their cats are
and they obtained the following results:
300 mm 235 mm 85 mm 215 mm 150 mm
Find the:
a. Range
b. Interquartile range
c. Variance
d. Standard deviation
Learning Competencies
Before we study the process of test of difference, let us study the terms used:
• The null hypothesis is non-directional and is tested by a two-tailed test. The null
hypothesis is formulated with the hope that it be rejected and is denoted by H 0. A
ST. IGNATIUS TECHNICAL COLLEGE, INC. NOT FOR SALE 74
null hypothesis concerning a population parameter will always be stated so as to
specify an exact value of the parameter; whereas, the alternative hypothesis (H1)
allows for the possibility of several values. So, if Ho is the null hypothesis, p = 0.5
for binomial population, the alternative hypothesis H1 might be p < 0.5, p > 0.5, p
≠ 0.5. The rejection of the null hypothesis leads to the acceptance of the alternative
hypothesis.
Alternative hypothesis – denoted as H1 can be expressed:
(1) “Method A is better than Method B in teaching math.”
(2) “Method A is poorer than Method B in teaching math.”
(3) “Method A is either better or poorer than Method B in teaching math.”
The alternative hypothesis are directional hypotheses and are tested by a
directional or one-tailed test.
In deciding whether to reject a hypothesis, there are two types of error that
may be committed. They are:
(𝐱̅− µ)√𝒏
t-test = with degrees of freedom (fd) = n – 1
𝐬
where,
x̅1 – sample mean
µ - population mean
n – sample size
s – sample standard deviation
ơ – population standard deviation
Examples:
1. A buyer of Makulay paint complains that he or she is getting less paint than 4
gallons per container from his or her supplier. A sample of 16 containers
reveals a mean of 3.8 grams with a standard deviation 0f 0.46 grams. Is the
buyer’s complaint valid? Use 0.01 level of significance.
Solution:
a. H0: The container contains 4 gallons (µ = 4 gal).
H1: The container contains less than 4 gallons (µ < 4 gal).
b. n = 16 (t-test, one tailed)
(3.8−4)√16
c. t-test value = = -1.74
.46
d. Decision: Since the computed value is set inside the acceptance region,
one must accept the null hypothesis.
e. Conclusion: The complaint of the buyer is not valid.
2. Test the hypothesis that the average content of packs of Great instant noodles
is 75 grams if a sample of 85 packs has the mean weight of 74.2 grams with
the standard deviation of 2.6 grams. Use a .01 level of significance.
Solution:
a. H0: The average content of packs is 75 grams (µ =75 grams).
H1: The average content of packs is less than 75 grams (µ < 75 grams).
b. n = 85, (z-test, one tailed)
ɑ = .01
Critical value: ± 2.33
c. z-test value
(74.2−75) √88
= = -2.84
2.6
d. Decision: Since the computed value is set outside the acceptance region,
one must reject the null hypothesis.
e. Conclusion: The average content of packs of Great instant noodles is less
than 75 grams.
Examples:
1. The production
manager of
Mark’s
Manufacturing
would like to
decide on
which of the
two plants should
be given the
responsibility
of producing the soda bottle cups. This decision will be based on productivity
levels. A sample of 50 days at the Silver Star Plant produced the mean of 104.6
thousand cups a day with s = 13.4 thousand. The Skyfall Plant produced an
average of 98.7 thousand per day with s = 15.2 thousand over 60 days. Do
these plants differ significantly in production level? Use 0.05 level of
significance.
Solution:
t-test
d√n
t= Sd
where:
Example: The Lopez Accounting Firm wishes to compare the use of two different
spreadsheets by having 8 employees work with each spreadsheet while listing the mean
number of error they committed. The following are the results. Conduct the test using 0.01
level of significance.
Where:
𝑑̅ = .125
Sd = 1.64208
n=8
Solution:
a. Ho: There is no significant difference in the errors of the two
spreadsheets. (µ1 = µ2)
Always remember that when we reject the null hypothesis, we accept the
alternative hypothesis and vice-versa.
3. The average length of time for students to register for fall classes at a certain
college has been 50 minutes with a standard deviation of 10 minutes. A new
registration procedure using modern computing machines is being tried. If a
random sample of 12 students had an average registration time of 42 minutes with
a standard deviation of 11.9 minutes under the new system, test the hypothesis
that the population mean is now less than 50 using a level of significance of (a)
0.05 and (b) 0.01. Assume the population of times to be normal.
Solution:
a. H0: µ = 50 minutes
b. H1: µ > 50 minutes
c. (a) ɑ = 0.05 (b) ɑ = 0.01
𝑥̅ −µ √12
d. Critical region: (a) t > -1.796; (b) t = -2.718; where t = s
with ʋ = 11 degrees of freedom
e. Computations: x = 42 minutes, s = 11.9 minutes, and n = 12; hence,
42−50 √12
t= = -2.33
11.9
11.9
f. Conclusion: Reject H0 at the 0.05 level of significance, but not at the 0.01 level;
this means that the true mean is likely to be less than 50 minutes, but does
not differ sufficiently to warrant the high cost that would be require to operate a
computer.
and n1 = 12n1 = 10
(11)(16)+(9)(25)
sp = √ = 4.478
12+10−2
1 1
[(85)−(81)−0]√ +
12 10
t= 4.478
f. Conclusion: Reject H0; the two methods of learning are not equal.
QUIZ 8
Find the number of grams of the chemical needed to make the following solution:
1. A 5000 ml 3%
2. B 4000 ml 4%
4. D 7000 ml 2.5%
5. E 8000 ml 3.5%
LESSON 8 ASSESSMENTS
The steps in getting z-test between means with the use of computer are as follows:
Step 3. Hold the mouse. Click Start menu, click Program, and click Microsoft Excel
Step 4. Wait until after the computer displays Microsoft Excel Program
Cell A Cell B
1Type 8 Type 6
2 Type 10 Type 6
3 Type 10 Type 8
4 Type 10 Type 8
5 Type 8 Type 6
6 Type 8 Type 8
8 Type 10 Type 6
9 Type 10 Type 10
10 Type 8 Type 8
11 Type 8 Type 6
12 Type 10 Type 6
13 Type 10 Type 6
14 Type 8 Type 8
15 Type 8 Type 6
16 Type 8 Type 6
17 Type 10 Type 6
18 Type 8 Type 10
19 Type 8 Type 8
20 Type 10 Type 6
21 Type 8 Type 6
22 Type 8 Type 6
23 Type 10 Type 6
24 Type 8 Type 8
25 Type 8 Type 6
Step 6 Highlight the data. Click Tools menu. Click Data analysis. Note: If you
cannot get Data Analysis program, ask the Internet attendant to do it for you.
Step 7 The computer displays Analysis Tools. Click z-test: Two Sample for Means.
Click OK.
Step 8 The computer displays z-test: Two Sample for Means. In the Inoput Range
type the following:
Variable 1 Variance = 1 (given), if not, get the variance of the variables in Range 1
(A) using the variance formula.
Variable 2 Variance = 1.6933 (given); if not get the variance of the variables in
Range 2 using the variance formula.
Step 10. The computer displays the result. Copy and paste the result in separate
sheet, print it and submit to your subject teacher.
The steps in getting t-test: paired two-sample for means with computer are as
follows:
Cell A Cell B
1 90 80
2 85 81
3 78 75
4 95 85
5 88 85
6 80 77
7 93 85
8 78 76
10 79 76
11 87 84
12 89 80
13 88 84
14 78 75
15 94 84
16 77 75
17 90 81
18 82 79
19 81 78
20 91 81
21 83 79
22 90 80
23 88 83
24 87 83
25 79 77
Step 6. Highlight the data. Click Tools menu. Click Data Analysis.
Step 7. The computer displays Analysis Tools. Click t-Test: Paired Two-Samples for
Means. Click OK.
Step 8. The computer displays t-Test: Paired Two-Sample for Means, In Input
Variable 1: Range, type $A1: $A25. In Input Variable 2: Range, type $B1: $B25.
Type for Alpha 0.01. Click OK.
Step 9. The computer displays the result. Copy and paste the result to another
sheet, and submit to your subject teacher.
If you want to determine the variance among three or more variable ranges, you
have to use F-test or ANOVA Single Factor (Analysis of Variance Single
Factor). This time, we will use the computer to perform such computation for
reference.
The steps in computing F-test or ANOVA single factor with the computer are as
follows:
1 5 8 10
2 4 7 9
3 3 6 8
4 2 5 7
5 1 4 6
Step 6. Highlight the data. Click Tools menu. Click Data Analysis.
Step 7. The computer displays Analysis Tools. Click ANOVA: Single Factor. Click
OK.
Step 10.The computer displays the result. Copy and paste to another sheet, print it
and submit to your subject teacher.
Books
Calmorin, LP (2010). Research and Statistics (1st Ed.), Mandaluyong city, Philippines,
Cacho Hermanos, Inc.
Levy,M. & Weltz, B (2012). Retailing Management (8th Ed). 1221 Avenue of the
Americas, New York, NY, The McGraw-Hill Companies, Inc.
Madura, Jeff (2001) Introduction to Business (2nd Ed). 5101 Madison Road, Cincinnati,
Ohio, South Western College Publishing
Mariano, NDL (2016). Business Mathematics (1st Ed), Quezon City, Philippines, Rex
Publishing Company, Inc.