The IIT Madras BS Business Data Management (BDM) End Term paper sat on 30 Apr 2023, in the January 2023 term, set QPD1-S2: 19 questions for 40 marks in 180 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.
Which of the following best describes the churn rate?
The number of new customers acquired in a given period
The percentage of customers who stop using a product or service in a given period
The amount of money earned from a customer in a given period
The cost of acquiring a new customer
Correct answer
The percentage of customers who stop using a product or service in a given period
Which of the following goods is likely to have the lowest marginal utility?
A necessity good.
A luxury good.
A good that the consumer has never tried before.
A good that the consumer has consumed many times before.
Correct answer
A good that the consumer has consumed many times before.
When does marginal utility become negative?
When a consumer consumes the first unit of a good.
When the total utility of a good is zero.
When the total utility of a good is at its maximum.
When the consumer reaches the point of overconsumption.
Correct answer
When the consumer reaches the point of overconsumption.
If the price of a product increases by 20% and the quantity demanded decreases by 10%, what is the price elasticity of demand?
2
0.5
1
1.5
Correct answer
0.5
The current ratio is a measure of:
A company's ability to pay its long-term debt obligations.
A company's liquidity and short-term solvency.
A company's ability to generate profits.
A company's efficiency in managing its inventory.
Correct answer
A company's liquidity and short-term solvency.
A Company has current assets of $750,000 and current liabilities of $250,000. What is the current ratio of the company?
3
1
1.5
0.33
Correct answer
3
A/B testing is used for:
Measuring the churn rate of a product
Comparing two versions of a product to determine which one performs better
Increasing the price of a product to maximize revenue
Reducing the number of features of a product to make it simpler
Correct answer
Comparing two versions of a product to determine which one performs better
Consider the following graphical representation of the Average of Credit Scores of Approved and Declined Credit Applications. Which of the following statements stands TRUE?
Statement A: The average of Credit Scores of customers getting declined remains more or less constant throughout the months
Statement B: Average Credit Scores of customers getting approved have increased over time Statement C: Average Credit Scores of customers getting approved have decreased over time Statement D: Grand Total Average has no correlation with whether the decline rate reduces or increases
Statements A, B, and D are TRUE
Statements A, C, and D are TRUE
Only Statement C is TRUE, and A being TRUE is ambiguous.
Both Statements A and C are true
Correct answer
Both Statements A and C are true
Consider the following graph representing the volume sales through an E-Commerce run distribution center through 15 days. Which among the following explains Thursday's volume being more than the rest of the days?
Statement 1 : There was a Black Friday sale on Thursday
Statement 2 : It’s possible that Thursday’s data is the only day occouring thrice among in the 15 day data
Statement 3 : It is not possible to judge trends with this less information
Statement 4 : One of the thursdays could be a public holiday/ online sale festival day
Statement 1 is correct
Statements 1,2,4 are correct
Statements 2,4 are correct
Statement 3 is correct
Correct answer
Statements 2,4 are correct
There is a column containing multiple courses a student has registered for like “BDM, TDS, BA, Python, English II” How can you separate these courses/words into distinct cells like this:
Use the "Split" function in Excel/Google Sheets.
Use the "Find and Replace" feature in Excel/Google Sheets.
Use the "Wrap Text" feature in Excel/Google Sheets.
Use the "Text to Columns" feature in Excel/Google Sheets.
Correct answer
Use the "Text to Columns" feature in Excel/Google Sheets.
Consider the following screenshot. Which among the following will be the correct syntax to put in the formula box for cell I2? Consider a situation where the company takes 2.5% as a commission on all application amounts for processing the application.
Correct answer
Calculate the given subquestion for Gear Broaching Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day | 3 |
| No. of Working Days in the Week | 6 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 3 |
| Designed Speed of Broaching Process (per hour) | 60 |
| Total Product Output | 6243 |
| Scrap (S) | 501 |
Availability - _______% (upto one decimal point)
Correct answer: 83 (accepted within ±1)
Calculate the given subquestion for Gear Broaching Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day | 3 |
| No. of Working Days in the Week | 6 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 3 |
| Designed Speed of Broaching Process (per hour) | 60 |
| Total Product Output | 6243 |
| Scrap (S) | 501 |
Performance ________% (upto one decimal point)
Correct answer: 86.75 (accepted within ±0.75)
Calculate the given subquestion for Gear Broaching Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day | 3 |
| No. of Working Days in the Week | 6 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 3 |
| Designed Speed of Broaching Process (per hour) | 60 |
| Total Product Output | 6243 |
| Scrap (S) | 501 |
Quality ________% (upto one decimal point)
Correct answer: 92 (accepted within ±1)
Calculate the given subquestion for Gear Broaching Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day | 3 |
| No. of Working Days in the Week | 6 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 3 |
| Designed Speed of Broaching Process (per hour) | 60 |
| Total Product Output | 6243 |
| Scrap (S) | 501 |
OEE _______ (Enter a number between 0 and 1 up to 3 decimal places)
Correct answer: 0.66 (accepted within ±0.06)
Answer the given subquestions concerning the Hobbing process of gear manufacturing.
Total Output of Gear casts after Hobbing: 2600.
Cost of Hobbing: INR 33 per Gear cast, Raw Material Cost: INR 37 per Gear Cast
Scrap Percentage after broaching process_______________%
Correct answer: 4.04 (accepted within ±0.02)
Answer the given subquestions concerning the Hobbing process of gear manufacturing.
Total Output of Gear casts after Hobbing: 2600.
Cost of Hobbing: INR 33 per Gear cast, Raw Material Cost: INR 37 per Gear Cast
Loss due to scrap after broaching_______________
Correct answer: 7325 (accepted within ±175)
Consider the following dataset:
Here all the factors are “more the better” . You can combine all the criteria as :
Composite Score= Sum of all criteria on the same scale
Rank the above candidates and choose the correct ranking from the below options
Alpha > Tango > Gamma > Beta
Gamma > Tango > Beta> Alpha
Alpha < Gamma < Tango < Beta
Gamma < Tango < Beta< Alpha
Correct answer
Alpha > Tango > Gamma > Beta
Consider the following Volume Sales Data for 4 different SKUs. Analyze and interpret - which of the following datasets qualifies the Volume Pareto criteria?
| Product Name | Volume Sales |
|---|---|
| Sony PlayStation 5 | 30000 |
| Microsoft Xbox Series X | 25000 |
| Nintendo Switch OLED | 20000 |
| Sony PlayStation 4 | 17500 |
| Microsoft Xbox One | 15000 |
| Nintendo Switch Lite | 12500 |
| Sony PlayStation 3 | 10000 |
| Microsoft Xbox 360 | 8500 |
| Nintendo Wii | 6,500 |
| Nintendo Wii U | 5,000 |
| TOTAL | 150000 |
A
| Product Name | Volume Sales |
|---|---|
| Chanel No. 5 | 25000 |
| Dior J'adore | 22000 |
| Paco Rabanne 1 Million | 19000 |
| Armani Si | 16500 |
| Marc Jacobs Daisy | 14000 |
| Gucci Bloom | 12000 |
| Yves Saint Laurent Black Opium | 10000 |
| Dolce & Gabbana Light Blue | 8000 |
| Tom Ford Black Orchid | 6500 |
| Jo Malone Lime Basil & Mandarin | 5000 |
| TOTAL | 138000 |
B
| Product Name | Volume Sales |
|---|---|
| Nike Air Max | 10000 |
| Adidas Ultraboost | 9500 |
| Converse Chuck Taylor | 8500 |
| Vans Old Skool | 7800 |
| Reebok Classic | 6900 |
| Puma Suede | 6200 |
| New Balance 990 | 5800 |
| Asics Gel-Lyte III | 5300 |
| Fila Disruptor | 4700 |
| Saucony Jazz Original | 4100 |
| TOTAL | 68800 |
C
| Product Name | Volume Sales |
|---|---|
| Apple iPhone 13 | 20000 |
| Samsung Galaxy S21 | 18000 |
| OnePlus 10 | 15000 |
| Google Pixel 6 | 12000 |
| Xiaomi Mi 12 | 10000 |
| Oppo Find X4 | 8000 |
| Vivo X70 | 6000 |
| Realme GT Neo2 | 4500 |
| Motorola Edge 20 | 3500 |
| LG V70 | 2500 |
| TOTAL | 99500 |
D
A
B
C
D
Correct answer
C
