HR Analytics using MS Excel (Excel Analytics)

HR Analytics using MS Excel (Excel Analytics), available at $49.99, has an average rating of 4.15, with 31 lectures, based on 238 reviews, and has 1014 subscribers.

You will learn about MS Excel Data analysis toolpak t test anova z test correlation covariance histogram LR moving average exponential smoothing This course is ideal for individuals who are Human Resource students or HR Proffesionals It is particularly useful for Human Resource students or HR Proffesionals.

Enroll now: HR Analytics using MS Excel (Excel Analytics)

Summary

Title: HR Analytics using MS Excel (Excel Analytics)

Price: $49.99

Average Rating: 4.15

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: ₹7,900

Quality Status: approved

Status: Live

What You Will Learn

MS Excel
Data analysis toolpak
t test
anova
z test
correlation
covariance
histogram
LR
moving average
exponential smoothing

Who Should Attend

Human Resource students
HR Proffesionals

Target Audiences

Human Resource students
HR Proffesionals

The present course centers around learning wide applications of Data Analysis ToolPak and applying the same to solve real business problems. Data Analysis Toolpak is an add-in for Microsoft Excel. An add-in is simply a hidden workbook that adds additional functions and features to Microsoft Excel. Data Analysis Toolpak provides data analysis tools for statistical and engineering analysis.

Real life business problems are used as case studies to understand different tools that come with Data Analysis Toolpak.

Different types of descriptive statistics tools are used to quantitatively describe or summarize the features of collected information.

Inferential statistics tools are used to make inferences about the population with the use of random samples taken from the data.

Predictive statistics tools are used to make predictions about unknown future events.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Data Analysis Toolpak

Lecture 1: Data Analysis Toolpak

Chapter 3: Descriptive Statistics

Lecture 1: Data & Course Presentation

Lecture 2: All Workbooks

Lecture 3: Business problem #1 solved using rank and percentile

Lecture 4: Business Problem #2 solved using descriptive statistics

Lecture 5: Business problem #2 solved using histogram

Chapter 4: Inferential Statistics

Lecture 1: Inferential stats and hypothesis testing

Lecture 2: Business problem #3 solved using correlation and covariance

Lecture 3: Business problem #4 solved using paired t-test

Lecture 4: Business problem #5 solved using t test unequal variance

Lecture 5: Business problem #6 solved using ANOVA single factor

Lecture 6: Business problem #7 solved using ANOVA two factor with replication

Lecture 7: Business problem #8 solved using ANOVA two factor without replication

Lecture 8: Business problem #9 solved using z test

Chapter 5: Predictive statistics

Lecture 1: Predictive Statistics

Lecture 2: Introduction to Linear Regression

Lecture 3: Business problem #10

Lecture 4: Business problem #10 solved using LR

Lecture 5: Business Problem#11 and introduction to moving average and exponential smoothing

Lecture 6: Solving business problem #11 using moving average

Lecture 7: Solving business problem #11 using exponential smoothing

Chapter 6: Conclusion

Lecture 1: Conclusion

Chapter 7: Bonus – Top Excel Formulas you should know

Lecture 1: Count and Frequency

Lecture 2: Largest and Smallest Values

Lecture 3: Averages

Lecture 4: Confidence Intervals

Lecture 5: Percentile, Quartiles and Rank

Lecture 6: Deviation and Variance

Lecture 7: Covariance

Lecture 8: Trend Line Functions

Instructors

Unlock HR
HR Analytics / People Analytics / Talent Analytics

Rating Distribution

1 stars: 3 votes
2 stars: 13 votes
3 stars: 49 votes
4 stars: 104 votes
5 stars: 69 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu