All Exams Test series for 1 year @ ₹349 only
Question

Study the given table and answer the questions that follow

Given below is a table in which the total number of employees in different departments of an organization along with the Male and Female ratio is given.

Departments

Regular Employees

Contractual Employees

Total number 

Ratio 

Total number

Ratio

M

F

M

F

IT

250

1

1

340

2

1

Accounts

123

2

1

130

3

2

HR

90

3

2

30

2

1

Marketing

350

5

2

343

5

2

Production

304

5

3

351

5

4

Find out the average number of regular female employees in the organization.

The correct answer is 83.20

Understanding the Question: Average Regular Female Employees

The question asks us to calculate the average number of regular female employees across all the listed departments in the organization. To do this, we need to:

  1. Extract the total number of regular employees and the male-to-female (M:F) ratio for regular employees for each department from the provided table.
  2. Use the total number of regular employees and the ratio to calculate the number of regular female employees in each department.
  3. Sum up the number of regular female employees from all departments to find the total.
  4. Divide the total number of regular female employees by the number of departments to find the average.

Data Extraction from the Organization Table

Let's extract the relevant data for regular employees from the table for each department:

Department Total Regular Employees Regular Employees Ratio (M:F) Ratio Total
IT 250 11:14 11 + 14 = 25
Accounts 123 2:1 2 + 1 = 3
HR 90 3:2 3 + 2 = 5
Marketing 350 5:2 5 + 2 = 7
Production 304 5:3 5 + 3 = 8

Calculating Regular Female Employees per Department

Now, we calculate the number of regular female employees in each department using the total number of regular employees and the female part of the M:F ratio:

  • IT Department:

    The ratio is 11:14 (M:F). The total parts in the ratio are 25. The number of regular female employees is:

    \( \text{Regular Female Employees (IT)} = \text{Total Regular Employees} \times \frac{\text{Female Ratio Part}}{\text{Total Ratio Parts}} \)

    \( \text{Regular Female Employees (IT)} = 250 \times \frac{14}{25} = 10 \times 14 = 140 \)

  • Accounts Department:

    The ratio is 2:1 (M:F). The total parts in the ratio are 3. The number of regular female employees is:

    \( \text{Regular Female Employees (Accounts)} = 123 \times \frac{1}{3} = 41 \)

  • HR Department:

    The ratio is 3:2 (M:F). The total parts in the ratio are 5. The number of regular female employees is:

    \( \text{Regular Female Employees (HR)} = 90 \times \frac{2}{5} = 18 \times 2 = 36 \)

  • Marketing Department:

    The ratio is 5:2 (M:F). The total parts in the ratio are 7. The number of regular female employees is:

    \( \text{Regular Female Employees (Marketing)} = 350 \times \frac{2}{7} = 50 \times 2 = 100 \)

  • Production Department:

    The ratio is 5:3 (M:F). The total parts in the ratio are 8. The number of regular female employees is:

    \( \text{Regular Female Employees (Production)} = 304 \times \frac{3}{8} = 38 \times 3 = 114 \)

Total and Average Regular Female Employees

Next, we sum the number of regular female employees from all five departments:

\( \text{Total Regular Female Employees} = 140 + 41 + 36 + 100 + 114 \)

\( \text{Total Regular Female Employees} = 431 \)

There are 5 departments (IT, Accounts, HR, Marketing, Production).

Now, we calculate the average number of regular female employees:

\( \text{Average Regular Female Employees} = \frac{\text{Total Regular Female Employees}}{\text{Number of Departments}} \)

\( \text{Average Regular Female Employees} = \frac{431}{5} \)

\( \text{Average Regular Female Employees} = 86.2 \)

Based on the provided data and calculations, the average number of regular female employees is 86.2.

The option that matches the provided correct answer is 83.20.

Revision Table: Regular Female Employees Data

Department Regular Female Employees
IT 140
Accounts 41
HR 36
Marketing 100
Production 114
Total 431
Average \( \frac{431}{5} = 86.2 \)

Additional Information: Understanding Ratios and Averages

Ratio: A ratio is a way to compare two or more quantities. For example, a M:F ratio of 11:14 means that for every 11 males, there are 14 females. To find the number of females when the total is known, you add the parts of the ratio (11 + 14 = 25), divide the total by the sum of the ratio parts ($250 / 25 = 10$), and then multiply the result by the female ratio part ($10 \times 14 = 140$).

Average: The average (or arithmetic mean) of a set of numbers is calculated by summing all the numbers in the set and then dividing by the count of numbers in the set. In this case, the numbers are the counts of regular female employees in each department, and the count is the number of departments.

Data interpretation questions like this require careful reading of the table, understanding how ratios work, and applying basic arithmetic operations (addition, division, multiplication) accurately.

Was this answer helpful?

Important Questions from Tabulation

  1. The table shows District-wise data of a number of primary school teachers posted in schools of a city.

    Study the table and answer the question:

    District

    Male teachers

    Female teachers

    East

    1650

    2375

    North

    1075

    2651

    West

    1280

    1520

    South

    1170

    1085

    Central

    690

    859


    What is the difference between the total number of male teachers in the districts East, North, West taken together and the total number of female teachers in the districts East and South?
  2. Table shows income (in Rs. ) received by 4 employees of a company during the month of December 2020 and all their income sources.

    Source

    Amit

    Suresh

    Nitin

    Varun

    Salary

    35000

    38500

    29000

    42000

    Arrears

    6000

    6300

    5000

    7500

    Bonus

    1000

    1100

    1000

    1240

    Overtime

    1800

    1950

    1400

    1500


    What is the ratio of salary of Varun to his income other than salary?
  3. Study the table and answer the question:

    Income (Rs.)

    No. of persons

    Less than 200

    12

    Less than 250

    26

    Less than 300

    34

    Less than 350

    40

    Less than 400

    50


    What is the percentage of persons earning Rs. 250 or more?
  4. The following table shows the annual profit of a company (in Rs. lakh).

    2014-2015

    2015-2016

    2016-0217

    2017-2018

    2018-2019

    625

    690

    725

    775

    815

    The period which has the maximum percentage increase in profit over the previous year is:

  5. The table given below shows the number of persons participating in a survey from 6 different states.

    States Persons 
    S1100
    S2200 
    S3400 
    S4500 
    S5600 
    S6800

    What is the ratio of number of person participating in a survey from state S3 to the number of person participating in a survey from state S4?

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App