Homework SourseUse Excel to find the critical value of z for each hypothesi
Use Excel to find the critical value of z for each hypothesis test. (Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.)
| (a) | 3 percent level of significance, two-tailed test. |
Solution
A.
We divide the significance by half, then find the z score corresponding to it. Thus,
zcrit = +/- 1.036433389
*****************************
B.
Here, we get the z score with left tailed probability of 1- 0.06 = 0.94:
zcrit = 1.750686071
******************************
Here, we get the z score with left tailed probability of 0.09:
zcrit = -1.554773595
*******************************
