Amanda Chen is the manager of a subscription firm that sells products on a scheduled time basis. She would like to analyze the impact on subscription due to a recent marketing initiative where customers are offered a varying one-time percentage discount (Discount). The response variable Subscribe equals 1 if the customer subscribes and 0 otherwise. Other predictor variables used for the analysis are the customers' age and sex. The accompanying file contains relevant data. Click here for the Excel Data File a-1. Estimate the logistic model where you first create a dummy variable, Male, that equals 1 for males and 0 otherwise. Note: Negative values should be indicated by a minus sign. Round your answers to 2 decimal places. Coefficient Predictor Variable Constant Discount Age Male a-2. Which predictor variables are statistically significant? Predictor Variable Discount Significant at 5%? Age Male b. Predict the subscription probabilities for 30-year-old male and female customers who receive a discount of 10%. Note: Do not round intermediate calculations and round final answers to 2 decimal places. 30-year-old male customer 30-year-old female customer percent percent c. Find the corresponding subscription probabilities for 50-year-old male and female customers who receive a discount of 10%. Note: Do not round intermediate calculations and round final answers to 2 decimal places. 50-year-old male customer 50-year-old female customer percent percent 1 Subscribe B Loiscount Age Sex S 48 Female 31 13 22 Female 41 15 51 Male 9 37 Female 7 72 Female 12 61 Male 10 7 37 Male I 8 46 Male 10 1 3 71 Male 11 0 17 36 Female 12 0 2 27 Male 13 1 181 69 Male 14 1 12 39 Male 15 1 15 30 Female 16 5 69 Male 17 17 4 75 Female 18 6 37 Female 19 2 34 Female 20 10 61 Female 21 1 11 53 Female 22 0 5 20 Male 23 1 14 45 Female 24 1 5 31 Female 25 1 8 71 Male 26 1 14 53 Female 27 1 7 72 Male 28 1 12 73 Male 29 0 11 71 Female 30 0 10 34 Female 31 1 10 73 Female 32 1 5 61 Male 33 1 16 20 Female 34 0 9 27 Male 35 0 9 44 Male 36 1 18 38 Male 37 0 13 64 Female 38 1 18 68 Male 39 0 9 20 Female 40 0 B 63 Female 41 1 17 69 Female 42 1 9 23 Female 43 1 19 64 Male 44 11 14 68 Male 45 1 46 0 47 0 48 0 49 1 66453 30 Female 17 Female 16 Male 16 47 Female 13 42 Female Subscription + A L 49 1 13 50 1 3 58 51 1 9 52 0 15 53 1 9 54 1 18 55 1 9 56 0 3 57 1 8 58 1 20 59 1 601 6 43223233=SER D Female Male 30 Female 20 Female 28 Female 76 Female 64 Female 54 Female 31 Female 40 Female 47 Female 70 Male 61 1 15 59 Male 62 1 19 26 Male 63 1 13 66 Male 64 1 18 28 Male 65 1 3 67 Male 66 1 14 52 Female 67 1 18 30 Male 68 1 19 27 Female 69 1 15 48 Female 70 0 10 57 Male 71 1 8 53 Female 72 1 19 42 Female 731 11 25 Female 74 1 11 75 0 2 76 1 17 77 1 15 55 78 1 18 60 79 0 5 64 80 1 15 61 81 0 15 61 82 1 8 83 0 8 42 84 1 15 74 85 0 10 85 0 13 87 1 3 88 1 6 89 1 12 90 0 16 91 1 15 92 0 18 93 1 16 94 0 S 95 1 5 96 1 2 13 G22833622232223323SCARF Male Male Male Female Female Female Female Female Female Male 64 Female Male 35 Female 50 Female 59 Female 66 Female 40 Female 53 Male 64 Male 46 53 39 Female Male Female Female Mala A C Male D E 97 0 12 24 98 1 3 74 Female 99 1 19 44 Male 100 1 14 44 Male 101 1 3 24 Female 102 0 5 71 Male 103 1 3 76 Male 104 0 8 24 Male 105 1 10 43 Female 106 0 3 75 Male 107 0 3 64 Male 108 1 12 39 Male 109 1 6 59 Male 1100 9 24 Male 111 0 15 56 Male 112 1 19 39 Male 113 1 11 33 Male 114 0 13 23 Male 1150 3 71 Male 116 0 15 61 Female 1171 16 48 Male 118 0 3 63 Male 119 1 11 72 Male 120 1 9 37 Male 1211 12 70 Male 122 1 12 24 Male 123 1 14 24 Female 124 0 3 52 Female 125 1 16 49 Female 1261 3 56 Female 127 0 4 44 Female 1280 5 53 Female 129 1 7 54 Female 130 0 2 23 Male 131 1 12 54 Male 132 0 6 69 Female 133 0 6. 58 Male 134 1 3 76 Female 1351 16 39 Female 136 1 3 31 Female 137 1 11 53 Male 138 0 18 22 Female 139 1 5 57 Male 1401 12 51 Female 141 1 12 70 Male 142 0 5 25 Male 143 1 15 62 Male 144 0 5 28 Female 4 B C D E 1451 7 52 Female 146 1 3 36 Male 147 0 3 19 Male 148 0 4 76 Female 149 0 4 71 Female 150 0 4 16 Female 1511 17 53 Female 1521 15 70 Female 153 1 17 40 Female 154 1 18 29 Male 155 1 14 65 Female 156 0 5 16 Female 157 1 16 21 Female 158 0 17 59 Female 159 1 15 76 Female 160 0 20 58 Female 1610 7 34 Male 162 0 17 48 Male 163 1 7 46 Male 1641 19 39 Male 165 0 7 62 Female 166 0 3 29 Male 167 0 7 48 Female 168 1 8 55 Female 169 1 4 27 Male 170 1 18 48 Female 1710 3 42 Male 172 1 7 31 Male 173 1 13 57 Female 174 1 18 25 Female 175 0 5 35 Female 1761 9 18 Female 177 1 10 45 Male 178 1 9 41 Female 179 0 6 47 Male 180 1 16 48 Female 181 0 10 76 Male 182 1 7 45 Female 183 1 18 72 Female 184 1 17 29 Male 185 0 10 73 Male 186 1 12 39 Female 187 1 6 32 Male 188 1 B 43 Female 189 1 17 34 Male 190 0 6 50 Male 1911 8 75 192 0 3 44 Female Male 1030 10 31 Mala 193 0 A B C D 19 31 Male 1940 7 33 Male 1951 15 26 Female 196 1 11 27 Male 197 1 19 35 Male 1980 3 63 Female 199 1 18 65 Female 2001 18 60 Male 201 1 11 40 Female 2020 5 69 Male 203 0 10 33 Male 204 0 4 46 Female 205 0 2 43 Female 206 1 13 68 Female 207 1 4 53 Male 208 1 10 58 Male 209 1 17 71 Female 2100 3 47 Female 211 1 13 36 Female: 212 1 15 2131 10 214 0 5. 2151 S 2160 3 2171 6 218 1 9 219 1 13 2201 11 2211 19 222 1 6. 32368223233 43 Male Female 54 Female 61 Female 60 Female: 70 Female 49 Female 69 Male 27 Male 35 Female 39 Male 2231 6 48 Female 224 1 5 74 Male 225 1 17 65 Female 2260 18 26 Male 227 0 5 19 Male 228 1 17 63 Female 2290 3 62 Male 2300 231 0 232 1 233 1 234 1 2350 236 1 237 0 238 1 239 0 2400 2410 BARABRECEN 14 64 Male 13 24 Male 18 39 Female 13 28 Male 18 67 Female 15 35 Female 20 27 Male 12 51 Male 19 41 Female 14 18 Female 19 Female 21 stole Subscription + A B C D 241 0 6 21 Male 242 0 S 44 Female 243 1 16 65 Female 244 0 5 23 Male 2451 20 44 Female 246 0 4 61 Male 247 1 12 49 Male 248 0 2 38 Male 249 0 13 34 Male 2501 12 62 Female 2511 3 70 Female 252 0 8 27 Male 2531 18 30 Male 2541 7 63 Male 2551 18 63 Male 2561 13 36 Female 2571 13 47 Male 2580 17 48 Male 259 0 13 71 Male 260 0 3 70 Male 261 0 6 17 Male 2621 11 31 Male 263 1 19 76 Female 264 0 4 18 Male 265 1 20 30 Female 2661 9 35 Male 2671 7 41 Female 268 1 16 71 Male 269 1 17 39 Male 270 1 14 37 Female 271 0 4 19 Male 272 1 14 73 Female 2731 15 38 Female 274 1 8 60 Male 2751 11 56 Male 276 0 16 26 Male 2771 13 24 Male 278 1 11 75 Male 279 0 15 36 Female 280 1 19 46 Female 281 1 18 70 Male 282 0 3 28 Male 283 0 8 38 Female 2841 6 29 Female 285 0 2861 2871 288 1 300 16197 15 20 Female 57 Female 27 Male 58 Female 22 269 1 17 39 270 1 14 37 Female 271 0 4 19 272 1 14 73 132 Male Female 273 1 15 38 Female 274 1 8 60 Male 275 1 11 56 Male 276 0 16 26 Male 277 1 13 24 Male 278 1 11 75 Male 279 0 15 36 Female 280 1 19 46 Female 281 18 70 Male 282 0 3 28 Male 283 0 8 38 Female 284 1 6 29 Female 285 0 15 20 Female 286 1 6 57 Female 287 1 16 17 Male 288 1 9 58 Female 289 1 7 23 Female 290 1 17 41 Female 291 0 4 66 Female 292 1 14 50 Male 293 1 8 40 Female 294 0 4 17 Male 295 1 20 44 Female 296 1 15 54 Male 297 1 20 67 Male 298 0 7 33 Male 299 1 6 300 0 3 301 1 10 10 322 36 Male 21 Male Female 302 303