Question

Confused on calculating the critical value w/ excel. I got 1.65 instead of 1.645.

ayout Formulas Data Review view Help Tell me what you want to do =T.INV.2T(0.1,368) Chapter 10 Homework Е F Н (Or Areas Under t-Distribution Curve) 0.95 0.025 0.05 0.99 0.005 0.01 0.8 0.1 0.2 0.98 0.01 0.02 0.7 0.15 0.3 0.9 0.05 0.1 BUS204 Hybrid W130PM - Fall 2019 Values of t Homework: Chapter 10 Homework 1.0877 1.3634 1.7959 2.2010 2.7181 3.1058 Save 1.0832 1.0795 1.3562 1.7823 2.1788 2.6810 3.0545 2.1604 1.3502 1.7709 2.6503 3.0123 HW Score: 54.2.. Score: 1 of 4 pts 6 of 7 (6 complete) 2.9768 2.9467 1.7613 2.1448 2.6245 1.0763 1.3450 V10.4.57 Question Help 1.0735 1.3406 1.7531 2.1314 2.6025 1.0364 1.2816 1.6449 1.9600 2.3263 2.5758 Suppose as a part of a national study research firm randomly sampled 170 adults between the ages of 27 and 35 living in City A and 200 adults between the ages of 27 and 35 living in City B. Each adult selected in the sample was asked, among other things, whether they had a college degree. From the City A sample 41 adults answered yes and from the City B sample 56 adults answered yes when asked if they had a college degree. Based on the sample data, can we conclude that there is a difference between the population proportions of adults between the ages of 27 and 35 in the two cities with college degrees? Use a level of significance of 0.10 to conduct the appropriate hypothesis test economic competitiveness a marketing is Finding Critical Value t, when Population Standard Deviation is Unknown (t-values) -1.2816 Lower-Tailed Test (Left): =T.INV(a, df) 1.282 Upper-Tailed Test (Right): =T.INV(1-a, df) Two-Tailed Test: =T.INV.2T(a, df) TA P1P2U 1.65 ОЕ. Н Р, - Р220 На Р, - Ра<0 F.Ho P-P2= 0 HA P1-P20 OD. Ho P1-P20 На Р, - Ра> 0 d a positive critical value Finding p-Value, when Population Standard Deviation is Unknown (t-values) Determine the critical value(s). Select the correct choice below and fill in the answer box in your choice. (Round to three decimal places as needed.) XA. The critical value is z Lower-Tailed Test (negative t-value) =T.DIST(t, df,true) Upper-Tailed Test (positive t-value) =T.DIST.RT(t, df) Two-Tailed Test: =T.DIST.2T(t, df) B. The critical values are tz/ = t 1.645 ? Enter your answer in the answer box and then click Check Answer. ez value, enter it as a positive value Check Answer part remaining Clear All as on the left for Z-Values

Answer 1

When we read instructions it says round to three decimal places.

In your excel it may that the cell is rounding this to 2 decimal places.

fc =NORMINV(0.95,0,1) в 1.64485363!

Here I applied the same thing and the result is 1.64485 when we round this off to 3 decimal it will be 1.645.

I hope this will help. Thank you.