Business Analytics Quiz 1: 7 July 2024 (May 2024 term)

Dr. Milo is exploring the attendance of employees (number of sick days taken) in an organisation. He needs to make a presentation to the company’s top management. Table-1 specifies the total number of sick days taken by the employees of three different teams “Team-A”, “Team-B” and “Team-C” over the past 12 months. Then answer the given sub questions
Note to students: For this comprehension, please do not worry about the colour combinations/ reproductions. In TCS ion, the colour representations may not appear accurately. Kindly use the “data labels” and “visualisation theory” to arrive at the appropriate answers.

If the aim is to indicate the team which has the highest number of sick days in the whole year, then which of the following visualizations would be best suited?

Dr. Milo is exploring the attendance of employees (number of sick days taken) in an organisation. He needs to make a presentation to the company’s top management. Table-1 specifies the total number of sick days taken by the employees of three different teams “Team-A”, “Team-B” and “Team-C” over the past 12 months. Then answer the given sub questions
Note to students: For this comprehension, please do not worry about the colour combinations/ reproductions. In TCS ion, the colour representations may not appear accurately. Kindly use the “data labels” and “visualisation theory” to arrive at the appropriate answers.

If the aim is to display team wise pattern in total sick days over the months in the year, then which of the following graphs will be best suited?

“Aqua Aqua (AA)” is a manufacturer of water purifiers. AA wants to understand the life of its RO filters. The life of a filter is measured in terms of “Litres of Water Purified (LWP)” before a warning light is raised for maintenance. A sample of 20 water purifiers were tested and the time (LWP) after which the warning light is raised for maintenance of the RO Filter was noted (data provided in Table-2). With this data, AA wants to understand the possible distribution for the life of the RO filter. To this end, it is proposed to bin the data in 4 groups “Low Life (LWP <=25)”, “Medium Life (25<LWP<=40)”, “High Life (40<LWP<=80)”, “Excellent Life (LWP>80)”.
The following Ф values are given to you, where Ф(z) indicates the area under the curve (between “0” to “LWP”) for a normal distribution with a mean of 60 and standard deviation of 24. Ф(-1.45) = 0.07; Ф(-0.83) = 0.20; Ф(+0.83) = 0.79; Ф(+1.45) = 0.93

Given this information, answer the subquestions

If the life of the RO Filter is expected to follow a uniform distribution, then what is the expected frequency in any given bin? (Note: If your answer is in decimal, enter it rounded to two decimal places. For example, if your answer is “10.256”, enter it as “10.26”)