Indian Institute of Technology Madras
BS Degree Programme · Examination & Study Paper
Business Data Management
End Term · 22 Dec 2024 (Afternoon)
Examination Instructions & Guidelines
- Solve on notebook/paper first before checking solutions.
- MCQ: Exactly 1 option is correct. Negative marking applies.
- NAT: Numerical response. No negative marking.
- Scientific calculator allowed for all calculations.
- Official answer key is sealed at the end of this sheet.
- Q1MCQ1 Mark·Choose one option
In the context of economic flow, what do firms provide to households in exchange for labour?
- AServices
- BCapital
- CWages
- DGoods
- Q2MCQ1 Mark·Choose one option
Which Excel function can be used to search for a certain value from another table and retrieve a reference value based on the original table data?
- ASUM
- BIF
- CLINEST
- DVLOOKUP
- Q3MCQ1 Mark·Choose one option
Which of the following is NOT a government source of economic data mentioned in the segment?
- AEconomic Census
- BPeriodic Labour Force Survey (PLFS)
- CPurchasing Managers' Index (PMI)
- DNational Sample Survey
- Q4MCQ1 Mark·Choose one option
What implication does a bimodal distribution in household transportation expenditure data point to?
- AMost households spend a similar amount on transportation
- BThere are two distinct groups of households based on transportation spending
- CTransportation expenditure is evenly distributed across all households
- DThere is a negative correlation between income and transportation spending
- Q5MCQ1 Mark·Choose one option
Which of the following factors is most critical in determining the market potential for a new product?
- AThe size of the target market and percentage of potential customers interested in the product.
- BHistorical sale data of unrelated products.
- CCost of production and distribution.
- DCurrent market share of existing products.
- Q6MCQ1 Mark·Choose one option
What does the Days of Sales of Inventory indicate?
- AThe average number of days required by a company to turn its inventory into sales.
- BThe number of days when inventory is zero in a year
- CTotal number of days when inventory sales is zero due to lack of inventory
- DThe average number of inventory stockout days in a month
- Q7MCQ1 Mark·Choose one option
Which of the following scenarios can be best expressed through a Bar chart?
- AComparing expenditure trends of students.
- BComparing no. of scooter owners, no of bike owners vis- a- vis no of car owners.
- CShowing relationship between temperature and time of the day.
- DAnalyzing correlation between no. of hours students study and their scores in exam
- Q8MCQ1 Mark·Choose one option
Which of the following is typically NOT performed when using a pivot table in data analysis ?
- AFiltering data to display only specific records.
- BCreating new records in the original dataset.
- CGrouping data by categories or fields to analyze trends and patterns.
- DSummarizing data by aggregating values, such as sum, count, or average.
- Q9MCQ1 Mark·Choose one option
Swyft, a new taxi aggregator platform has developed a new recommendation engine called “TinSage?” and they want to test the recommendation engine by doing an A/B test. Can you identify the test and control groups?
- ATest: Random recommendation; Control: TinSage recommendation
- BTest: Old model recommendation; Control: TinSage recommendation
- CTest: TinSage recommendation; Control: Old model recommendation
- DTest: Old model recommendation; Control: Random recommendation
- Q10MCQ1 Mark·Choose one option
What is the primary goal of an A/B test?
- ATest the scalability of a model
- BCompare two or more versions of a product or model to identify the best performer
- CMeasure hardware resource utilization
- DValidate the hypothesis using historical data
- Q11MCQ1 Mark·Choose one option
How do online payment companies make money?
- AInterest from loans/credit
- BTransaction fees (a small cut from the transaction)
- CMonthly subscription
- DBoth Interest from loans/credit and transaction fees
- EAds
- Q12MCQ1 Mark·Choose one option
A form created by HR that outlines the budgetary details, skills and capabilities required etc. is called
- AIndent
- BJob Description
- CEmployee Referral
- DAppraisal
- Q13MCQ2 Marks·Choose one option
Consider the following dataset:
Composite Score= Sum of all criteria on the same scale
Rank the above candidates and choose the correct ranking from the below options- APartha > Akanksha > Lavanya > Siva
- BAkanksha > Lavanya > Siva> Partha
- CPartha < Akanksha < Lavanya < Siva
- DAkanksha < Lavanya < Siva< Partha
- Q14MCQ2 Marks·Choose one option
PePhone is a FinTech firm that processes payments. Following are sources of revenue for the company – 3.5% of transaction amount as transaction fee from merchant for all types of transactions (credit and debit), 18% p.a. interest on credit transactions and incurs a loss of credit if not paid back. Calculate the overall profit for the company based on the below table – (Assume payback of credit in a year) Note: Declined transactions will not get credit but customers will complete the payment through PePhone using their bank details.

- A–167.50
- B– 211.0
- C– 197.74
- D– 162.18
Read the passage below, then answer Q15–Q16
Based on the sample data answer the given subquestions.
Q15MCQ1 Mark·Choose one optionWhat is the market share of Product B as a percentage of total sale amount?
- A17.5
- B16.2
- C18.2
- D19.3
- Q16MCQ1 Mark·Choose one option
What percentage of total market share do products C and E hold together?
- A29.8%
- B44%
- C39.8%
- D49.1%
Read the passage below, then answer Q17–Q18
Company HiringSoft wants to recruit Software Engineers for its new project. The hiring manager was tasked with choosing the appropriate hiring channel. The manager collected previous hiring data (provided in the table below) to help narrow down the appropriate channel. All channels advertised for the vacant positions on the same day.

Based on the above data, answer the given subquestions
Q17MCQ1 Mark·Choose one optionIf the hiring manager has to go only with the parameter, cost per candidate selected, which would be the most appropriate channel?
- ADirect Company Website
- BPrint Ads
- CEmployee Referrals
- DSocial and Professional Media
- Q18MCQ1 Mark·Choose one option
Which channel has the worst selection success rate? The Selection success rate is defined as the no. of candidates selected to the no. of applications shortlisted.
- AHiring Portals
- BSocial and Professional Media
- CPrint Ads
- DEmployee Referrals
Read the passage below, then answer Q19–Q21
Based on following data, answer the given subquestions:
Q19MCQ2 Marks·Choose one optionThe total revenue of the firm is:
- A97290
- B98390
- C96480
- D97560
- Q20MCQ2 Marks·Choose one option
What is the ratio of Widget sale to that of Gadget Sales?
- A0.51
- B0.42
- C0.35
- D0.67
- Q21MCQ1 Mark·Choose one option
Which product has a linearly increasing trend of sales
- AAccessory V
- BWidget G
- CAccessory U
- DGadget K
Read the passage below, then answer Q22–Q25
Based on the data in the table, Calculate the missing values X1, X2, X3 & X4
Q22NAT1.25 Marks·Write the numberEnter the value X1 _________
Your answer:- Q23NAT1.25 Marks·Write the number
Enter the value X2 __________
Your answer: - Q24NAT1.25 Marks·Write the number
Enter the value X3 __________
Your answer: - Q25NAT1.25 Marks·Write the number
Enter the value X4 __________
Your answer: