Chapter -2 : Practice Questions & Materials

Variability

Attempt the following questions using the provided data -

1. Let’s say in a simple model, financial equality of a society can be defined how close the salaries of citizen are. To understand this with example, we have 2 countries where salaries of some sample population is written in “Citizen Salary” sheet. Using standard deviation, identify which country has better financial equality.

2. In “flight arrival data” sheet, flights scheduled, and actual arrival is mentioned. Usually, every flight is late by few minutes. Flyer usually has 2 preferences

Flight should not be delayed much

Delay time should be predictable

Your task is-

Identify the airline with least average delay time.

Find the airline which is more consistent and predictable with delay time.

3. Rohit is diagnosed with a rare disease where his lungs are going to be sensitive to frequent changes in the air quality. Hence, doctor has recommended him to shift to a city where air quality is stable. Using Air Quality Index sheet, identify the best and worst city for Rohit to shift?

4. Rakesh Malhotra (age 62) has just retired from his job and received 1.9 Cr on the retirement day. Since is not a active investor in the market and has less expertise in financial investing, he took help of his friend to learn how he should go for investing his 1.9 cr. His friend as suggested him that at this stage where is very old, he should look for safe investment which means the stocks which are not volatile in the market. Rank stock A, B, C, D in terms of safe investment.

5. DPS RK Puram as conducted pre board exam to evaluate the performance of the students of 10th There are 4 sections in class 10 and scores for all the students are listed in the “Pre-Board Score” sheet. Principal of the school has hunch that the students are cheating in the exam. Principle suggests that if the students’ scores are closed to the average, then their might be a chance that students are cheating in the exam. Use your statistics to identify which one of batch has higher chance of cheating.

6. Rohan Batra is an environmentalist and believe on generation of clean energy. 5 years ago, he installed 3 solar panel in his house and happy with the performance. Recently, he started getting irregular output from panels. He is skeptic that one or some of the panels are getting deteriorated hence he might need to replace them with new one. As the panels are very expensive to replace, he decided to replace just one panel for now. In “Solar Panel Output” sheet, daily level output of all the panels is mentioned. Help Rohan to identify irregular panel for the replacement.

Dataset -

⁠

Variability.xlsx

75.6 kB

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.