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. | Recruitment Channels | Application Received in 14 days | Application Shortlisted | No. of Candidates appeared for Interview | No. of Candidates Selected | Cost of Advertisement for 14 Days (INR) | |---|---|---|---|---|---| | Employee Referrals | 40 | 32 | 24 | 12 | 120000 | | Direct Company Website | 60 | 12 | 8 | 2 | 5000 | | Social and Professional Media | 260 | 36 | 16 | 4 | 20000 | | Hiring Portals | 220 | 90 | 30 | 6 | 100000 | | Print Ads | 20 | 10 | 8 | 1 | 50000 | Based on the above data, answer the given subquestions If the hiring manager has to go only with the parameter, cost per candidate selected, which would be the most appropriate channel?

(D) Social and Professional Media

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. | Recruitment Channels | Application Received in 14 days | Application Shortlisted | No. of Candidates appeared for Interview | No. of Candidates Selected | Cost of Advertisement for 14 Days (INR) | |---|---|---|---|---|---| | Employee Referrals | 40 | 32 | 24 | 12 | 120000 | | Direct Company Website | 60 | 12 | 8 | 2 | 5000 | | Social and Professional Media | 260 | 36 | 16 | 4 | 20000 | | Hiring Portals | 220 | 90 | 30 | 6 | 100000 | | Print Ads | 20 | 10 | 8 | 1 | 50000 | Based on the above data, answer the given subquestions 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.

(B) Social and Professional Media

September 2024 term · Business Data Management · BSMS2001

Business Data Management End Term: 22 December 2024 (September 2024 term)

The IIT Madras BS Business Data Management (BDM) End Term paper sat on 22 Dec 2024, in the September 2024 term: 25 questions for 30 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.

Questions: 25
Marks: 30
Duration: 180 min
MCQ: 21
Numerical: 4

Take as mock test Practise with answers

Updated 25 Sept 2026

Official paper: IIT M FOUNDATION DIPLOMA AN EXAM QDF3 22 Dec 2024 · No negative marking.

Question 1

+1 markOne correct option

In the context of economic flow, what do firms provide to households in exchange for labour?

A
Services
B
Capital
C
Wages
D
Goods

Show answer

Correct answer

C
Wages

Question 1 on its own page

Question 2

+1 markOne correct 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?

A
SUM
B
IF
C
LINEST
D
VLOOKUP

Show answer

Correct answer

D
VLOOKUP

Question 2 on its own page

Question 3

+1 markOne correct option

Which of the following is NOT a government source of economic data mentioned in the segment?

A
Economic Census
B
Periodic Labour Force Survey (PLFS)
C
Purchasing Managers' Index (PMI)
D
National Sample Survey

Show answer

Correct answer

C
Purchasing Managers' Index (PMI)

Question 3 on its own page

Question 4

+1 markOne correct option

What implication does a bimodal distribution in household transportation expenditure data point to?

A
Most households spend a similar amount on transportation
B
There are two distinct groups of households based on transportation spending
C
Transportation expenditure is evenly distributed across all households
D
There is a negative correlation between income and transportation spending

Show answer

Correct answer

B
There are two distinct groups of households based on transportation spending

Question 4 on its own pageAlso asked in Quiz 1 15 Mar 2026

Question 5

+1 markOne correct option

Which of the following factors is most critical in determining the market potential for a new product?

A
The size of the target market and percentage of potential customers interested in the product.
B
Historical sale data of unrelated products.
C
Cost of production and distribution.
D
Current market share of existing products.

Show answer

Correct answer

A
The size of the target market and percentage of potential customers interested in the product.

Question 5 on its own pageAlso asked in End Term 13 Apr 2025, Quiz 2 3 Aug 2025, Quiz 1 15 Mar 2026

Question 6

+1 markOne correct option

What does the Days of Sales of Inventory indicate?

A
The average number of days required by a company to turn its inventory into sales.
B
The number of days when inventory is zero in a year
C
Total number of days when inventory sales is zero due to lack of inventory
D
The average number of inventory stockout days in a month

Show answer

Correct answer

A
The average number of days required by a company to turn its inventory into sales.

Question 6 on its own pageAlso asked in End Term 13 Apr 2025

Question 7

+1 markOne correct option

Which of the following scenarios can be best expressed through a Bar chart?

A
Comparing expenditure trends of students.
B
Comparing no. of scooter owners, no of bike owners vis- a- vis no of car owners.
C
Showing relationship between temperature and time of the day.
D
Analyzing correlation between no. of hours students study and their scores in exam

Show answer

Correct answer

B
Comparing no. of scooter owners, no of bike owners vis- a- vis no of car owners.

Question 7 on its own page

Question 8

+1 markOne correct option

Which of the following is typically NOT performed when using a pivot table in data analysis ?

A
Filtering data to display only specific records.
B
Creating new records in the original dataset.
C
Grouping data by categories or fields to analyze trends and patterns.
D
Summarizing data by aggregating values, such as sum, count, or average.

Show answer

Correct answer

B
Creating new records in the original dataset.

Question 8 on its own pageAlso asked in Quiz 2 3 Aug 2025

Question 9

+1 markOne correct 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?

A
Test: Random recommendation; Control: TinSage recommendation
B
Test: Old model recommendation; Control: TinSage recommendation
C
Test: TinSage recommendation; Control: Old model recommendation
D
Test: Old model recommendation; Control: Random recommendation

Show answer

Correct answer

C
Test: TinSage recommendation; Control: Old model recommendation

Question 9 on its own page

Question 10

+1 markOne correct option

What is the primary goal of an A/B test?

A
Test the scalability of a model
B
Compare two or more versions of a product or model to identify the best performer
C
Measure hardware resource utilization
D
Validate the hypothesis using historical data

Show answer

Correct answer

B
Compare two or more versions of a product or model to identify the best performer

Question 10 on its own page

Question 11

+1 markOne correct option

How do online payment companies make money?

A
Interest from loans/credit
B
Transaction fees (a small cut from the transaction)
C
Monthly subscription
D
Both Interest from loans/credit and transaction fees
E
Ads

Show answer

Correct answer

D
Both Interest from loans/credit and transaction fees

Question 11 on its own page

Question 12

+1 markOne correct option

A form created by HR that outlines the budgetary details, skills and capabilities required etc. is called

A
Indent
B
Job Description
C
Employee Referral
D
Appraisal

Show answer

Correct answer

A
Indent

Question 12 on its own page

Question 13

+2 marksOne correct 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

A
Partha > Akanksha > Lavanya > Siva
B
Akanksha > Lavanya > Siva> Partha
C
Partha < Akanksha < Lavanya < Siva
D
Akanksha < Lavanya < Siva< Partha

Show answer

Correct answer

A
Partha > Akanksha > Lavanya > Siva

Question 13 on its own page

Question 14

+2 marksOne correct 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.

Cust ID	Date of Application	Cust Segment	Application Credit Score	Application Amount	Approved_vs_Declined	Decline Reason	Paid Back or Defaulted
17289	26/03/21	Low	588	168	Approved		Paid Back
17290	17/02/21	Mid	635	109	Approved		Defaulted
17291	23/02/21	High	455	183	Declined	System Issue	NA
17292	20/02/21	Mid	484	334	Declined	Credit Risk	NA
17293	05/02/21	Mid	637	102	Approved		Defaulted
17294	11/01/21	Mid	559	499	Declined	Credit Risk	NA

A
–167.50
B
– 211.0
C
– 197.74
D
– 162.18

Show answer

Correct answer

A
–167.50

Question 14 on its own page

Question 15

+1 markOne correct option

Based on the sample data answer the given subquestions.

Products	Sale amount
Product A	22,000
Product B	18,000
Product C	29,000
Product D	16,500
Product E	25,500

What is the market share of Product B as a percentage of total sale amount?

A
17.5
B
16.2
C
18.2
D
19.3

Show answer

Correct answer

B
16.2

Question 15 on its own page

Question 16

+1 markOne correct option

Based on the sample data answer the given subquestions.

Products	Sale amount
Product A	22,000
Product B	18,000
Product C	29,000
Product D	16,500
Product E	25,500

What percentage of total market share do products C and E hold together?

A
29.8%
B
44%
C
39.8%
D
49.1%

Show answer

Correct answer

D
49.1%

Question 16 on its own page

Question 17

+1 markOne correct option

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.

Recruitment Channels	Application Received in 14 days	Application Shortlisted	No. of Candidates appeared for Interview	No. of Candidates Selected	Cost of Advertisement for 14 Days (INR)
Employee Referrals	40	32	24	12	120000
Direct Company Website	60	12	8	2	5000
Social and Professional Media	260	36	16	4	20000
Hiring Portals	220	90	30	6	100000
Print Ads	20	10	8	1	50000

Based on the above data, answer the given subquestions

If the hiring manager has to go only with the parameter, cost per candidate selected, which would be the most appropriate channel?

A
Direct Company Website
B
Print Ads
C
Employee Referrals
D
Social and Professional Media

Show answer

Correct answer

A
Direct Company Website

Question 17 on its own page

Question 18

+1 markOne correct option

Recruitment Channels	Application Received in 14 days	Application Shortlisted	No. of Candidates appeared for Interview	No. of Candidates Selected	Cost of Advertisement for 14 Days (INR)
Employee Referrals	40	32	24	12	120000
Direct Company Website	60	12	8	2	5000
Social and Professional Media	260	36	16	4	20000
Hiring Portals	220	90	30	6	100000
Print Ads	20	10	8	1	50000

Based on the above data, answer the given subquestions

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.

A
Hiring Portals
B
Social and Professional Media
C
Print Ads
D
Employee Referrals

Show answer

Correct answer

A
Hiring Portals

Question 18 on its own pageAlso asked in End Term 7 Aug 2022, End Term 7 Aug 2022

Question 19

+2 marksOne correct option

Based on following data, answer the given subquestions:

Product Name	Prod. ID	Month 1 Sales	Month 2 Sales	Month 3 Sales	Unit Price ($)
Widget G	SKU16	140	160	150	22
Widget H	SKU17	95	105	100	30
Gadget K	SKU18	210	230	220	50
Gadget L	SKU19	65	75	70	45
Accessory U	SKU20	50	60	55	35
Widget I	SKU21	130	140	135	25
Gadget M	SKU22	120	130	125	40
Accessory V	SKU23	55	60	65	28

The total revenue of the firm is:

A
97290
B
98390
C
96480
D
97560

Show answer

Correct answer

A
97290

Question 19 on its own page

Question 20

+2 marksOne correct option

Based on following data, answer the given subquestions:

Product Name	Prod. ID	Month 1 Sales	Month 2 Sales	Month 3 Sales	Unit Price ($)
Widget G	SKU16	140	160	150	22
Widget H	SKU17	95	105	100	30
Gadget K	SKU18	210	230	220	50
Gadget L	SKU19	65	75	70	45
Accessory U	SKU20	50	60	55	35
Widget I	SKU21	130	140	135	25
Gadget M	SKU22	120	130	125	40
Accessory V	SKU23	55	60	65	28

What is the ratio of Widget sale to that of Gadget Sales?

A
0.51
B
0.42
C
0.35
D
0.67

Show answer

Correct answer

A
0.51

Question 20 on its own page

Question 21

+1 markOne correct option

Based on following data, answer the given subquestions:

Product Name	Prod. ID	Month 1 Sales	Month 2 Sales	Month 3 Sales	Unit Price ($)
Widget G	SKU16	140	160	150	22
Widget H	SKU17	95	105	100	30
Gadget K	SKU18	210	230	220	50
Gadget L	SKU19	65	75	70	45
Accessory U	SKU20	50	60	55	35
Widget I	SKU21	130	140	135	25
Gadget M	SKU22	120	130	125	40
Accessory V	SKU23	55	60	65	28

Which product has a linearly increasing trend of sales

A
Accessory V
B
Widget G
C
Accessory U
D
Gadget K

Show answer

Correct answer

A
Accessory V

Question 21 on its own page

Question 22

+1.25 marksNumerical answer

Based on the data in the table, Calculate the missing values X1, X2, X3 & X4

Enter the value X1 _________

Show answer

Correct answer: 1

Question 22 on its own page

Question 23

+1.25 marksNumerical answer

Based on the data in the table, Calculate the missing values X1, X2, X3 & X4

Enter the value X2 __________

Show answer

Correct answer: 180

Question 23 on its own page

Question 24

+1.25 marksNumerical answer

Based on the data in the table, Calculate the missing values X1, X2, X3 & X4

Enter the value X3 __________

Show answer

Correct answer: 83.25 (accepted within ±0.25)

Question 24 on its own page

Question 25

+1.25 marksNumerical answer

Based on the data in the table, Calculate the missing values X1, X2, X3 & X4

Enter the value X4 __________

Show answer

Correct answer: 65.375 (accepted within ±0.375)

Question 25 on its own page