Answer the four questions in details.. use excel sheet and word You can calcula

Answer the four questions in details.. use excel sheet and word
You can calcula

Answer the four questions in details.. use excel sheet and word
You can calculate
the p value using Excel. Suppose that you have a z-score Z. To calculate the two-tailed p-value, use the
following Excel command: =2*(1-NORM.S.DIST(ABS(Z), TRUE)). For example, you could
calculate the p-value of Z = -1.2 using =2*(1-NORM.S.DIST(ABS(-1.2), TRUE)).
Basis
1. State the null hypothesis (H0).
2. Set a significance level (α).
3. Calculate the estimate from the sample.
4. Define the sampling distribution and use it to calculate the p-value.
5. Reject or fail to reject H0 based on whether p-value < α