OOOOO AT&T LTE 10211 AM '1 94% ' % < Message Midterm Exam Part 2.pdf LT] Midterm Exam Part2 (50 points) Directions: Create the required tables and graphs in Excel, segregating each question's tables and graphs onto a separate worksheet. Make sure you label clearly each table and graph. Provide the required written answers for each question in text boxes on the question's worksheet. Upload the Excel workbook in the Midterm Exam Part 2 dropbox found in the Midterm Folder on Blackboard by 1 1:59 PM on the due date found in the syllabus. The dataset, fram-sampxls (available in the Midterm folder), is a subset of the data from the Framingham Heart Study, a longitudinal study to assess risk factors for cardiovascular disease. It includes n=481 participants who completed one of the regularly scheduled examinations from 1956-1968. The following table shows variable names, as they appear in the dataset, along with brief descriptions and coding details for each variable. Variable Name Description Codin RANDOM 10 Random, unique number for each participant 2448-9999312 Age at exam, in years 32-70 BodyrmassVindeLkgjmeterQ lS.54-S6.8 ClGS PER DAY Number of cigarettes smoked per day 0-70 HYPERTENSION Hypertension over 24 year follow-up 0=no, 1=yes STROKE Stroke over 24 year follow-up 0=no, 1=yes CVD Cardiovascular disease over 24 year follow-up 0=no, 1=yes DEATH Death from any cause over 24 year follow-up . For each interval/ratio variable (excluding Random ID; 18 points total): a. Create a table that gives the mean, median, mode, standard deviation, minimum and maximum value for each variable. (9 points) . Create a histogram for each variable. (6 points) . Comment on the shape of the histogram and determine if the mean, median or the mode is the most appropriate measure of central location. (3 points) . For each categorical variable (16 points total): a. Construct a frequency table that gives the counts and relative percentages. (8 points) b. Construct a bar graph that summarizes the data. (8 points) . Create a contingency table (also known as a 2 x 2 table) of the variables hypertension vs. stroke. (5 points for the table; 16 points total) a. Give an estimate of the probability of being diagnosed with hypertension. (2 point) b. Give an estimate of the probability of suffering a stroke. (2 point) 0. Estimate the probability of having a stroke given someone has been diagnosed with hypertension. (2 point) . Estimate the probability of having a stroke given someone has not been diagnosed hypertensive. (2 point) . Calculate the relative risk of stroke for those with hypertension versus those without hypertension and interpret its meaning. (3 points)RANDOM ID 2448 20375 33555 55965 68397 83398 84815 95148 112469 181030 225499 236242 246478 272194 290382 311966 364767 369222 377045 381676 411906 462539 475695 479517 571748 585180 595859 614449 632247 636868 647094 654086 672080 695333 704329 706615 709180 715172 727350 760664 779250 788253 793340 802166 824917 843071 854395 865584 892767 898392 912658 939781 968594 969969 972314 1014724 1039159 1092920 1098348 1140713 1144604 1188396 1205141 1214102 1237635 1262959 1265767 1289095 1291690 1315941 1360682 1362131 1369535 1386857 1434038 1459119 1485688 1498357 1503585 1518521 1530794 1583431 1600765 1607784 1636092 1641185 1723785 1736166 1749853 1752844 1761292 1762238 1783679 1835810 1842459 AGE BMI 39 46 46 60 40 52 42 52 62 44 47 42 66 64 39 59 59 54 61 66 41 67 55 56 56 59 55 61 45 55 57 52 35 54 34 41 38 55 36 44 55 54 42 53 38 46 40 67 54 51 66 46 42 38 63 55 49 47 56 56 64 41 38 43 40 38 55 39 59 40 41 55 40 50 39 41 38 58 38 48 55 60 45 44 57 62 53 45 54 67 40 46 44 60 37 CIGS PER DAY 26.97 26.31 23.38 26.59 23.62 40.11 28.93 25.09 28.27 24.04 27.98 26.93 40.52 24.37 26.12 24.07 25.97 28.92 23.37 25.32 30.77 25.95 28.96 20.12 29.44 23.29 27.15 21.9 24.15 27.78 24.22 29.29 22 22.16 21.5 28.39 29.77 26.2 32.63 17.44 25.2 28.47 23.85 28.78 22.73 29 24.06 15.54 26.64 24.76 31.42 23.51 20.62 24.03 31.8 20.53 25.04 26.2 21.91 22.67 28.66 22.29 21.8 22.36 16.69 30.24 26.27 24.12 28.83 24.01 18.86 28.35 23.65 23.3 28.73 23.47 23.88 30.08 31.39 31.67 20.56 24.48 31.44 31.68 24.75 33.38 27.98 24.9 20.5 19.32 19.7 33.47 25.01 28.46 HYPERTENSION 0 15 20 0 0 0 1 0 0 0 20 0 0 0 0 30 1 0 0 0 20 0 0 30 0 0 1 0 9 0 1 0 0 20 10 0 0 0 20 20 0 0 20 0 10 30 0 0 0 20 0 20 15 15 40 0 0 5 20 20 0 4 0 0 0 0 0 30 0 30 30 15 0 3 3 5 15 20 15 0 0 0 0 40 0 20 9 0 0 0 20 20 0 5 15 STROKE 0 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 1 1 1 1 1 0 0 0 0 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 0 1 0 0 1 0 0 1 1 0 0 1 1 1 0 1 1 1 1 1 0 0 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 CVD 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 DEATH 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 1 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 1 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 1 0 0 1 0 1 1 0 1 1 0 0 1 1 1 0 1 1 1 1 0 0 0 1 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 1 1 1 0 0 1 0 0 0 1 0 1871406 1881811 1914904 1936948 2020550 2051735 2067160 2079307 2082771 2087324 2106090 2148428 2184456 2235925 2248032 2291433 2329085 2341406 2353950 2376358 2380239 2400282 2407647 2433317 2448708 2463212 2474378 2496396 2509916 2622022 2640525 2644027 2715633 2839250 2878281 2880105 2887939 2889180 2909148 2915311 2925279 2945687 2963619 2969220 2969671 2976528 2976595 2985434 2994596 3059837 3076234 3111937 3128602 3144352 3158323 3161095 3218268 3226447 3231510 3237403 3267132 3279268 3288545 3310958 3321257 3325285 3325316 3340146 3344655 3346257 3358380 3391369 3391411 3397285 3400000 3404702 3449311 3488605 3521148 3533441 3533652 3533973 3551565 3558408 3562544 3587516 3640954 3650041 3652590 3655799 3743532 3748008 3798136 3821372 3845278 3914417 49 43 39 60 59 54 64 40 47 46 58 48 57 64 47 43 35 46 45 55 56 42 53 41 64 58 38 55 47 63 45 50 49 53 42 44 40 57 47 45 41 58 45 46 49 46 61 56 59 50 50 60 36 46 54 64 43 67 51 44 43 36 57 46 52 51 39 55 54 41 60 40 54 47 50 41 40 38 58 49 41 57 48 44 54 57 67 55 62 52 50 59 52 39 46 34 23.38 26.11 24.25 19.42 23.28 25.84 24.35 32.73 24.49 21.89 23.72 27.75 28.3 20.67 28.23 22.36 24.43 32.4 30.63 23.45 24.25 32.52 28.04 34.99 27.6 23.08 33.32 22.69 24.58 27.91 24.53 28.5 25.97 19.83 28.68 31.74 27.04 30.93 25.77 31.35 27.02 31.34 25.74 28.87 26.56 23.01 28.89 24.38 29.69 26.54 25.9 25.13 22.36 28.92 30.78 34.53 24.01 28.56 29.43 24.16 19.84 26.78 26.59 22.7 25.89 26.83 22.32 23.43 20.55 26.26 24.57 19.78 26.77 32.07 30.46 30.69 22.52 31.22 26.33 23.19 38.75 22 17.11 28.32 20.55 24.72 26.71 26.08 24.83 22.81 23.24 33.45 27.61 22.33 25.46 22.15 30 0 40 9 0 0 40 20 25 20 5 9 20 0 0 0 0 0 20 0 9 0 20 0 0 0 0 10 30 10 20 30 0 0 0 0 0 0 3 0 0 0 0 20 0 0 0 0 20 0 15 0 0 0 0 30 0 20 10 23 20 0 0 20 0 20 0 0 0 30 0 0 30 20 60 0 15 20 20 20 43 20 0 20 0 60 0 0 0 20 0 0 2 15 0 20 1 0 0 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 1 0 0 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 0 1 1 1 1 0 1 0 1 1 1 0 0 1 0 1 1 0 1 0 1 1 0 1 0 0 0 0 1 1 1 1 1 1 0 1 1 1 0 1 0 1 1 1 1 0 1 1 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 1 1 0 0 0 0 0 1 0 0 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 1 0 1 1 1 0 1 0 0 1 0 0 0 0 1 0 0 1 1 1 1 0 0 1 1 0 0 0 0 0 0 1 0 1 0 1 1 0 0 1 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 1 1 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 1 0 1 0 1 1 1 1 0 0 1 0 0 0 0 3929019 3931135 3951891 3965320 3986720 3995696 4022564 4043077 4050980 4066905 4071734 4096879 4111412 4111556 4162270 4224953 4233250 4252539 4296725 4307224 4327409 4381358 4391347 4407886 4463058 4493862 4511124 4545373 4545858 4546560 4552529 4576029 4625985 4650205 4669258 4686506 4689213 4695319 4696586 4702754 4716790 4726021 4755458 4757585 4765475 4836599 4899980 4903592 4964840 4969600 4978689 4979657 5027296 5032031 5041608 5059363 5061930 5078904 5097047 5112172 5128590 5128649 5131905 5149091 5166838 5198221 5232877 5245299 5254893 5274565 5275601 5349895 5415774 5416719 5484818 5491585 5494267 5504990 5519943 5522225 5522678 5602336 5623841 5636409 5681674 5703699 5704083 5768992 5777606 5787711 5807636 5813001 5818501 5819641 5831274 5833762 64 49 47 57 38 65 46 55 52 53 37 48 39 51 52 55 43 66 61 57 39 62 56 54 54 37 42 59 44 64 65 45 49 64 59 43 50 46 51 50 45 69 39 64 48 42 42 62 57 56 56 56 56 41 41 37 36 54 54 48 43 61 63 52 42 53 38 38 59 39 46 45 64 47 63 61 36 44 39 49 58 39 63 46 46 56 51 49 41 51 63 48 44 37 59 39 26.01 21.83 24.71 24.19 21.79 34.69 19.27 24.99 30.18 36.57 22.9 26.4 24.44 24.81 32.57 30.23 27.18 34.36 25.05 29.08 38.06 26.73 33.71 20.41 26.28 26.48 27.78 25.58 30.85 27.01 25.31 26.09 23.17 23.09 19.83 27.99 23.81 19.74 26.37 35.85 29.17 26.64 31.38 28.46 19.42 23.95 24.41 27.43 20.34 25.14 20.12 32.07 26.45 22.91 22.25 22.71 28.09 28.56 24.77 25.08 30.28 25.11 38.42 28.88 24.2 29.82 23.97 24.18 20.12 23.9 33.79 28.06 35.62 28.02 27.8 25.08 24.39 25.25 24.26 33.14 22.09 25.57 24.38 29.28 22.19 26.64 24.1 21.86 24.88 27.78 24.91 24.24 23.07 23.55 25.45 22.91 0 0 3 0 9 0 0 9 0 0 0 17 0 0 0 0 20 0 0 0 0 3 20 30 0 20 20 0 20 0 10 35 0 0 30 0 0 5 20 30 3 0 0 10 20 20 9 0 20 0 17 0 0 15 0 20 30 0 20 0 0 0 0 30 20 0 0 20 20 30 0 0 0 0 9 15 0 10 0 0 0 0 0 20 0 30 15 9 0 0 20 20 0 9 0 9 1 0 1 1 0 0 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 1 1 0 0 1 1 0 1 1 0 0 1 1 0 1 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 1 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 1 0 0 0 1 1 0 0 1 0 1 1 0 0 0 1 0 0 0 1 0 1 1 1 0 1 0 1 0 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 1 0 0 0 0 1 0 1 0 0 0 1 0 1 1 0 1 1 0 0 0 1 0 1 0 1 1 1 0 0 0 0 1 0 0 0 1 0 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0 1 0 5854201 5865112 5889964 5966653 6029266 6040238 6048685 6060462 6064836 6066624 6068680 6077861 6086981 6093645 6096025 6130310 6183041 6198925 6215341 6229797 6242769 6255031 6303496 6312149 6318099 6342922 6378354 6386877 6494598 6518202 6544121 6577417 6597782 6628441 6724793 6740002 6770331 6788431 6797486 6814274 6825633 6834635 6882272 6893454 6949688 6961522 6995910 7010106 7010141 7018777 7030028 7096757 7135704 7143708 7144143 7205418 7215259 7223947 7287877 7291047 7311654 7315561 7317237 7331862 7338033 7407080 7411567 7416933 7417603 7463712 7473824 7495747 7507638 7519156 7540676 7544356 7549687 7579949 7590563 7593614 7594764 7609801 7671087 7682014 7703526 7717169 7796923 7801730 7810051 7811148 7827701 7834949 7857277 7911107 7935934 7938500 64 46 37 57 39 67 48 40 53 40 63 45 38 60 52 55 58 64 44 44 41 53 51 58 51 39 58 43 45 64 41 42 53 47 54 49 46 56 40 41 43 46 63 39 39 61 59 65 44 52 63 44 49 53 66 50 48 63 40 54 38 45 53 39 62 58 51 60 44 38 63 43 46 37 46 46 39 55 58 46 45 43 44 44 66 56 47 58 65 48 62 61 61 54 60 38 21.68 28.46 25.87 24.76 25.31 30.12 27.86 23.28 27.04 28 27.06 24.35 21.43 21.07 37.02 26.21 24.51 26.24 31.62 30.32 29.01 32.6 26.91 29.66 24.22 23.29 23.55 31.54 22.33 25.77 31.71 21.99 24.15 29.98 25.36 26.87 24.67 30.77 23.35 23.96 17.81 28.65 40.81 20.74 24.74 31.27 25.11 24.72 25.71 30.38 33.66 23.23 24.26 29.4 23.22 18.26 26.44 28.85 29.62 33.11 28.94 25.74 27.88 23.9 33.7 25.02 24.44 23.65 24.37 20.71 27.13 23.02 25.72 27.98 27.78 26.25 29.06 27.86 25.08 32.89 24.56 26.66 25.48 24.94 23.36 30.33 34.56 21.68 19.76 24.95 21.84 25.51 38.31 24.1 25.69 0 2 20 0 20 0 9 0 0 0 0 0 0 20 0 5 0 10 30 0 0 0 0 15 15 0 20 15 20 0 0 0 43 20 0 25 40 0 20 20 20 20 0 0 5 0 0 0 20 0 9 40 20 20 0 9 2 6 0 0 30 0 30 0 0 0 9 0 8 10 0 0 0 0 0 40 0 0 3 6 0 20 20 0 20 0 0 0 30 0 20 0 0 0 20 0 1 1 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 0 1 1 1 0 1 0 1 1 1 0 1 0 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 1 1 0 0 1 0 1 0 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 1 0 1 0 0 1 0 0 0 1 1 0 0 0 1 0 0 1 0 1 1 0 1 1 1 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 1 0 1 1 0 1 0 1 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 1 0 0 1 0 0 0 1 0 0 0 1 0 1 1 0 0 0 0 1 0 1 0 1 1 0 1 0 0 0 1 1 0 1 1 0 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0 0 0 1 0 1 1 0 0 0 0 7948688 7987102 7996314 8009750 8048375 8056692 8091271 8098134 8124362 8131420 8134479 8193299 8205021 8267774 8306394 8320607 8330292 8333844 8345828 8346235 8359476 8435842 8454887 8465853 8466833 8500988 8524550 8534123 8535739 8542285 8573433 8622299 8661248 8692819 8726077 8762895 8765730 8785667 8803531 8814317 8825382 8827129 8829302 8854729 8872844 8919881 8941988 8957558 8969014 8997701 9022777 9025480 9036299 9081543 9092400 9096506 9101109 9108262 9115104 9157400 9166483 9168891 9177636 9211350 9211709 9218030 9221540 9293242 9345613 9362621 9395536 9427065 9433633 9435851 9437018 9466032 9504535 9541432 9570225 9611724 9643995 9657072 9661515 9686180 9694232 9749700 9767171 9800055 9816850 9838262 9839861 9873741 9874634 9901842 9904318 9906954 41 61 49 66 44 49 42 52 51 48 36 61 60 63 38 62 40 45 59 48 57 48 35 65 59 61 44 41 42 40 52 41 40 46 43 55 50 41 42 60 42 53 47 63 41 46 61 50 47 54 65 35 47 57 55 45 46 64 53 59 39 65 57 56 66 42 36 57 42 56 44 39 43 53 60 40 44 42 63 64 69 46 45 69 48 48 48 56 45 51 52 58 49 63 52 38 28.76 26.98 30.33 31.2 25.21 22.54 22.9 25.82 26.97 23.62 29.59 22.35 23.06 21.9 27.22 25.62 23.29 22.82 29.51 17.5 24.5 25.1 26.23 32.54 21.83 27.04 21.28 28.68 18.73 24.73 29.35 23.8 34.46 18.68 27.94 25.94 30.89 28.8 25.71 27.73 27.83 23.84 27.42 28.43 20.7 22.83 31.03 20.42 26.25 25.36 29.47 19.99 28.5 25.94 32.27 27.25 21.96 21.99 25.21 25.01 21.8 23.14 25.45 29.3 28.74 27.35 23.07 32.31 30.13 25.38 30.98 21.99 26 22.26 29.89 19.98 18.63 24.01 26.18 20.49 26.58 33.02 27.34 26.64 28.54 28.13 25.11 24.99 26.79 25.98 25.64 27.04 19.22 25.49 29.64 26.87 0 0 20 1 0 20 0 0 9 20 5 0 30 0 30 6 20 0 0 30 0 5 0 3 40 0 20 0 0 15 0 5 1 20 20 0 0 40 0 0 0 0 5 0 20 15 0 30 30 30 6 20 20 0 0 0 0 0 0 43 0 0 0 30 20 0 25 0 30 0 20 15 30 40 10 20 0 30 25 0 1 7 0 23 0 0 20 20 0 15 0 0 8 0 30 0 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 1 0 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1 1 1 1 1 1 1 0 1 1 0 1 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 1 0 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 0 0 1 1 1 0 1 1 0 0 0 0 1 1 0 0 0 1 0 1 0 1 1 0 0 0 1 0 1 0 0 0 1 0 1 0 0 0 1 0 1 0 0 0 1 0 0 1 1 0 1 0 0 0 0 1 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 1 0 1 1 0 1 1 1 0 0 0 0 0 0 1 1 1 1 0 0 1 0 1 0 0 1 1 1 0 0 0 1 1 1 0 1 1 0 0 0 1 0 0 0 0 0 1 1 0 9924801 9944110 61 59 23.06 22.18 0 20 1 1 0 1 0 1 1 0 Midterm Exam Part 2 (50 points) Directions: Create the required tables and graphs in Excel, segregating each question's tables and graphs onto a separate worksheet. Make sure you label clearly each table and graph. Provide the required written answers for each question in text boxes on the question's worksheet. Upload the Excel workbook in the Midterm Exam Part 2 dropbox found in the Midterm Folder on Blackboard by 11:59 PM on the due date found in the syllabus. The dataset, fram_samp.xls (available in the Midterm folder), is a subset of the data from the Framingham Heart Study, a longitudinal study to assess risk factors for cardiovascular disease. It includes n=481 participants who completed one of the regularly scheduled examinations from 1956-1968. The following table shows variable names, as they appear in the dataset, along with brief descriptions and coding details for each variable. Variable Name RANDOM ID AGE BMI CIGS PER DAY HYPERTENSION STROKE CVD DEATH Description Random, unique number for each participant Age at exam, in years Body mass index, kg/meters2 Number of cigarettes smoked per day Hypertension over 24 year follow-up Stroke over 24 year follow-up Cardiovascular disease over 24 year follow-up Death from any cause over 24 year follow-up Coding 2448-9999312 32-70 15.54-56.8 0-70 0=no, 1=yes 0=no, 1=yes 0=no, 1=yes 0=no, 1=yes 1. For each interval/ratio variable (excluding Random ID; 18 points total): a. Create a table that gives the mean, median, mode, standard deviation, minimum and maximum value for each variable. (9 points) b. Create a histogram for each variable. (6 points) c. Comment on the shape of the histogram and determine if the mean, median or the mode is the most appropriate measure of central location. (3 points) 2. For each categorical variable (16 points total): a. Construct a frequency table that gives the counts and relative percentages. (8 points) b. Construct a bar graph that summarizes the data. (8 points) 3. Create a contingency table (also known as a 2 x 2 table) of the variables hypertension vs. stroke. (5 points for the table; 16 points total) a. Give an estimate of the probability of being diagnosed with hypertension. (2 point) b. Give an estimate of the probability of suffering a stroke. (2 point) c. Estimate the probability of having a stroke given someone has been diagnosed with hypertension. (2 point) d. Estimate the probability of having a stroke given someone has not been diagnosed hypertensive. (2 point) e. Calculate the relative risk of stroke for those with hypertension versus those without hypertension and interpret its meaning. (3 points)