HR Statistics in Excel | Online Course
Start testing your hypotheses using statistically valid methods. This online course teaches you essential statistical knowledge and how to apply it to human resources questions.
In this statistics training you will follow clear video lessons and practical activities to put your new skills to the test. You will learn how to formulate and test hypotheses in your organization, understand which statistical tests you need to perform and when, and how to support decision-makers with sound statistical analyses of HR data.
Study 3 hrs/week to finish in 5 weeks
only available as part of a certificate program
11 video lessons + 11 activities
What you will do
Learn how to apply statistical tests to HR data
In this online HR course, you will learn the core concepts of statistics and how to apply them within the human resources domain.
+ course structure
Statistical Analysis 101
Validating Hypotheses: Chi-Square & Z Tests
Comparing Groups: The T-Test
Assessing Variations Between Groups: ANOVA & Tukey's HSD
Download the syllabus for a detailed overview of all lessons, assignments, reading materials, and bonus content.
+ meet your instructor
Paul van der Laken
Paul van der Laken is a data science and machine learning expert with a PhD in people analytics. He's managed data science teams and projects at several multinationals, including Shell and Unilever.
Sampling & Surveys
Master different sampling techniques and best practices for survey design
Applying Statistical Tests
Learn when and how to apply statistical tests such as correlation analytics, T-test, and ANOVA
Grasp the concept of statistical significance and the different types of variablesy
Analyzing Data in Excel
Get hands-on with statistical analysis in Excel through practical case studies and activities
Download the syllabus for the People Analytics Certificate Program (includes the HR Statistics in Excel course).
All our programs include
Real-world projects & case-studies
Develop practical skills through working on real-world projects taught by the world’s best leading experts
Global HR practitioners community
Collaborate and solve problems on the spot by connecting with peers and HR professionals from around the world
Globally accredited and recognized programs that are designed to help you learn practical skills and succeed
Customize your learning path with your personal coach who is your one point of contact for everything AIHR
FREQUENTLY ASKED QUESTIONS
How will this HR Statistics in Excel course help me?
If you want to bring HR analytics to the next level, you need to be able to apply core statistical concepts. Finding correlations is a good first step but identifying cause-and-effect relationships is what will help you make an impact on the business using data. This is exactly what you will be learning with the Statistics in HR course. You'll learn the fundamentals of HR statistics and immediately apply your new skills in practical activities and case studies.
Why is this course not sold individually?
To optimize the quality of your learning experience, the HR Statistics in Excel course is not available for standalone enrollment. The course is part of our People Analytics Certificate Program and also included with the Full Academy Access License.
How do statistics help with HR Analytics?
Analytics are inseparable from statistics. Analytics is about making predictions using advanced algorithms or models. To identify which variables to add to your model, what sample size is needed, how effect sizes will impact your algorithm, and to answer many, many more analytics-related questions, you will need to have a solid understanding of statistics. That's what this course focuses on.
SHOW MORE FAQS SHOW LESS
+ Are there any prerequisites?
+ Is there a fixed schedule?
No. This training is 100% online and self-paced! When you learn and how much time you spend each day, week, or month is up to.
In total, you will need to invest approximately 15 hours to finish the course.
+ How long do I have access to the course?
In total, you will have 12 months of access to the member portal, all lessons, and learning materials.
+ Are there subtitles available?
Yes. All our online trainings come with English subtitles. And this course also comes with additional Spanish subtitles!
+ Is this online course the right fit for me?
If you’re not sure if this course is the right fit, we are here to help you determine which training best fits your goals and needs! Simply talk to one of our admissions advisors or send them an email at [email protected]
Are You Ready to Develop In-Demand Skills?
Bring your People Analytics to the Next Level