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: • Hypothesis t-test Template for mean i...
proportion (p) template: • Hypothesis Test for Proportion Templa...