Scribd
Upload
30 views2 pages

Activity Title - HR Descriptive Analytics Using Excel

The assignment focuses on applying HR Descriptive Analytics techniques using Microsoft Excel to analyze HR data and compute key metrics. Students will gain hands-on experience with Excel tools, perform calculations for various HR metrics, and create visualizations to present their findings. The final submission includes an Excel file with computed metrics, tables, charts, and analysis of the results.

Uploaded by

Krizelle Joy Dayon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
30 views2 pages

Activity Title - HR Descriptive Analytics Using Excel

The assignment focuses on applying HR Descriptive Analytics techniques using Microsoft Excel to analyze HR data and compute key metrics. Students will gain hands-on experience with Excel tools, perform calculations for various HR metrics, and create visualizations to present their findings. The final submission includes an Excel file with computed metrics, tables, charts, and analysis of the results.

Uploaded by

Krizelle Joy Dayon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Activity title: HR Descriptive Analytics Using Excel

Objective

This assignment will help students apply HR Descriptive Analytics techniques using
Microsoft Excel. Students will analyze HR data, compute key HR metrics, and interpret results
to make data-driven decisions.

Expected Learning Outcomes:


• Hands-on experience with HR data analysis.
• Familiarity with Excel tools like formulas, Pivot Tables, and Charts.
• Understanding of HR descriptive analytics metrics for decision-making.

Instructions

Step 1: Download and Input the HR Data Set

• Open Microsoft Excel and create a new spreadsheet.


• Copy and input the following expanded employee dataset (100 employees) into an Excel
sheet

Step 2: Tasks

1. Compute Descriptive Statistics

Use Excel formulas to calculate:


• Average Salary: =AVERAGE(range_of_salary)
• Median Tenure: =MEDIAN(range_of_tenure)
• Maximum and Minimum Age: =MAX(range_of_age) and =MIN(range_of_age)
• Standard Deviation of Salary: =STDEV(range_of_salary)

2. Generate Summary Insights Using Excel Formulas

• Using the dataset, perform the following calculations for each department (Sales, HR, IT,
Finance) and present the results in a structured table.

• 2.1. Calculate the Average Salary per Department (Use the AVERAGEIF formula)
• 2.2. Count the Number of Employees per Department (Use the COUNTIF formula)
• 2.2. Calculate the Average Performance Rating per Department (Use
the AVERAGEIF formula)

After computing the values, students should create a simple table in Excel to present their
results clearly. Emphasizing the department, Average Salary (PHP), Number of Employees and
Average Performance Rating

3. Create Visualizations
• Bar Chart showing Average Salary per Department.
• Pie Chart showing Percentage of Employees per Department.
Step 3 Analysis and Interpretation

Answer the following questions based on your findings and put your interpretation in another
sheet of your excel file.

3.1. What department has the highest and lowest average salary? Why might this be the
case?
3.2. What is the relationship between tenure and performance rating?
3.3. What trends do you notice in employee absences? Does it correlate with
performance?
3.4. What business decisions can be made based on these insights?

Step 4 Submission Guidelines

• Submit your Excel file with the computed metrics, tables, and charts and analysis and
interpretation.

Prepared by:

Ms. Junalyn P. Samonte


Course Specialist

You might also like