Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Hypothesis Z-test for mean – Excel Template | Hypothesis Testing | critical & p-values
Play lesson

Hypothesis Testing - Hypothesis Z-test for mean – Excel Template | Hypothesis Testing | critical & p-values

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

Keywords

Full Transcript

Solved Z-test for 𝜇 – Excel Template | Hypothesis Testing | critical & p-values This video shows various examples of how to use the Excel/Google Sheets template below to conduct significance tests for one population/sample mean, using both critical region and p-value approaches. 00:00 Example 1 (2-tailed α = 0.01) 01:57 Example 2 (two-tailed, α = 0.05) 02:42 Example 3 (left-tailed, α = 0.05) 03:48 Example 4 (right-tailed, α = 0.05) 04:44 Example 5 (two-tailed, α = 0.05, x̄ = 9.7) 05:44 Example 6 (two-tailed, α = 0.1, x̄ = 9.7) Google Sheets/Excel Template: https://tinyurl.com/4prb7ty2 t-test μ template: https://youtu.be/ymusVe-F4T8 proportion (p) template: https://youtu.be/TE52-_8-yQU Z-test for mean- one-tailed example: https://youtu.be/kNKyhEuqszs

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere