Salaries and Wages
These are employees who are under the "no work, no pay" policy
wage earner
It is the amount earned by any person from the gross earnings less the total deductions.
net earning
It is an additional 10% premium given to an employee who works between 10:00PM and 6:00 AM
night shift differential
Mean
Formula in excel starts with
=
P17,000
Ms. Nicdao has a total monthly deduction of P3,280. If her take-home pay is P21,250, how much is ger gross earnings for working this month?
P17,970
How much is the allowable limit for the total 13th month, bonuses, and excess of de minimis benefits?
P90,000
Quartile
Which of the following graphs uses line segments to connect data points
Line Graph
It is the total amount that people earn in exchange of the goods, employment, businesses, investments and professional services that they have rendered.
Income
Jenny receives a monthly salary of P35,000. He pays his monthly contributions: P2,560.42 for income tax, P800 for SSS, P525 for PhilHealth and P100 for Pag-Ibig. How much will be his take home pay?
P31,014.58
Marites receives a monthly basic pay of P15,000. How much will be her Pag-Ibig contribution per month?
P100
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, median, and mode.
Mean = 10
Median = 10
Mode = 11
It is a spreadsheet and graphing and database management tool frequently used for business.
Microsoft Excel
Maurice applies for secretarial position in MY Company. They offer an annual salary of P288,000, which will be given weekly. How much will she receive every pay day if she will accept the offer?
P5538.46
If your mother's regular hourly rate is P50, how much would be her hourly overtime rate?
P62.50
Nelson receives P15,000 for his monthly basic salary. How much will he pay for his monthly SSS Contribution.
P600
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 IQR.
3.5
Charmaine enters in cell D1 and E1 her hourly rate and total hours worked on regular day. If she will compute for her regular pay in cell A3, what will she press?
Antonio works as a part-time crew in a fast food chain in the city with the following schedule for one week: Monday 5 hours; Tuesday 6 hours; Wednesday 4 hours; Thursday 6 hours; Friday 3 hours. If he was paid P104.25 an hour, how much will he get for the week?
P2502
Suppose your sister works for 11 hours (excluding her lunch break) on her rest day which falls on a special day, how much is her additional income on that day if she is paid P100/hr?
P1785
A regular employee employee in a private company receives a monthly basic salary of P18,000.
none
What is the standard deviation of this data:
1.41
Open an Excel Worksheet. Encode your data in one column with the appropriate variable name.