Hypothesis Testing - Hypothesis z-test for One Sample Mean using Excel’s Data Analysis
4.0(0)
13 learners
What you'll learn
This course includes
3.3 hours of video
Certificate of completion
Access on mobile and TV
Summary
Full Transcript
This video shows how to conduct a one-sample hypothesis z-test for the mean in Microsoft Excel using the built-in Data Analysis (from raw data).
Enable Data Analysis on Windows: https://youtu.be/SqpSwxJ9t2k
Enable Data Analysis on Mac: https://youtu.be/_aJZOoh9xBA
What is Hypothesis Testing? https://youtu.be/TFerpxUr4dg
Intro to hypothesis testing: https://youtu.be/DlwOTOydeyk
One-Sample Z-Test in Excel Using Summary Statistics: https://youtu.be/b0Erbf4n_gQ
Solved 2-tailed hypothesis Z-test: https://youtu.be/QUI4HSUSfII
Data used in this video:
Age
25
30
23
21
24
22
24
25
22
21
22
18
20
24
24
22
23
19
21
20
21
21
19
21
19
24
20
20
20
23
22
23
19
22
19
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.