1. Draw inferences from the data.For this part you will need to use both the male and female data for your variable. Complete the following:
2. Use the sample data to construct a 95% confidence interval for the mean of all males.
3. Use the sample data to construct a 95% confidence interval for the mean of all females.
4. Use the sample data to construct a 95% confidence interval for the difference of means of all males and all females. Explain if there is a difference between the two means.
5. Conduct a hypothesis test with 0.05 significance to test if the mean of all males is different from the mean of all females. Show all steps of hypothesis testing in your report including interpretation of the results.
6. Discuss if the results of the hypothesis test are different from the results of the confidence interval for the difference of two means.
7. Present your results in a Word document.In this document, please include the following:

• Any graphs, charts, or tables from Excel (These should be cut and pasted into this document.)
• Your explanations about your findings.
• Raw data for the project (Include the data for YOUR VARIABLE only. This should be cut and pasted at the end of this document.) DO NOT SUBMIT ANY EXCEL FILES.
• Keep in mind that you will use these results later when you submit your final report at the end of the term. Therefore, the more detailed and accurate your Part 1 explanation is, the more help it will be for you when you start writing your report.

Submission Instructions

• Submit one Word document. (Do not submit any Excel worksheets).

0 X Photos - Screenshot (4).png C Photos - Screenshot (2).png v . . . . . . IM N + B C D E F G H I J K L A WT WAIST PULSE SYS DIAS CHOL BMI LEG ELBOW WRIST ARM J L M N 1 FEMALE AGE HT 6.0 4.6 23.6 SKY B C D E F G 295 17 64.3 114.8 67.2 76 104 61 264 19.6 41.6 A 5.5 26.3 WT WAIST PULSE SYS DIASCHOL BMI LEG ELBOW WRIST ARM MALE AGE HT 6.4 31.9 2739 32 66.4 149.3 82.5 72 99 64 181 23.8 42.8 6.7 169.1 90.6 68 125 78 522 23.8 42.5 7.7 2992 25 62.3 107.8 66.7 88 102 65 267 19.6 39.0 5.7 4.6 26.3 1391 58 70.8 107 54 127 23.2 40.2 7.6 6.2 31.0 76 384 29.1 40.2 6.2 5.0 32.6 2129 22 66.2 144.2 78.1 64 88 126 81 740 24.6 44.4 7.3 5.8 32.7 3745 55 62.3 160.1 93.0 60 114 59.6 127.1 82.6 94 58 98 25.2 36.2 5.5 4.8 29.2 2489 71.7 179.3 96.5 68 49 26.2 42.8 7.5 5.9 33.4 4486 66 62 21.4 43.2 6.0 4.9 26.4 2490 175.8 87.7 72 110 110 66 230 23.5 6.0 30.1 64 40.0 7.1 488 29 63.6 123.1 75.4 68 101 61 126 22.0 38.7 5.7 5.1 27.9 2738 28 67.6 152.6 87.1 5.8 30.5 4878 59.8 111.7 73.6 108 7.1 41 89 27.5 41.0 6.8 5.5 33.0 2988 46 69.2 166.8 92.4 72 107 83 316 24.5 47.3 156.3 81.4 104 71 590 21.5 43.4 6.5 5.2 27.6 4880 63.3 99.4 123 72 531 33. 43.8 7.8 5.8 38.6 2989 41 66.5 135.0 78.8 60 113 103.3 88 126 72 31.4 40.1 7.5 5.6 38.0 1881 41 67.9 218.8 37.3 6.3 5.0 26.5 3346 56 67.2 201.5 7.5 5.5 32.0 4835 32 61.4 110.2 67.7 93 61 56 3 2 5.2 34.4 20 68.3 175.2 89.1 137 85 89 12.3 6.6 3606 6.9 5.5 29.3 31 66.7 188.3 100.7 44 17.7 5.7 4.8 23.7 3607 54 65.6 139.0 82.5 110 578 5.3 31.7 6225 64.8 105.4 72.9 112 62 39.1 5.1 28.4 3608 63.0 156.3 86.7 109 7.1 8.1 6.7 30.7 8680 19 63.1 136.1 85.0 107 48 8 24.0 40.3 6.6 153 265 182.4 85.7 116 62 112 28.9 48.6 7.2 5.6 34.0 3610 73 68.3 186.6 103.3 5.2 3 112 8.0 8681 23 66.7 91.8 5.7 30.6 238.4 126.0 181 102 37.7 3.2 7.0 5.4 35.2 3747 191.1 7.0 12348 67.6 151.3 75.6 119 CNNNOGAVNO 6.0 34.2 108.8 74.5 98 61 18.3 43.4 6.2 5.2 24.7 4832 5.3 27.0 4839 9 68.0 209.4 105.5 113 82 273 6.9 14651 119.0 74.5 100 53 6.3 8.3 6.6 41.1 65.1 40.0 6.8 5.0 35.0 5599 71.0 237.1 108.7 125 6.7 5.7 33.1 45 61.9 161.9 94.0 127 74 41 61.3 176.7 104.0 131 6.0 32.2 174.1 92.8 107 67 38.2 6.8 4.7 33.1 5600 19377 6.9 5.4 39.6 5601 52 76.2 220.6 103.0 121 91.3 132 138 7.5 5.7 31.2 19378 56 63.4 181.2 105.5 80 116 6226 32 66.3 166.1 5.6 25.9 19382 260.7 124.3 75.5 64 97 64 325 23.8 38.2 5.9 5.0 27.0 6.9 80 155 85 600 41.0 8.0 5.6 43.8 7190 20 69.7 137.4 75.2 112 44 255.9 126.5 87.7 121 65 7.0 5.6 33.7 20278 63.4 65.4 164.2 106.7 70.0 76 106 59 237 19 . 38.1 6.1 5.0 23.6 7192 7194 70.0 162.4 77.0 116 64 7.5 5.2 30.3 21626 24 62.6 5.8 32.8 149.9 98.0 76 110 70 173 28 . 38.0 7.0 5.1 34.3 9073 62.9 151.8 85.0 95 5.7 31.0 59 63.5 163.1 104.7 105 309 28. 6.7 5.1 34.4 38 82 26 68.5 144.1 79.6 110 6.8 40 58.6 94.3 67.8 80 118 94 5.4 4.2 23.3 9074 110 690 7.4 6.1 36.2 33106 280 6.4 5.2 35.6 10864 68.3 204.6 103.8 125 31 7.2 6.0 33.6 60.2 159.7 99.3 104 133 83 69.4 193.8 103.0 162.8 91.1 88 113 75 254 7.1 5.3 31.8 12349 15515 69.2 172.9 97.1 124 189 42.7 6.6 5.9 31.9 52 67.6 5.7 32.9 3477 31 63.4 130.0 74.5 60 113 66 123 5.1 27.0 68.0 161.9 86.9 60 131 957 40. 7.3 6.0 30.9 32 64.1 179.9 95.5 107 67 596 39.2 5.0 32.8 16137 7.8 71.9 174.8 88.0 56 109 64 339 44. 6.1 34.0 35272 23 62.7 147.8 79.5 72 95 59 301 26. 39.0 6.3 4.9 31.0 16521 4.7 27.0 16523 66.1 169.8 91.5 84 112 79 416 7.0 5.9 120 7.5 5.9 34.8 61.3 112.9 69.1 72 108 72 223 2 36.6 72 293 40.6 27.0 7.5 5.5 41.2 16768 40 72.4 213.3 102.9 72 127 132 74 702 AND 7.8 6.0 33.6 35505 47 58.2 195.6 105.5 88 114 79 33 73.0 198.0 93.1 84 124.2 78.8 80 104 73 146 21.9 38.5 5.6 4.7 25.5 17006 18392 26 68.0 173.3 98.9 88 116 81 1252 6.7 5.8 31.3 35506 36 63.2 60 125 73 149 26.0 39.9 6.4 5.2 30.9 84 288 42.8 8.2 5.9 37.6 35507 34 60.5 135.0 85.7 124 85 37.5 6.1 4.8 27.9 19017 53 68.7 214.5 107.5 125 7.1 5.3 27.9 35984 37 65.0 141.4 92.8 5.8 5.0 26.5 36 19381 36 70.3 137.1 81.6 112 77 176 40.8 6.6 5.3 26.9 35988 18 61.8 123.9 72.7 92 46 8 8 6.3 4.9 27.8 37 19635 34 63.7 119.5 75.7 125 77 277 20.7 42. 81 649 26.3 44.9 7.4 6.0 36.9 36115 29 68.0 135.5 75.9 119 207 20.5 41.6 6.0 5.3 23.0 38 19991 42 71.1 189.1 95.0 56 120 83 60 118 68 113 26 41.1 7.0 6.1 34.5 130.4 124 64 36502 48 67.0 68.6 93 64 2 21.9 33.8 5.6 4.6 26.4 39 20518 18 65.6 164.7 91.1 5.8 32.1 38089 16 57.0 100.7 68.7 64 106 94.9 44.5 41 40 21135 44 68.3 170.1 64 115 7.3 115 65 172 242 440 71 54 307 41 32230 20 66 3 1510 799 72 7:59 PM X w 4/15/2021 O O Type here to search