NPTEL HR Analytics Week 1 And 2 Assignment Answers 2024

1. HR Analytics can help in which of the following ways?

A) Increasing product sales
B) Reducing the company’s marketing budget
C) Enhancing customer service quality
D) Improving employee retention
✅ Answer: D – Improving employee retention

Explanation:
HR analytics focuses on human resource functions such as hiring, performance, and retention. By analyzing turnover trends, feedback, and engagement, companies can take proactive measures to retain employees.

2. In HR Analytics, what does “data cleaning” refer to?

A) Archiving old employee records
B) Organizing employee files
C) Encrypting sensitive data
D) Correcting or removing inaccurate data from datasets
✅ Answer: D – Correcting or removing inaccurate data from datasets

Explanation:
Data cleaning ensures data quality by removing duplicate, outdated, or incorrect information, which is essential for reliable HR analysis.

3. What does KPI stand for?

A) Key Product Indicator
B) Key Profit Indicator
C) Key Performance Indicator
D) Key Project Indicator
✅ Answer: C – Key Performance Indicator

Explanation:
KPI is a measurable value that shows how effectively an individual, team, or company is achieving business objectives.

4. HRIS is primarily used for customer relationship management.

A) True
B) False
✅ Answer: B – False

Explanation:
HRIS (Human Resource Information System) is for managing employee-related data, not for customer relationship management, which is handled by CRM systems.

5. What type of analytics answers the question “What did happen”?

A) Predictive analytics
B) Descriptive analytics
C) Diagnostic analytics
D) Prescriptive analytics
✅ Answer: B – Descriptive analytics

Explanation:
Descriptive analytics summarizes past data to understand what happened. It forms the base for further analysis like diagnosis or prediction.

6. What is the average value of a data set called?

A) Median
B) Mode
C) Mean
D) Standard deviation
✅ Answer: C – Mean

Explanation:
The mean is the arithmetic average and one of the most common measures of central tendency used in data analysis.

7. What does the LAMP model in HR analytics stand for?

A) Logic, Analytics, Measures, Processes
B) Leadership, Analytics, Management, Performance
C) Learning, Assessment, Measurement, Planning
D) Logic, Assessment, Metrics, Procedures
✅ Answer: A – Logic, Analytics, Measures, Processes

Explanation:
The LAMP model helps organizations measure and manage talent by combining logic, analytics, metrics, and actionable processes.

8. The HR scorecard is only used for measuring employee satisfaction.

A) True
B) False
✅ Answer: B – False

Explanation:
The HR scorecard evaluates overall HR performance, including talent management, productivity, and strategy alignment—not just employee satisfaction.

9. What is the primary focus of prescriptive analytics?

A) Describing past events
B) Explaining why past events happened
C) Predicting future events
D) Suggesting actions to achieve desired outcomes
✅ Answer: D – Suggesting actions to achieve desired outcomes

Explanation:
Prescriptive analytics recommends what should be done next by using AI, simulations, or optimization models to improve outcomes.

10. Which of the following is NOT a common data source for HR Analytics?

A) Employee performance records
B) Customer feedback
C) Attendance records
D) Compensation details
✅ Answer: B – Customer feedback

Explanation:
Customer feedback is more relevant to marketing and product teams. HR analytics focuses on employee-centric data like performance, compensation, and attendance.

NPTEL HR Analytics Week 2 Assignment Answers

1. What is the first step in the data analytics process?

A) Data Preparation
B) Data Collection
C) Data Analysis
D) Data Visualization
✅ Answer: B – Data Collection

Explanation:
Before analyzing or visualizing anything, data must first be collected from various sources such as surveys, databases, APIs, Excel, etc.

2. What does Power BI stand for?

A) Business Intelligence
B) Business Insights
C) Business Integration
D) Business Innovation
✅ Answer: A – Business Intelligence

Explanation:
Power BI is a Microsoft tool used for interactive Business Intelligence reporting and data visualization.

3. What is a common tool for creating data visualizations in Excel?

A) PivotTable
B) VLOOKUP
C) SUM function
D) Data Validation
✅ Answer: A – PivotTable

Explanation:
PivotTables help summarize, sort, and visualize large datasets in Excel, often paired with PivotCharts for graphical analysis.

4. What is the purpose of data preparation in the data analytics process?

A) To visualize data
B) To clean and organize data for analysis
C) To collect data
D) To present findings
✅ Answer: B – To clean and organize data for analysis

Explanation:
Data preparation involves cleaning, transforming, and organizing raw data into a usable format for analysis.

5. Which Excel feature is used to create visual representations of data?

A) Data Validation
B) Charts and Graphs
C) Data Bars
D) Pivot Tables
✅ Answer: B – Charts and Graphs

Explanation:
Charts and graphs like bar charts, pie charts, and line charts in Excel are essential for visualizing data patterns.

6. True or False: Findings should not be presented in a clear and concise manner to facilitate decision-making.

✅ Answer: False

Explanation:
Clear and concise presentation of findings is critical for effective communication and helps stakeholders make informed decisions.

7. Which of the following is NOT a visualization best practice in Power BI?

A) Using appropriate color schemes
B) Adding too much detail to visualizations
C) Ensuring readability and clarity
D) Providing clear titles and labels
✅ Answer: B – Adding too much detail to visualizations

Explanation:
Too much detail can clutter the visualization and confuse viewers. Best practice is to keep visuals simple, clear, and informative.

8. True or False: Data collection can include importing data from online databases, Excel files, and CSV files.

✅ Answer: True

Explanation:
Data collection can be manual or automated and includes importing from diverse sources like Excel, APIs, CSV, online databases, etc.

9. True or False: Data visualization does not help in identifying patterns and trends in the data.