Quiz Space

Business Data Management · End Term · 21 Dec 2025 · September 2025 term

Question 32: A chain of clinics measures “Doctor Utilization Rate”:\ …

Question 32

+1.5 marksOne correct option

A chain of clinics measures “Doctor Utilization Rate”:
Utilization = Total Consultation Minutes / Available Working Minutes
Data for last quarter: ● Overall across all clinics: Utilization = 80%. ● You then segment by Clinic_Type: ● Urban clinics: Utilization = 78% ● Rural clinics: Utilization = 76%
A senior manager concludes: “Segmentation doesn’t change the picture; utilization is around 77–80% everywhere.”
You dig deeper and find: ● Urban clinics account for 90% of Available Working Minutes. ● Rural clinics account for 10%. ● Within Urban, junior doctors average 60% utilization, senior doctors 95%. ● Within Rural, junior doctors average 85%, senior doctors 70%.
Which statement best describes the main analytical risk in the manager’s conclusion?

  1. A

    The manager ignored seasonality effects across the quarter.

  2. B

    The manager is averaging across subgroups in a way that can hide opposite trends at a finer level

  3. C

    The manager should have used Median utilization instead of Mean.

  4. D

    The manager is wrong because utilization cannot exceed 80% if any subgroup is below 80%.

Show answer

Correct answer

  • B

    The manager is averaging across subgroups in a way that can hide opposite trends at a finer level

See the whole paperTake it as a mock test

Question 32 of 50 in the IIT Madras BS Business Data Management (BDM) End Term paper sat on 21 Dec 2025, in the September 2025 term (Business Data Management 18 Dec 25). It carries 1.5 marks.

More questions from this paper

  1. Q1A beverage company wants to estimate the annual “Addressable Market” (in ₹) for a new premium coffee brand in India. Th…
  2. Q2A "Left Join" between Table A (100 rows) and Table B (100 rows) results in a table with 105 rows. What does this defini…
  3. Q3You are analyzing market share data for the smartphone industry.\ ● Last year, total market volume was 100 million unit…
  4. Q4A B2B SaaS company tracks leads through this funnel:\ ● Stage 1: MQL (Marketing Qualified Lead) ● Stage 2: SQL (Sales Q…
  5. Q5A business analyst is studying how “Macro-economic indicators” relate to the sales of luxury cars. Over the last 3 rece…
  6. Q6You are visualizing a funnel for an e‐commerce site:\ ● Visits → Add to Cart → Checkout → Payment → Order Confirmed\ Yo…
  7. Q7You are given a 100% stacked bar chart comparing market share of 5 competitors over 3 years. Each year’s bar is normali…
  8. Q8A business analyst is studying how “Macro-economic indicators” relate to the sales of luxury cars. Over the last 3 rece…
  9. Q9An external agency provides you with data on both Customer Lifetime Value (CLV) and Share of Wallet (SOW) for your reta…
  10. Q10You are analyzing market share data for the smartphone industry.\ ● Last year, total market volume was 100 million unit…
  11. Q11You are auditing a “Sales Transaction” dataset. For true Beverage items, the “Product Category” column contains:\ ● “Be…
  12. Q12You have the following Tables:\ ● Customer_Master(CustID) with 10,000 active customers. ● Transactions(CustID, TxnDate)…
  13. Q13A retail manager wants to analyze Daily Inventory Turnover for SKU A to identify days with possible stockout risk.\ The…
  14. Q14A beverage company wants to estimate the annual “Addressable Market” (in ₹) for a new premium coffee brand in India. Th…
  15. Q15In a tidy retail dataset, you track weekly sales for 5 stores over 52 weeks. You want a structure that:\ ● Allows you t…
  16. Q16You are presenting to the CEO. She asks: “Which region contributed the most to our profit growth this year compared to …
  17. Q17You have the following Tables:\ ● Customer_Master(CustID) with 10,000 active customers. ● Transactions(CustID, TxnDate)…
  18. Q18In a tidy retail dataset, you track weekly sales for 5 stores over 52 weeks. You want a structure that:\ ● Allows you t…
  19. Q19A SKU (Stock Keeping Unit) has a "Long Tail" sales distribution. In an ABC analysis, this SKU would likely fall into Ca…
  20. Q20You are auditing a “Sales Transaction” dataset. For true Beverage items, the “Product Category” column contains:\ ● “Be…
  21. Q21You are presenting to the CEO. She asks: “Which region contributed the most to our profit growth this year compared to …
  22. Q22You are analyzing "Basket Co-occurrence" (Market Basket Analysis). You find that [Bread, Milk] has high lift, but [Brea…
  23. Q23In a Pivot Table, you drag "Region" to Rows, "Year" to Columns, and "Sales" to Values. You then drag "Sales" into the V…
  24. Q24A chain of gyms analyzes member data and finds:\ ● Strong positive correlation between “Number of Personal Training (PT…
  25. Q25You are visualizing a funnel for an e‐commerce site:\ ● Visits → Add to Cart → Checkout → Payment → Order Confirmed\ Yo…
  26. Q26You are analyzing seasonality for an Ice Cream brand. December sales (in 1,000 units) over the last 5 years were:\ Year…
  27. Q27A small shop owner keeps data in a notebook. For January he writes entries like:\ ● "15th Jan: Sold 10 kg Rice, 5 kg Da…
  28. Q28An external agency provides you with data on both Customer Lifetime Value (CLV) and Share of Wallet (SOW) for your reta…
  29. Q29You are analyzing "Basket Co-occurrence" (Market Basket Analysis). You find that [Bread, Milk] has high lift, but [Brea…
  30. Q30A SKU (Stock Keeping Unit) has a "Long Tail" sales distribution. In an ABC analysis, this SKU would likely fall into Ca…
  31. Q31In a "Churn Prediction" model, you include a variable "Customer calls to support line". You find a positive correlation…
  32. Q33A "Left Join" between Table A (100 rows) and Table B (100 rows) results in a table with 105 rows. What does this defini…
  33. Q34In a Pivot Table, you drag "Region" to Rows, "Year" to Columns, and "Sales" to Values. You then drag "Sales" into the V…
  34. Q35Why is "Metadata" critical for Business Data Management?
  35. Q36A retail manager wants to analyze Daily Inventory Turnover for SKU A to identify days with possible stockout risk.\ The…
  36. Q37You are analyzing seasonality for an Ice Cream brand. December sales (in 1,000 units) over the last 5 years were:\ Year…
  37. Q38A retail chain runs a new loyalty program in only some stores. After 3 months, you compare:\ ● Program stores: average …
  38. Q39A subscription video platform wants to understand “Customer Engagement Value” (CEV) by combining:\ ● Customer_Master(Cu…
  39. Q40A small shop owner keeps data in a notebook. For January he writes entries like:\ ● "15th Jan: Sold 10 kg Rice, 5 kg Da…
  40. Q41A B2B SaaS company tracks leads through this funnel:\ ● Stage 1: MQL (Marketing Qualified Lead) ● Stage 2: SQL (Sales Q…
  41. Q42Why is "Metadata" critical for Business Data Management?
  42. Q43A chain of clinics measures “Doctor Utilization Rate”:\ Utilization = Total Consultation Minutes / Available Working Mi…
  43. Q44A subscription video platform wants to understand “Customer Engagement Value” (CEV) by combining:\ ● Customer_Master(Cu…
  44. Q45A CEO dashboard shows monthly revenue for the last 3 years. You notice:\ ● The y‐axis starts at ₹95 crore instead of 0.…
  45. Q46A CEO dashboard shows monthly revenue for the last 3 years. You notice:\ ● The y‐axis starts at ₹95 crore instead of 0.…
  46. Q47A retail chain runs a new loyalty program in only some stores. After 3 months, you compare:\ ● Program stores: average …
  47. Q48You are given a 100% stacked bar chart comparing market share of 5 competitors over 3 years. Each year’s bar is normali…
  48. Q49A chain of gyms analyzes member data and finds:\ ● Strong positive correlation between “Number of Personal Training (PT…
  49. Q50In a "Churn Prediction" model, you include a variable "Customer calls to support line". You find a positive correlation…