Overview
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 < α