Question

Take a Test Kelsey layman-Microsoft Edge B https://www.mathud.com/Student/Player Testaspx?testid-1928742368kcenterwinayes Math 244 winter 2019 PCC Quiz: Week 3 Chapter 21 quiz Time Remaining: ( This Question: 1 pt 2 of 10 This For each of the following situations, find the critical value(s) for z or t b)H, p:008 vs HA p>006 at:005 d)Ho P 06 vs HA p<06ata 0 10, n 300 e)H p 08 vs. HA P08 ata 010 a) The critical value(s) is(are) (Round to two decimal places as noeded Use a comma to separate answers as noeded ) b) The crtical value's) s(are) (Round to two decimal places as nooded Use a comma to separate answers as needed ) c) The crtical values) saro) (Round to two decimal places as needed Use a comma to separale answers as needed) d) The crfical valuets) s(are) Round to two decimal places as needed Use a comma to separate answers as needed ) (Round to two decimal places as needed. Use a comma to separate answers as nooded ) Enter your answer in each of the answer boxes Save for Later
How do I find these on a calculator or using excel??

Answer 1

side	alpha	critical
2	0.01	2.575829
right	0.05	1.644854
2	0.1	1.644854
left	0.1	-1.28155
left	0.1	-1.28155

two decimal place

side	alpha	critical
2	0.01	2.58
right	0.05	1.64
2	0.1	1.64
left	0.1	-1.28
left	0.1	-1.28

formula

side	alpha	critical
2	0.01	=NORM.INV(1-B2/2,0,1)
right	0.05	=NORMSINV(1-B3)
2	0.1	=NORMSINV(1-B4/2)
left	0.1	=NORMSINV(B5)
left	0.1	=NORMSINV(B6)