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

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.