# Question: Use Excel to find the critical value of z for

Use Excel to find the critical value of z for each hypothesis test.

a. 10 percent level of significance, two-tailed test

b. 1 percent level of significance, right-tailed test

c. 5 percent level of significance, left-tailed test

a. 10 percent level of significance, two-tailed test

b. 1 percent level of significance, right-tailed test

c. 5 percent level of significance, left-tailed test

## Answer to relevant Questions

Use Excel to find the critical value of z for each hypothesis test. a. α = .05, two-tailed test b. α = .10, right-tailed test c. α = .01, left-tailed test Define Type I and Type II error for each scenario, and identify the cost(s) of each type of error. a. A 25-year-old ER patient in Minneapolis complains of chest pain. Heart attacks in 25-year-olds are rare, and beds are ...Discuss the issues of statistical significance and practical importance in each scenario. a. A process for producing I-beams of oriented strand board used as main support beams in new houses has a mean breaking strength of ...Find the p-value using Excel (not Appendix D): a. t = 1.457, d.f. = 14, right-tailed test b. t = 2.601, d.f. = 8, two-tailed test c. t = 21.847, d.f. = 22, left-tailed test The number of entrees purchased in a single order at a Noodles & Company restaurant has had an historical average of 1.60 entrees per order. On a particular Saturday afternoon, a random sample of 40 Noodles orders had a mean ...Post your question