Hi could you help me with this statistics problem Yhank you

81% Ev T View Zoom Add Category nsert Table Chart Text Shape Media Comment + Sheet1 #1 #2 #3 #4 #5 #6 O) A B C D E F G H K M N O P Q R S Intervention Control 2.8 4.6 A different study with the data shown examined the effect of food-counseling sessions provided by trained professionals. -2 4.5 The study randomly assigned obese children aged 9 to 12 years to either the counseling intervention or a control group not receiving any food counseling. The children's weight changes (in pounds, (b) after 15 weeks are displayed in the table -1.8 2.8 - 1.8 or both conditions. Note that a negative number means they lost weight. 2.8 -1.4 2.8 Using the resulting p values (lower, upper and two tail), show that you reach different conclusions for the following: -12 27 WN = OOO VOUTD WN -0.2 6.1 1) Researchers want to test the hypothesis that the weight loss for the intervention group is greater than the weight loss -01 4.8 for the control group. Use a confidence level of 95% 4.6 0.2 4.5 2) Researchers want to test a revised hypothesis that checks to see if the weight lose for the intervention group is 0.6 2.8 different from the weight lose for the control group. Use a confidence level of 95% 2.8 15 12 2.8 12 2.7 14 18 o 16 Point Estimate 0.2 10 n1 0.6 0.7 n2 use formulas 2.5 0.4 x1 Type out your answers to the questions below in THIS box use formulas 2.8 0.1 X2 use formulas 1) State the null and alternative hypotheses for BOTH scenarios (see top of tables) 41 0.1 x1-x 4 - 5.1 ATResearch1 4 -5.1 Standard Error, t_stat, P_value -3.6 2.8 51 use formulas -3.5 2.7 $2 Research2: use formulas -3.2 18 a=s1421 -2.8 16 b=s2422 4 -2 10 SE A Esqrt(a+b) 2) Compare the p_value to p_critical. Do you "reject" or "not reject" your null hypothesis? -18 0.7 t_sta =(x1-x2)/SE In words what does this mean: -1.8 0.4 dof long formula - 14 0.1 Research1 -12 0 1 lower tail use T.Dist( 34 -0.2 -5.1 upper tail 1000000 =1-lower 35 -0.1 Research2 two ta 0.000000 double the smallest o 0.2 critical values (input alpha 0.6 alpha 0.050 39 40 1 t_crit use T.INVO 3) compare the t_value to t_critical. Do you get the same result? Type in the values and answer below. 12 alpha/ 0.025 for two-tailed test 41 t_crit different critical value for t Research1 42 14 43 18 margin of error, limits 44 Research2: 2 =t_crit* SE 45 2.2 LL =point estimate - m 46 25 UL Epoint estimate + m 47 28 range A = UL - LL 48 3.3 4) the spreadsheet should automatically calculate the confidence intervals. Does this confidence interval confirm your 49 4.2 conclusions? Type out the values and answer below 50 5.4 51 5 . B 52 6 53 6.4 54 RA 55 Text 1 ... 2 Co Aa MacBook Air