HR Analytics using MS Excel (Excel Analytics)
4.1 (78 ratings)
328 students enrolled

HR Analytics using MS Excel (Excel Analytics)

Using MS Excel's Data Analysis Toolpak to perform HR analytics on various business cases.
4.1 (78 ratings)
328 students enrolled
Created by Unlock HR
Last updated 3/2020
English
English [Auto-generated]
Current price: \$132.99 Original price: \$189.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 6 hours on-demand video
• 2 articles
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• MS Excel
• Data analysis toolpak
• t test
• anova
• z test
• correlation
• covariance
• histogram
• LR
• moving average
• exponential smoothing
Requirements
• Software Requirement : MS Excel
• Anyone can take this course.
Description

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.

Who this course is for:
• Human Resource students
• HR Proffesionals
Course content
Expand all 31 lectures 05:49:44
+ Descriptive Statistics
5 lectures 48:35
Data
00:02
All Workbooks
00:02
Business Problem #2 solved using descriptive statistics
28:41
Business problem #2 solved using histogram
07:49
+ Inferential Statistics
8 lectures 01:55:11
Inferential stats and hypothesis testing
27:02
Business problem #3 solved using correlation and covariance
24:18
Business problem #4 solved using paired t-test
10:21
Business problem #5 solved using t test unequal variance
07:12
Business problem #6 solved using ANOVA single factor
23:08
Business problem #7 solved using ANOVA two factor with replication
10:18
Business problem #8 solved using ANOVA two factor without replication
06:25
Business problem #9 solved using z test
06:27
+ Predictive statistics
7 lectures 01:28:10
Predictive Statistics
02:57
Introduction to Linear Regression
45:30
02:11
Business problem #10 solved using LR
07:17
Business Problem#11 and introduction to moving average and exponential smoothing
06:08
Solving business problem #11 using moving average
10:46
Solving business problem #11 using exponential smoothing
13:21
+ Bonus - Top Excel Formulas you should know
8 lectures 01:21:52
Count and Frequency
13:57
Largest and Smallest Values
03:40
Averages
18:25
Confidence Intervals
09:03
Percentile, Quartiles and Rank
10:34
Deviation and Variance
09:51
Covariance
04:49
Trend Line Functions
11:33