Notes, summaries, assignments, exams, and problems for Mathematics

Practice 4: Salaries, Overtime, SSO, PHL

Basic Salary

• = (Additional Table at $[$D$24] * Time Worked)

Total Overtime

• Fx = IF(logical test = E10 [Overtime] > 40)
• True-Value: E10 - 40
• False-value: 0

Triple Overtime

• Fx = IF Function
• Logic Test: Total Overtime [G10 > 8]
• True-Value: G10 - 8
• False-value: 0

Payment of Extra Time Triple

• Triple Overtime (H10) * Pay Per Hour (D24) * 3

Double Overtime

• = G10 (Total Overtime) - H10 (Triple Overtime)

Payment of Extra Time Double

• = J10 (Double Extra Time) * D24 (Pay per hour) * 2

Compulsory Social Security (SSO)

• = (F10 [Basic Salary] + I10 [Payment of Triple Overtime] + K10 [Payment of Double Overtime]) * 5%

Housing Policy Act (HPL)

• = (F10 [Basic Salary] + I10 [Payment of Triple Overtime] + K10 [Payment of Double Overtime]

Data Visualization: Types and Applications

Graphics are a visual representation of data, prioritizing simplicity, easy interpretation, and adherence to standards.

Classification of Graphics

• Structural graphics: Representing a single set of data.
• Relational graphics: Connecting two sets of data.
• Special graphics.

Types of Graphics

• Organizational Charts: Represent the structure of an organization.
• Classification Plans: Represent elements of a total set, subdivided into smaller subsets. These can be square or pyramidal.
• Schedules: Use current statistics, ordering data over time to identify peaks and trends.
• Histograms: Represent class intervals or monthly values, highlighting extreme values.
• Function Tables: Establish mutual relationships between two sets

The definition of a weighted average:

What is a Weighted Average?

A weighted average is the result of multiplying each number in a set by a value assigned to it (its weight), and then calculating the arithmetic mean of the resulting products. It's used when the components contributing to the average are not equally important.

For example, if a teacher states that an examination is worth 40% of the final mark, another is worth 35%, and a third is worth 25%, the weighted average would be calculated as follows:

mediaPond = (ex1 * 40 + ex2 * 35 + ex3 * 25) / 100

Basically, it's an average of a dataset that allows you to define the degree of importance for each data point's contribution to the average.

If the data are 2, 3, 5, 7, 9, 6, 8, the average... Continue reading "Understanding Weighted Averages: Definition and Applications" »