Your cart is empty.
Keep shoppingHR Analytics using MS Excel (Excel Analytics)
1,038 students
HR Analytics using MS Excel (Excel Analytics)
Using MS Excel's Data Analysis Toolpak to perform HR analytics on various business cases.
Created byUnlock HR
Last updated 7/2020
English
What you'll learn
- MS Excel
- Data analysis toolpak
- t test
- anova
- z test
- correlation
- covariance
- histogram
- LR
- moving average
- exponential smoothing
Explore related topics
Course content
7 sections • 31 lectures • 5h 49m total length
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