excel formulas required. p-value, significant level, etc

Satisfaction One-Tailed Hypothesis Tests Q7 Summary Statistics: Hypothesis Test, Sigma Known 6 mean 4.4 expected mean (H0): 4.5 5 standard dev 1.747585 population standard dev. 2.1 2 sample size 75 5 test statistic -0.41239 4 confidence level 0.95 5 significance level 0.05 3 p-value 0.340026 4 2 accept or reject fail to reject 6 5 Hypothesis Test, Sigma Unknown 7 sample standard dev 1.747585 6 6 test statistic -0.49556 5 confidence level 0.9 1 significance level 0.1 6 p-value 0.310838 7 4 accept or reject fail to reject 1 7 5 6 3 3 4 3 5 5 3 2 5 2 5 3 7 5 7 1 4 4 2 3 4

7 7 2 1 7 1 6 3 7 5 4 5 6 4 7 4 4 3 6 5 4 2 3 5 5 4 6 4 3 6 6