Question

Consider the hypotheses shown below. Given that

x̅=61,

σ=15​,

n=42,

α=0.05,

complete parts a and b.

H_o​: μ ≤ 57

H₁: μ > 57

a. What conclusion should be​ drawn?

b. Determine the​ p-value for this test.

Friendly Note: This is an example. For Part a, the answer is Z x̅ = 1.73 and Z α = 1.64 For Part b, the p-value is 0.042.

I just want to know 2 things.

1) How do you find Z α ?! I tried everything but no luck.

2) I understand how to find Z x̅ with the formula, but how would you solve all of the parts a and b with excel? Please go into detail!

Answer 1

1 Here, the level of significance. is given . ie, x=0.05 Hence, we find the critical value 2x = 20.05 = 1.64 [from 2- table] e for a normal curve. -0.05 (w) 1.6 x + 16A so ich thêê value Z falls in in the the then we reject (Ho) e of test satiske critical region ie (w) the null hypother's

To seryoun a 2 - test in Excel follow the below written slets :- 1. Click on the data analysis command button. 2) Select Z-lest: One sample for mean Ok 3) In the variable box → identify the sample values. by clicking and dragging 4) In the alpha box, specify the alpha level for the list 5) Click OK. This is the way to compute za test in Excel. 39383352