Need help with this, it will be nice if somebody ciukd add the excel worksheets for problems 6 qnd 7. thank you

Group 6 Group 8 Answer the following questions using Excel (2 pt) Beyond it being a conservative measure and the file health.xlsx of trend or correlation what does the R a) (2 pt) Are the ages of the men and women represent, in your own words? significantly different? b) (2 pt) Do the men have significantly higher For Groups 9 and 10 use the regression cholesterol than the women? output contained within foot_height.pdf. c) (2 pt) Do the men have significantly higher cholesterol than the women, if these are pairs of spouses? Group 9 a) (2 pt) What is, and how strong is the trend or correlation measured liberally? Group 7 b) (1 pt) is the trend or positive or negative? Answer the following questions using Excel How do you know? and the file price_of_gas.xlsx a) (2pt) What is the liberal estimate of the correlation of the price paid (y) vs. the Group 10 number of gallons bought (x)? a) (2 pt) What is the the likely slope, and b) (pt) How strong is that correlation? what is your 95% CI for it? b) (2 pt) What is the likely intercept, and c) (2 pt) What is the line of best fit for price what is your 95% CI for it? (y) vs. gallons (x)? c) (2 pt) How tall would you expect a person d) (2 pt) What does the slope of the line to be if they had a foot size of 25 cm? represent? C ZOOM + MALE AGE WT PULSE 53 DIAS ELBOW LEG 42.5 402 WRIST 64 BM 238 232 25 262 23.5 58 58 22 32 11 28 46 41 56 20 54 72 TO 13 75 7+ 7.1 85 75 50 428 40.0 473 43.4 40.1 745 21.5 314 264 52 50 55 55 53 227 270 1 2 3 4 5 6 7 a 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 69 7.1 21 201 81 68 60 33 41 72 85 71 65 87 77 81 12 76 80 75 85 72 80 80 78 od m 72 56 54 60 54 34 76 56 ya 52 25 360 42 367 48.4 41.0 252 23.3 TO 52 57 60 39 HT 708 562 717 687 67 6 692 05 672 683 65.6 63.0 58.3 73.1 070 58.0 710 613 782 553 60 65.4 20.0 02.0 68.5 683 694 692 680 719 06.1 724 730 680 68.7 703 63.7 701 656 683 1442 179.3 1758 1526 166 1350 2015 1752 1390 1963 1856 1011 1513 2094 237.1 1767 220,8 156,1 4374 1642 1624 1518 144.1 2046 1836 1720 161 1748 1000 2133 1980 1735 2145 67 79 WAIST 906 781 365 077 871 $24 788 1033 89.1 825 807 1033 013 758 1055 1087 1040 1000 913 75.2 87.7 770 850 79.6 1038 1030 97.1 369 380 91.5 102.9 93.1 989 1075 816 75.7 950 91.1 549 999 17 41 52 32 20 20 29 10 20 33 55 53 SYS 125 107 125 110 110 107 113 126 137 110 TOD 153 112 119 113 125 131 121 192 112 121 116 $ 110 110 125 124 131 100 112 127 132 116 125 112 125 120 118 115 195 33.1 332 26.7 26 CHOL 522 127 740 49 230 316 500 466 121 578 TO 265 250 285 273 272 972 75 138 130 639 613 782 303 000 31 189 957 399 416 120 702 1252 288 175 279 540 113 8 172 57 60 57 55 5 52 60 72 56 75 T4 60 48 60 55 54 50 70 60 82 79 60 27.1 234 270 218 300 23 255 246 452 402 453 200 44,8 40.0 4. 380 410 460 414 421 40.5 442 410 472 43 29 28 408 74 72 3.0 238 30 EN TO 20 27 40 33 26 33 72 84 79 72 74 29 20 31 32 13 34 35 30 37 38 29 40 56 274 287 212 204 32.1 TOS 207 23 52 19 1371 34 77 77 30 38883 56 14 42 12 4 20 14 1195 1801 164.7 170.1 1610 54 256 75 65 8. 50 Notes: Age in years HT: height in inches WT: weight in pounds WAIST: waist circumference in cm PULSE pulse rate in boats per minute SYS: systolic blood pressure in mmHg DIAS: diastolic blood pressure in mmHg CHOL cholesterol in my BMI body mass index LEG upper leg length inom ELBOW: elbow breadth inom WRIST: wrist breadth inom ARM:am circumference in um Credit: U.S. Department of Health and Human Services National Center for Health St Third National Health and Nutrition Examination Survey MALE AGE SYS DIAS CHOE BLE ELBOW WRIST 17 HT 643 654 LEG 418 WT 1148 13 TOT 1601 WAIST 672 825 567 PULSE 76 72 104 06 57 3 18 267 185 64 65 70 50 00 48 50 523 596 638 598 60 72 25 55 27 22 28 12 41 62 55 390 402 352 432 307 410 107 114 94 101 109 104 123 99 09 49 81 220 64 68 SLZ 57 63 75 55 52 $20 20 531 130 175 T2 826 75.4 736 314 994 677 1007 729 850 857 1200 579 514 66.7 ES 335 2015 373 NO T6 68 57 9 ET 72 3:1 10.3 456 5 112 182 1221 111,7 1563 215 1102 1 05:44 138.1 1024 2384 1088 1190 1619 1741 1812 1243 2569 1067 1499 1601 11 12 13 14 15 16 17 18 19 20 21 205 31 19 13 23 40 23 27 45 41 55 22 57 171 240 219 377 163 70 53.1 66.7 66.8 57 581 319 643 594 TS 1 33 74 67 434 415 53 LAT 925 745 940 92.0 105.5 75.5 1255 70,0 IZ 5.0 52 48 5. 56 5.4 52 53 59 47 54 5.0 5.0 50 51 5.1 42 52 BIE 31 12 88 72 64 B0 54 80 78 76 18 59 LOR 112 SGT 156 981 90 100 127 107 116 97 155 100 110 105 118 133 113 513 107 54 395 SP 67 12 59 30 60 009 ZEZ 23 24 102 382 382 302 410 381 380 MO 321 31.1 37 59 70 090 634 528 606 635 586 80 676 BA 59 57 20 27 CH 09 104 B 40 45 52 31 32 23 82 83 75 215 19.3 310 21 220 300 ret 7.1 CS 29 041 402 92 627 $% CLO 104.7 673 093 91.1 745 955 79.5 693 1055 788 857 820 727 759 250 254 122 So 301 223 23 146 67 55 72 79 73 213 1507 1628 5300 170 1473 112.9 15656 1242 1350 1414 1233 1355 1304 100.7 59 38 270 582 31 32 33 34 35 35 37 30 29 31 5.0 49 4T 55 47 52 08 47 36 34 27 21 200 235 72 100 114 104 125 124 92 115 93 100 60.5 650 618 60 670 SO ET 393 35 397 ? 85 48 31 OCH S8 CO8689 49 48 10 124 54 211 2017 2 687 219 45 The following Data represents each time I filled my gas tank over a three month period during the summer of 2019 is the number of Gallons I bought during a -up the price paid for that F-up Number Gallons (gal) Dollar (USD) 114 28.73 2 8.9 25.19 3 1.5 4.17 4 49 12.45 5 6.5 17 81 6 6.8 18.97 7 7.4 19.24 8 82 2148 9 11.1 29.86 10 8 21.76 11 7.5 20.25 12 34 9.60 13 1978 14 53 1463 15 71 18.82 16 72 20.66 17 114 18 42 11.55 19 75 19.80 20 199 25.43 21 5.1 13 82 22 46 1251 23 23 9.31 24 8.2 23.29 25 7.1 19.38 26 98 25.97 27 46 12.93 28 8.1 21.79 29 79 22.04 30 43 11.95 3135 A regression of Height (y) vs. Foot Length 6). Regression Regression Model Linear UNEST row output 4.29 0.45 0.71 92.60 2806.87 64.13 11.49 5.51 38.00 1151.89 Regression Statistics R"2 Standard Error Count of X variables Observations Adjusted R 2 0.71 5.51 1.00 40.00 0.70 Analysis of Variance (ANOVA) FOOT LENGTH HEIGHT cm om 27.8 1803 25.7 1753 26.7 1848 25.9 177.8 26.4 1823 29.2 185.4 26.8 180.3 28.1 1753 254 177.8 279 185.4 27.5 190.5 28.8 1950 26.7 1753 26.7 180.3 25.1 1727 28.7 182.9 29.2 189.2 27.9 185.4 28.6 193.7 232 165.1 24.3 166.4 26.0 177.8 238 167.6 25.1 168.3 25.4 1657 219 165.1 28 2 165.1 23.8 165.1 222 1524 24.6 162.6 24.5 179.1 23.7 1759 256 166.4 241 167.6 23.8 1826 223 167.6 23.5 165.1 25.1 172.7 157.5 23 B 167.0 df 1.00 F Significance F 92.60 0.00 Regression Residual Total MS 2806.87 30 31 SS 2806,87 1151.89 3958.76 38.00 39.00 Confidence level 0.95 Intercept X1 Coefficients Standard Error 1-Statistic Peale 64.13 11.49 5.58 0.00 4.29 0.45 9.62 0.00 Lower 95% Upper 95% 40.88 87.38 3:39 5.19 24.1 Group 6 Group 8 Answer the following questions using Excel (2 pt) Beyond it being a conservative measure and the file health.xlsx of trend or correlation what does the R a) (2 pt) Are the ages of the men and women represent, in your own words? significantly different? b) (2 pt) Do the men have significantly higher For Groups 9 and 10 use the regression cholesterol than the women? output contained within foot_height.pdf. c) (2 pt) Do the men have significantly higher cholesterol than the women, if these are pairs of spouses? Group 9 a) (2 pt) What is, and how strong is the trend or correlation measured liberally? Group 7 b) (1 pt) is the trend or positive or negative? Answer the following questions using Excel How do you know? and the file price_of_gas.xlsx a) (2pt) What is the liberal estimate of the correlation of the price paid (y) vs. the Group 10 number of gallons bought (x)? a) (2 pt) What is the the likely slope, and b) (pt) How strong is that correlation? what is your 95% CI for it? b) (2 pt) What is the likely intercept, and c) (2 pt) What is the line of best fit for price what is your 95% CI for it? (y) vs. gallons (x)? c) (2 pt) How tall would you expect a person d) (2 pt) What does the slope of the line to be if they had a foot size of 25 cm? represent? C ZOOM + MALE AGE WT PULSE 53 DIAS ELBOW LEG 42.5 402 WRIST 64 BM 238 232 25 262 23.5 58 58 22 32 11 28 46 41 56 20 54 72 TO 13 75 7+ 7.1 85 75 50 428 40.0 473 43.4 40.1 745 21.5 314 264 52 50 55 55 53 227 270 1 2 3 4 5 6 7 a 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 69 7.1 21 201 81 68 60 33 41 72 85 71 65 87 77 81 12 76 80 75 85 72 80 80 78 od m 72 56 54 60 54 34 76 56 ya 52 25 360 42 367 48.4 41.0 252 23.3 TO 52 57 60 39 HT 708 562 717 687 67 6 692 05 672 683 65.6 63.0 58.3 73.1 070 58.0 710 613 782 553 60 65.4 20.0 02.0 68.5 683 694 692 680 719 06.1 724 730 680 68.7 703 63.7 701 656 683 1442 179.3 1758 1526 166 1350 2015 1752 1390 1963 1856 1011 1513 2094 237.1 1767 220,8 156,1 4374 1642 1624 1518 144.1 2046 1836 1720 161 1748 1000 2133 1980 1735 2145 67 79 WAIST 906 781 365 077 871 $24 788 1033 89.1 825 807 1033 013 758 1055 1087 1040 1000 913 75.2 87.7 770 850 79.6 1038 1030 97.1 369 380 91.5 102.9 93.1 989 1075 816 75.7 950 91.1 549 999 17 41 52 32 20 20 29 10 20 33 55 53 SYS 125 107 125 110 110 107 113 126 137 110 TOD 153 112 119 113 125 131 121 192 112 121 116 $ 110 110 125 124 131 100 112 127 132 116 125 112 125 120 118 115 195 33.1 332 26.7 26 CHOL 522 127 740 49 230 316 500 466 121 578 TO 265 250 285 273 272 972 75 138 130 639 613 782 303 000 31 189 957 399 416 120 702 1252 288 175 279 540 113 8 172 57 60 57 55 5 52 60 72 56 75 T4 60 48 60 55 54 50 70 60 82 79 60 27.1 234 270 218 300 23 255 246 452 402 453 200 44,8 40.0 4. 380 410 460 414 421 40.5 442 410 472 43 29 28 408 74 72 3.0 238 30 EN TO 20 27 40 33 26 33 72 84 79 72 74 29 20 31 32 13 34 35 30 37 38 29 40 56 274 287 212 204 32.1 TOS 207 23 52 19 1371 34 77 77 30 38883 56 14 42 12 4 20 14 1195 1801 164.7 170.1 1610 54 256 75 65 8. 50 Notes: Age in years HT: height in inches WT: weight in pounds WAIST: waist circumference in cm PULSE pulse rate in boats per minute SYS: systolic blood pressure in mmHg DIAS: diastolic blood pressure in mmHg CHOL cholesterol in my BMI body mass index LEG upper leg length inom ELBOW: elbow breadth inom WRIST: wrist breadth inom ARM:am circumference in um Credit: U.S. Department of Health and Human Services National Center for Health St Third National Health and Nutrition Examination Survey MALE AGE SYS DIAS CHOE BLE ELBOW WRIST 17 HT 643 654 LEG 418 WT 1148 13 TOT 1601 WAIST 672 825 567 PULSE 76 72 104 06 57 3 18 267 185 64 65 70 50 00 48 50 523 596 638 598 60 72 25 55 27 22 28 12 41 62 55 390 402 352 432 307 410 107 114 94 101 109 104 123 99 09 49 81 220 64 68 SLZ 57 63 75 55 52 $20 20 531 130 175 T2 826 75.4 736 314 994 677 1007 729 850 857 1200 579 514 66.7 ES 335 2015 373 NO T6 68 57 9 ET 72 3:1 10.3 456 5 112 182 1221 111,7 1563 215 1102 1 05:44 138.1 1024 2384 1088 1190 1619 1741 1812 1243 2569 1067 1499 1601 11 12 13 14 15 16 17 18 19 20 21 205 31 19 13 23 40 23 27 45 41 55 22 57 171 240 219 377 163 70 53.1 66.7 66.8 57 581 319 643 594 TS 1 33 74 67 434 415 53 LAT 925 745 940 92.0 105.5 75.5 1255 70,0 IZ 5.0 52 48 5. 56 5.4 52 53 59 47 54 5.0 5.0 50 51 5.1 42 52 BIE 31 12 88 72 64 B0 54 80 78 76 18 59 LOR 112 SGT 156 981 90 100 127 107 116 97 155 100 110 105 118 133 113 513 107 54 395 SP 67 12 59 30 60 009 ZEZ 23 24 102 382 382 302 410 381 380 MO 321 31.1 37 59 70 090 634 528 606 635 586 80 676 BA 59 57 20 27 CH 09 104 B 40 45 52 31 32 23 82 83 75 215 19.3 310 21 220 300 ret 7.1 CS 29 041 402 92 627 $% CLO 104.7 673 093 91.1 745 955 79.5 693 1055 788 857 820 727 759 250 254 122 So 301 223 23 146 67 55 72 79 73 213 1507 1628 5300 170 1473 112.9 15656 1242 1350 1414 1233 1355 1304 100.7 59 38 270 582 31 32 33 34 35 35 37 30 29 31 5.0 49 4T 55 47 52 08 47 36 34 27 21 200 235 72 100 114 104 125 124 92 115 93 100 60.5 650 618 60 670 SO ET 393 35 397 ? 85 48 31 OCH S8 CO8689 49 48 10 124 54 211 2017 2 687 219 45 The following Data represents each time I filled my gas tank over a three month period during the summer of 2019 is the number of Gallons I bought during a -up the price paid for that F-up Number Gallons (gal) Dollar (USD) 114 28.73 2 8.9 25.19 3 1.5 4.17 4 49 12.45 5 6.5 17 81 6 6.8 18.97 7 7.4 19.24 8 82 2148 9 11.1 29.86 10 8 21.76 11 7.5 20.25 12 34 9.60 13 1978 14 53 1463 15 71 18.82 16 72 20.66 17 114 18 42 11.55 19 75 19.80 20 199 25.43 21 5.1 13 82 22 46 1251 23 23 9.31 24 8.2 23.29 25 7.1 19.38 26 98 25.97 27 46 12.93 28 8.1 21.79 29 79 22.04 30 43 11.95 3135 A regression of Height (y) vs. Foot Length 6). Regression Regression Model Linear UNEST row output 4.29 0.45 0.71 92.60 2806.87 64.13 11.49 5.51 38.00 1151.89 Regression Statistics R"2 Standard Error Count of X variables Observations Adjusted R 2 0.71 5.51 1.00 40.00 0.70 Analysis of Variance (ANOVA) FOOT LENGTH HEIGHT cm om 27.8 1803 25.7 1753 26.7 1848 25.9 177.8 26.4 1823 29.2 185.4 26.8 180.3 28.1 1753 254 177.8 279 185.4 27.5 190.5 28.8 1950 26.7 1753 26.7 180.3 25.1 1727 28.7 182.9 29.2 189.2 27.9 185.4 28.6 193.7 232 165.1 24.3 166.4 26.0 177.8 238 167.6 25.1 168.3 25.4 1657 219 165.1 28 2 165.1 23.8 165.1 222 1524 24.6 162.6 24.5 179.1 23.7 1759 256 166.4 241 167.6 23.8 1826 223 167.6 23.5 165.1 25.1 172.7 157.5 23 B 167.0 df 1.00 F Significance F 92.60 0.00 Regression Residual Total MS 2806.87 30 31 SS 2806,87 1151.89 3958.76 38.00 39.00 Confidence level 0.95 Intercept X1 Coefficients Standard Error 1-Statistic Peale 64.13 11.49 5.58 0.00 4.29 0.45 9.62 0.00 Lower 95% Upper 95% 40.88 87.38 3:39 5.19 24.1