(IN SAS) Using the data set, ‘heart.xlsx', do the following: a) Generate a bar chart showing the frequencies for the variable, Status. b) Generate a bar chart showing the mean Cholesterol value for men and women. The variable names are Cholesterol and Sex. c) Generate a horizontal bar chart showing the mean Height for men and women. d) Generate a scatter plot with Height on the x axis and Weight on the y axis. e) Generate a histogram for the variable, Cholesterol. f) Add a normal curve along with the histogram in part (e). g) Generate two horizontal box plots that show the distribution of Cholesterol for men and women (variable Sex). Status Death Cause AgeCHDdiag Sex AgeAtStart Height Weight Diastolic Systolic MRW Smoking AgeAtDeath Cholesterol Chol_Status BP_Status Weight_Status Smoking Status Dead Dead Other Fema 29 62.5 140 Cancer Fema 41 59.75 194 Alive Fema 57 62.25 132 Alive Fema 39 65.75 158 Alive Male 42 66 156 Alive Fema 58 61.75 131 Alive Fema 36 64.75 136 Dead Other Male 53 65.5 130 Alive Male 35 71 194 Dead Cerebral Vascular Disease Male 52 62.5 129 Alive Male 39 66.25 179 Alive 57 Male 33 64.25 151 Alive 55 Male 33 70 174 Alive 79 Male 57 67.25 165 Alive 66 Male 44 69 155 Alive Fema 37 64.5 134 Alive Male 40 66.25 151 Dead Cancer 56 Male 56 67.25 122 Alive Fema 42 67.75 162 Dead Coronary Hear 74 Male 46 66.5 157 Alive Fema 37 66.25 148 Alive Fema 45 64 147 Alive Fema 59 65.75 156 Alive Fema 36 63.75 122 Alive Fema 50 67.5 185 Alive Fema 35 66 123 Alive Male 42 72.25 182 Dead Coronary Hear 71 Fema 49 60.5 Alive 68 Male 40 70 Alive Fema 41 61.75 Dead Unknown Fema 59 67.75 153 189 139 153 Alive 68 Male 40 70 195 Alive Fema 41 62 114 Alive Fema 39 63 144 Alive 43 Male 33 66.5 172 Alive Male 41 69.25 159 Dead Coronary Hea 67 Fema 49 61 142 Alive Male 51 69.5 181 Dead Cancer Male 43 65.5 172 Alive Male 48 66.75 142 °æཥྭ ྨ ྂ¢egeg ༤ N N ཧྨ ྂ ༤ རྞ F ཧྨ ཧྨ e e = ༤ N ྨ e ལྗ ཧྨ gཧྨམཧྨྋས 78 124 121 0 92 144 183 0 55 57 Normal Overweight 181 Desirable 170 114 10 250 High High High Overweight Overweight 80 128 123 0 242 High Normal Overweight 76 110 116 20 281 High Optimal Overweight 92 176 117 0 196 Desirable High Overweight 80 112 110 15 196 Desirable Normal Overweight 80 114 99 0 77 276 High Normal Normal 68 132 124 0 211 Borderline Normal Overweight 78 124 106 5 82 284 High Normal Normal 76 128 133 30 225 Borderline Normal Overweight 68 108 118 0 221 Borderline Optimal Overweight 142 114 0 188 Desirable High Overweight 76 128 118 15 Normal Overweight 90 130 105 30 76 120 108 10 292 High 196 Desirable High Normal Normal Normal 72 132 112 30 192 Desirable Normal 72 120 87 15 72 12 194 Desirable Normal 96 138 119 1 84 142 116 30 76 78 110 112 15 200 Borderline 233 Borderline 192 Desirable High Overweight High Overweight Optimal Overweight Overweight Underweight Non-smoker Non-smoker Moderate (6-15) Non-smoker Heavy (16-25) Non-smoker Moderate (6-15) Non-smoker Non-smoker Light (1-5) Very Heavy (>25) Non-smoker Non-smoker Moderate (6-15) Very Heavy (>25) Moderate (6-15) Very Heavy (>25) Moderate (6-15) Light (1-5) Very Heavy (>25) Moderate (6-15) 74 120 119 5 209 Borderline Normal Overweight Light (1-5) 74 156 122 0 84 132 102 0 200 Borderline 184 Desirable High Overweight Normal Normal Non-smoker Non-smoker 88 150 136 15 76 132 93 0 228 Borderline 150 Desirable High Overweight Moderate (6-15) Normal Normal 78 136 113 110 196 140 124 124 72 116 124 OSO O 0 221 Borderline Normal Overweight Non-smoker Non-smoker 5 73 221 Borderline High Overweight Light (1-5) 0 319 High Normal Overweight Non-smoker 0 194 Desirable Optimal Overweight Non-smoker 82 172 113 0 79 263 High High Overweight Non-smoker 76 132 128 20 205 Borderline Normal Overweight Heavy (16-25) 78 112 98 15 267 High Optimal Normal 80 120 120 0 196 Desirable Normal Overweight 106 146 127 0 247 High High Overweight 96 142 107 0 209 Borderline High Normal 92 138 127 30 75 276 High High Overweight 98 144 122 20 223 Borderline High Overweight 78 118 131 10 63 150 Desirable Optimal Overweight 72 108 105 30 292 High Optimal Normal Alive Malc 31 68 75 231 68 126 160 30 186 Desirable Normal Overweight Moderate (6-15) Non-smoker Non-smoker Non-smoker Very Heavy (>25) Heavy (16-25) Moderate (6-15) Very Heavy (>25) Very Heavy/>25)