HR Analytics using MS Excel

Beginner English
Created by Smart Futures
Last updated Sun, 08-Jan-2023
+ View more
Course overview

What will i learn?

Requirements
Curriculum for this course
28 Lessons 05:08:11 Hours
HR Analytics-Introduction
1 Lessons 00:09:37 Hours
  • Introduction
    Preview 00:09:37
Data Analysis Toolpack
1 Lessons 00:02:18 Hours
  • Data Analysis Toolpack
    00:02:18
Descriptive Statistics
2 Lessons 00:19:43 Hours
  • Business problem #1 solved
    00:11:54
  • Business problem #2 solved using histogram
    00:07:49
Inferential Statistics
8 Lessons 01:44:13 Hours
  • Inferential stats and hypothesis testing
    00:26:58
  • Business problem #3 solved using correlation and covariance
    00:13:45
  • Business problem #4 solved using paired t-test
    00:10:17
  • Business problem #5 solved using t test unequal variance
    00:07:08
  • Business problem #6 solved using ANOVA single factor
    00:23:04
  • Business problem #7 solved using ANOVA two factor with replication
    00:10:16
  • Business problem #8 solved using ANOVA two factor without replication
    00:06:21
  • Business problem #9 solved using z test
    00:06:24
Predictive statistics
7 Lessons 01:26:54 Hours
  • Predictive statistics
    00:02:49
  • Introduction to Linear Regression
    00:45:18
  • Business problem #10
    00:01:31
  • . Business problem #10 solved using LR
    00:07:14
  • Business Problem#11 and introduction to moving average and exponential smoothing
    00:06:03
  • Solving business problem #11 using moving average
    00:10:42
  • Solving business problem #11 using exponential smoothing
    00:13:17
Conclusion
1 Lessons 00:03:50 Hours
  • Conclusion
    00:03:50
Bonus-Top excel formula you should know
8 Lessons 01:21:36 Hours
  • Count and Frequency
    00:13:53
  • Largest and Smallest Values
    00:03:56
  • Averages
    00:18:17
  • Confidence Intervals
    00:09:00
  • Percentile, Quartiles and Rank
    00:10:30
  • Deviation and Variance
    00:09:47
  • Covariance
    00:04:45
  • Trend Line Functions
    00:11:28
+ View more
Other related courses
01:45:48 Hours
Updated Sat, 07-Jan-2023
0 ₹2999 ₹799
00:00:00 Hours
Updated Sat, 11-Mar-2023
0 ₹0
About instructor

Smart Futures

17 Students | 18 Courses
₹1599 ₹999
Includes: