Hr Analytics Using Ms Excel Excel Analytics

  1. Home
  2. Excel-analytics
  3. Hr Analytics Using Ms Excel Excel Analytics

Tags: Excel Analytics

Using MS Excel's Data Analysis Toolpak to perform HR analytics on various business cases.

Last updated 2022-01-10 | 4

- MS Excel
- Data analysis toolpak
- t test

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

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

Course content

7 sections • 31 lectures

Introduction 1 lectures

Introduction Preview 09:40

Data Analysis Toolpak 1 lectures

Data Analysis Toolpak Preview 02:22

Descriptive Statistics 5 lectures

Data & Course Presentation Preview 00:02

All Workbooks Preview 00:02

Business problem #1 solved using rank and percentile Preview 12:00

Business Problem #2 solved using descriptive statistics Preview 28:41

Business problem #2 solved using histogram Preview 07:49

Inferential Statistics 8 lectures

Inferential stats and hypothesis testing Preview 27:02

Business problem #3 solved using correlation and covariance Preview 24:18

Business problem #4 solved using paired t-test Preview 10:21

Business problem #5 solved using t test unequal variance Preview 07:12

Business problem #6 solved using ANOVA single factor Preview 23:08

Business problem #7 solved using ANOVA two factor with replication Preview 10:18

Business problem #8 solved using ANOVA two factor without replication Preview 06:25

Business problem #9 solved using z test Preview 06:27

Predictive statistics 7 lectures

Predictive Statistics Preview 02:57

Introduction to Linear Regression Preview 45:30

Business problem #10 Preview 02:11

Business problem #10 solved using LR Preview 07:17

Business Problem#11 and introduction to moving average and exponential smoothing Preview 06:08

Solving business problem #11 using moving average Preview 10:46

Solving business problem #11 using exponential smoothing Preview 13:21

Conclusion 1 lectures

Conclusion Preview 03:54

Bonus - Top Excel Formulas you should know 8 lectures

Count and Frequency Preview 13:57

Largest and Smallest Values Preview 03:40

Averages Preview 18:25

Confidence Intervals Preview 09:03

Percentile, Quartiles and Rank Preview 10:34

Deviation and Variance Preview 09:51

Covariance Preview 04:49

Trend Line Functions Preview 11:33