Download the Problem Set 10 Data from Canvas and solve the problems on the four tabs of that Excel workbook. Show all steps of a typical hypothesis test and do all mathematical calculations using Excel. Assume a = 0.05 for all problems unless otherwise indicated. 1. (10 pts.) Download the journal article by Lekatz et al. Go to Table 1 and use the data presented there to answer the following questions: a. Consider the effect of mid-gestational energy intake on fetal blood glucose: i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. b. Consider the effect of mid-gestational energy intake on fetal blood non-esterified fatty acids (NEFA): i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. Download the Problem Set 10 Data from Canvas and solve the problems on the four tabs of that Excel workbook. Show all steps of a typical hypothesis test and do all mathematical calculations using Excel. Assume a = 0.05 for all problems unless otherwise indicated. 1. (10 pts.) Download the journal article by Lekatz et al. Go to Table 1 and use the data presented there to answer the following questions: a. Consider the effect of mid-gestational energy intake on fetal blood glucose: i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. b. Consider the effect of mid-gestational energy intake on fetal blood non-esterified fatty acids (NEFA): i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. Table 1. The effect of Se, nutritional level during mid and late gestation, and the Sex mid gestation interaction on the concentration of glucose, NEFA, and blood urea nitrogen (BUN) in ewe and fetal serum samples and on the fetus:ewe concentration ratios at necropsy (d 132 of gestation) Midration Latestation Sex mit to Sex Mix Mid Late 3 7 0.20 0.17 0.77 0.64 0.70 Downloaded from jay Perdido 12.2011 00 Material diet affects fetal treat wilability 0.08 0.00 0:00 be AS HS AS SE CON RES AS HS SE CON RES SE CON RES CON RES S MA Late 24 21 2 20 (Fotos 27 28 (25) 14 (35) 10 (22 127) 16 (20) Glue, mg/l (30) (15) (10) (1) Ew 364 400 1. 493 815 43 LNB 456 wa 162 15.7 16.1 24 52.7 3.17 DRS 0.00 Febwe 2.70 112 100 514 516 0/ 110 503 10 456 0.06 TUT OLI 10 022 NEFAL 01.04 111 113 110 ORD 0.10 0.14 0.25 0.77 Ewe 04 32 970 TH 574 Fe 12 117 5.0 121 101 1126 100 0. 5.50 100 115 we 004 001 015 5. 15 100 0.16 Las 0.03 0.19 361 0.10 0.12 0:08 013 BUN, M 0.02 0.15 010 06 DIR 010 090 00 7 031 x 10 0.31 231 913 79 8 033 03 . 31 0.07 03 100 0.01 115 9.51 9.10 100 0.01 8.21 0.5 00 1.13 110 0.00 0.23 LIN 1.00 0.00 Site within a row with world (PS006) 0.01 0.27 Adequate Se (AS) - 100 / of which Se (5) 70/ kW. These were applied Drimbling til may ( 132 ) Militation tool levels were applied from 0 to 30 of gestation Control (CUN) - of requirements Restricted (LES) - CON. Latewati tratta plied from toy (1132) Con (CON) - 100% freque. Rest ( ICON There weate or relates tonalitet (P 0.07) "Ttalowe Total umber of 0.00 0.12 0.91 7.72 OM OM 0.47 0.70 OR Download the Problem Set 10 Data from Canvas and solve the problems on the four tabs of that Excel workbook. Show all steps of a typical hypothesis test and do all mathematical calculations using Excel. Assume a = 0.05 for all problems unless otherwise indicated. 1. (10 pts.) Download the journal article by Lekatz et al. Go to Table 1 and use the data presented there to answer the following questions: a. Consider the effect of mid-gestational energy intake on fetal blood glucose: i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. b. Consider the effect of mid-gestational energy intake on fetal blood non-esterified fatty acids (NEFA): i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. Download the Problem Set 10 Data from Canvas and solve the problems on the four tabs of that Excel workbook. Show all steps of a typical hypothesis test and do all mathematical calculations using Excel. Assume a = 0.05 for all problems unless otherwise indicated. 1. (10 pts.) Download the journal article by Lekatz et al. Go to Table 1 and use the data presented there to answer the following questions: a. Consider the effect of mid-gestational energy intake on fetal blood glucose: i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. b. Consider the effect of mid-gestational energy intake on fetal blood non-esterified fatty acids (NEFA): i. Write null and alternate hypotheses for this response variable. ii. What is P for this comparison? iii. What is the decision? iv. Write a conclusion for this comparison. Table 1. The effect of Se, nutritional level during mid and late gestation, and the Sex mid gestation interaction on the concentration of glucose, NEFA, and blood urea nitrogen (BUN) in ewe and fetal serum samples and on the fetus:ewe concentration ratios at necropsy (d 132 of gestation) Midration Latestation Sex mit to Sex Mix Mid Late 3 7 0.20 0.17 0.77 0.64 0.70 Downloaded from jay Perdido 12.2011 00 Material diet affects fetal treat wilability 0.08 0.00 0:00 be AS HS AS SE CON RES AS HS SE CON RES SE CON RES CON RES S MA Late 24 21 2 20 (Fotos 27 28 (25) 14 (35) 10 (22 127) 16 (20) Glue, mg/l (30) (15) (10) (1) Ew 364 400 1. 493 815 43 LNB 456 wa 162 15.7 16.1 24 52.7 3.17 DRS 0.00 Febwe 2.70 112 100 514 516 0/ 110 503 10 456 0.06 TUT OLI 10 022 NEFAL 01.04 111 113 110 ORD 0.10 0.14 0.25 0.77 Ewe 04 32 970 TH 574 Fe 12 117 5.0 121 101 1126 100 0. 5.50 100 115 we 004 001 015 5. 15 100 0.16 Las 0.03 0.19 361 0.10 0.12 0:08 013 BUN, M 0.02 0.15 010 06 DIR 010 090 00 7 031 x 10 0.31 231 913 79 8 033 03 . 31 0.07 03 100 0.01 115 9.51 9.10 100 0.01 8.21 0.5 00 1.13 110 0.00 0.23 LIN 1.00 0.00 Site within a row with world (PS006) 0.01 0.27 Adequate Se (AS) - 100 / of which Se (5) 70/ kW. These were applied Drimbling til may ( 132 ) Militation tool levels were applied from 0 to 30 of gestation Control (CUN) - of requirements Restricted (LES) - CON. Latewati tratta plied from toy (1132) Con (CON) - 100% freque. Rest ( ICON There weate or relates tonalitet (P 0.07) "Ttalowe Total umber of 0.00 0.12 0.91 7.72 OM OM 0.47 0.70 OR