HR Analytics using MS Excel (Excel Analytics)
Using MS Excel's Data Analysis Toolpak to perform HR analytics on various business cases.
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.
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