HR Metrics - Tools to Compile Data

Question 1

HR Analysis in Excel

Query

Answer 1

RQ from data that filters & formats information from a spreadsheet/database.

Question 2

HR Analysis in Excel

Sorting

Answer 2

Arranging data in a specific order (alphabetical, lowest to highest, etc.)

Question 3

HR Analysis in Excel

Filter

Answer 3

Looking for specific data from a location or department.

Question 4

HR Analysis in Excel

VLOOKUP

Answer 4

Excel formula used to filter through data to reveal specific information from two columns and displays it as one.

Question 5

HR Analysis in Excel

Pivot Table

Answer 5

Summarization tool that can sort, count, and sum up data stored in tables and display it via. interactive fields and filter buttons.

Question 6

Statistical Applications Used for HR

Answer 6

1. R
2. Python
3. Power BI (business intelligence)
4. Tableau
5. Excel

Question 7

Evidence-Based Decision Making

Answer 7

Identifying strats and solutions to HR problems using empirical data.

• Gives more credibility to a decision made by HR.
• Collaborative effort - increases communication w all leadership.

Question 8

HRIS (Human Resource Information System)

Answer 8

Designed to help HR professionals carry out the daily functions necessary for the company.

Question 9

Reliability

Answer 9

Refers to if a measure is consistent and repeatable.

Question 10

Validity

Answer 10

If an instrument measures what it’s supposed to measure.

Question 11

Qualitative Data

Answer 11

Data that is categorical and typically non-numerical; based off observations, interviews, etc.

Question 12

Quantitative Data

Answer 12

Data that is numerical & statistics-driven - derived from surveys and other quantifiable media.

Question 13

Descriptive Statistics

Answer 13

Summarizes characteristics of a data set.

• Mean, median, mode - variance or SD.

Question 14

Inferential Statistics

Answer 14

Test hypothesis/make inferences about a larger population based on studying a sample of that population.

• Try to test how dif. variables relate to the larger population.

Question 15

Employee Engagement Survey

Answer 15

An empirical way to analyze an employee’s experience - also allows for open & honest feedback.

Question 16

Pulse Survey

Answer 16

Short survey that empirically measures specific topics in an organization.

• Helps measure changing opinions and trends over time.

Question 17

Types of Interviews

Answer 17

1. Structured Interview
2. Patterned Interview
3. Stress Interview
4. Directive Interview
5. Nondirective Interview
6. Behavioral Interview
7. Situational Interview

Question 18

Types of Interviews

Structured Interview

Answer 18

Interviewee asked the same questions.

Question 19

Types of Interviews

Patterned Interview

Answer 19

Interviewees asked different questions that have the same body of knowledge, skill, or ability

Question 20

Types of Interviews

Stress Interview

Answer 20

Aggressive style of interview - conducted to see how the interviewee would react in that situation.

(Typically used in law enforcement)

Question 21

Types of Interviews

Directive Interview

Answer 21

Structured interview where interviewee asked v specific questions in a calm, controlled manner.

Question 22

Types of Interviews

Nondirective Interview

Answer 22

Interviewee asked open-ended questions with a direction but interviewee can answer it and can drive direction of question somewhere else.

Question 23

Types of Interviews

Behavioral Interview

Answer 23

Asks specific questions about past behavior and performance to gauge the interviewee’s skill.

Question 24

Types of Interviews

Situational Interview

Answer 24

Asked hypothetical situations and how they would consider and solve these situations - gauge knowledge and skills.

Question 25

Employee Focus Groups

Answer 25

Group of employees take part in a guided discussion to find out how they feel about a certain issue or topic.

• Have to tell them identities will be anon & info. is confidential.

Question 26

MBWA - Management by Walking Around

Answer 26

Qualitative communication and involvement method that informally collects information about what employees might be thinking.

• Purpose is to reveal the root of a problem or trend in the workplace.

Question 27

Column & Bar Chart

Answer 27

Used to display and compare categorical data or groupings.

Question 28

Line Chart

Answer 28

Similar to column & bar excepts displays data over a given period of time.

• Used for periodic intervals like months and quarters to illustrate trends.

Question 29

Area Chart

Answer 29

Like line chart except the whole area under the line is colored in.

Question 30

Histogram

Answer 30

Organizes data that falls within a range of values & the frequency of the values.

• Range of values = bins.

Question 31

Scatterplot

Answer 31

Displays correlation between two sets of values.

Question 32

Pie Chart

Answer 32

Represents the distribution of data over a total.

• Proportions in chart usually represented as percentages.

Question 33

Forecasting

Answer 33

Ability to predict or estimate the likelihood of a particular event happening based on past data.

• Used to predict staffing needs and financial impact of all costs relating to labor.

Question 34

Confirmation Bias

Answer 34

Tendency to interpret information that favors a persons already existing beliefs, values, or opinions.

Question 35

Objectivity in Data Analysis

Answer 35

Laying objective approach leads to less bias - bias more common in qualitative data.

• Important since compiling data and analyzing it can influence org decisions.