Question

please help on this entire question and if possible can you show me how to solve on excel with formulas? thank you so much in advance!

You may need to use the appropriate technology to answer this question Consider the following hypothesis test. Ho: Moso HAN>O (a) The following data are from matched samples taken from two populations. Compute the difference value for each element. (Use Population 1 - Population 2.) Population 1 | 2 Element Difference Inele 26 (b) Computea (c) Compute the standard deviation de (d) Conduct a hypothesis test using a = 0.05. Calculate the test statistic, (Round your answer to three decimal places.) Calculate the p-value. (Round your answer to four decimal places.) p-value = What is your conclusion? Reject Ho. There is sufficient evidence to conclude that a > 0. Reject Ho. There is insufficient evidence to conclude that > 0. Do not Reject Ho. There is sufficient evidence to conclude that Hd > 0 Do not reject Ho. There is insufficient evidence to conclude that Mo0.

Answer 1

solation Cosside the hypothesis teist is Rescrired information its given by -> kur hypothesis, is Ho: Old sol -> AHinative hypothesis is He: lid so Calculate i @ Compute the diffrence for each elementi we have to obtained the difference value is (fere, for each element Palation populational da-P9 06 Iold - Zd=6 comparte ő: mla bo oblained the mean a' by using gilan data is Eers

Med There fore Mean elā Els] © Compute the Clancord Ceviation Cain deviation by using We have to obtained the standard given data is Eere, (Standord deviation is Ecdi-d2 = Tro-l-002+C1-1-0024C0-1-0)2CD-019327 Co-0.1932 7 VE 65-12 B. Jut..04 +060+0.01Li4to.oluuj 3.92188 svo.98-12 Gozo.29057 - 10.99367

od conduct hypothest test's We have to obtained the test Chatilti 64 usina aika ale is Elere, esta Gatistia ias, a-eld to Salon [1.22–0] (0.29363|15 les 0.4414105 F = 2.70 Therefore test istatistic = (2- tos) - Ceil Calculate plaket- ke halo to obtained the p Cake by using given data is Elere, pvalcea its pKalce = [t-test, dfany] =[9. tol, df=51) = [0. tol, u] = 0.027] Therefore, pralce its 0.007

Cu cohat your concorsion We have to compared place and a = 0.05 is tres P-lalo a 0.00 0.05 > Revected the call bypothesis is at 2=0.05 Therefore, There is Reject to. sufficient evidence to Con clad that lid so option is correct an Sever.