Chapter -2 : Practice Questions & Materials

Working with Formula

EMI Data:

The sheet has instalment payment of customers who took short term loan(12 months) from a bank. Details for every installment payment is available in Table 1. Using the data calculate following metrics at customer level 1. Total Number of Installment paid. 2. Total Money Paid. 3. Total number of missing installment.

Sales Data:

Sales numbers for every employee id across various months mentioned in “Sales Data” sheet. Calculate following metrics at employee-id level 1. Total Sale. 2. Max Sale in any Month. 3. Min Sale in any Month. 4. Range (Max - Min). 5. Average Sale. 6. Performance (Range/Average).

Defect Data:

In a chip manufacturing plant, there are 10 different machines producing chips every day. These machines are not perfect, hence there are always some defective chips produced. The number of defected chips produced at machine and date level mentioned in the data. Calculate following metrics at machine level for all machines mentioned in the data 1. Total Defects. 2. Average Defects per day. 3. Max Defects Any day. 4. Min Defects Any day.

Assignment Scores:

In 3rd semester of a university, there are 16 assignments a student needs to submit for successfully completing the semester. However, it is seen that some students are skipping the assignment for various reasons. In the table, the scores for every student across different assignment are mentioned. In case any assignment is missed, the reason for the missing the assignment is mentioned in the table as well. Using this data, calculate following metrics at student level. 1. Average Score. 2. Maximum Score. 3. Minimum Score. 4. Number of Assignment Attempted. 5. Number of assignment Missed.

100 Meter Sprint:

Bhopal city is organizing annual sports competition for all the students. The data has performance details of all the participants from 2010 to 2018. Calculate following metrics at year level 1. Average Completion Time. 2. Minimum Completion Time. 3. Max Completion Time. 4. Number of disqualified.

Vaccine Data:

The sheet has data of all the residents of Elita Apartments. The apartment management committee just released vaccination data for all. Using this data answer following questions. 1. Identify the individuals who have not taken any vaccine. 2. Identify the individuals who have taken only one vaccine (1). 3. Identify the individuals who have taken both vaccines (1 and 2) 4. Identify the individuals who have taken both vaccines along with booster shot (1 and 2).

Dataset -

⁠

2.Workbook - Working With Formula.xlsx

826 kB

⁠

Solutions sheet -

⁠

1.2 Workbook - Working With Formula (Solution) .xlsx

1.1 MB

⁠

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.