Business Analytics7th edition Data Analysis & Decision Making: Chapter 8 Question 17.

46 45 M Less than 20 Competing brand 47 46 F Between 20 and 40 Competing brand 48 47 M Between 20 and 40 Our brand 49 48 F Over 60 Our brand 50 49 F Between 20 and 40 Competing brand 51 50 F Between 20 and 40 Our brand 52 51 F Between 40 and 60 Our brand 53 52 F Between 20 and 40 Our brand 54 53 F Over 60 Competing brand 55 54 F Between 40 and 60 Competing brand 56 55 F Between 20 and 40 Competing brand 57 56 F Over 60 Competing brand 58 57 F Between 40 and 60 Competing brand 59 58 M Between 40 and 60 Our brand 60 59 F Between 20 and 40 Competing brand 61 60 M Over 60 Our brand 62 61 F Between 20 and 40 Our brand 63 62 M Between 20 and 40 Competing brand 64 63 F Over 60 Competing brand 65 64 M Between 40 and 60 Our brand 66 65 M Between 40 and 60 Our brand 67 66 F Between 20 and 40 Competing brand 68 67 F Between 40 and 60 Our brand 69 68 M Over 60 Competing brand 70 69 F Between 20 and 40 Our brand 71 70 M Between 20 and 40 Competing brand 72 71 F Over 60 Competing brand 73 72 M Over 60 Competing brand 74 73 F Between 40 and 60 Competing brand 75 74 F Between 20 and 40 Our brand 76 75 F Between 40 and 60 Our brand 77 76 M Between 40 and 60 Competing brand 78 77 F Between 40 and 60 Our brand 79 78 M Between 20 and 40 Our brand 80 79 F Between 40 and 60 Our brand 81 80 F Between 20 and 40 Competing brand 82 81 M Over 60 Our brand 83 82 M Between 40 and 60 Competing brand 84 83 F Between 40 and 60 Our brand 85 84 F Between 20 and 40 Our brand 86 85 M Less than 20 Our brand 87 86 F Between 40 and 60 Our brand 88 87 M Between 40 and 60 Our brand 89 8B M Between 20 and 40 Our brand 90 89 F Between 40 and 60 Our brandA B C D E 91 90 M Between 40 and 60 Competing brand 92 91 M Between 40 and 60 Competing brand 93 92 M Between 20 and 40 Our brand 94 93 F Between 20 and 40 Competing brand 95 94 F Over 60 Competing brand 96 95 F Between 20 and 40 Competing brand 97 96 F Between 20 and 40 Our brand 98 97 F Between 20 and 40 Competing brand 99 98 F Over 60 Competing brand 100 99 F Between 20 and 40 Competing brand 101 100 F Between 20 and 40 Competing brand 102 101 F Less than 20 Competing brand 103 102 F Over 60 Competing brand 104 103 F Less than 20 Competing brand 105 104 F Between 20 and 40 Our brand 106 105 M Less than 20 Our brand 107 106 F Between 20 and 40 Our brand 108 107 F Between 20 and 40 Our brand 109 108 M Less than 20 Our brand 110 109 M Between 20 and 40 Competing brand 111 110 F Between 40 and 60 Competing brand 112 111 F Between 40 and 60 Our brand 113 112 F Between 20 and 40 Our brand 114 113 M Less than 20 Our brand 115 114 M Between 40 and 60 Our brand 116 115 F Between 20 and 40 Competing brand 117 116 M Over 60 Competing brand 118 117 M Over 60 Our brand 119 118 F Between 20 and 40 Competing brand 120 119 F Between 20 and 40 Competing brand 121 120 F Between 20 and 40 Competing brand 122 121 F Over 60 Competing brand 123 122 F Between 20 and 40 Our brand 124 123 F Between 40 and 60 Competing brand 125 124 F Between 40 and 60 Our brand 126 125 F Between 20 and 40 Our brand 127 126 F Between 20 and 40 Competing brand 128 127 M Between 40 and 60 Competing brand 129 128 M Between 20 and 40 Our brand 130 129 F Between 40 and 60 Our brand 131 130 F Between 20 and 40 Competing brand 132 131 F Over 60 Our brand 133 132 M Over 60 Competing brand 134 133 M Between 20 and 40 Our brand 135 134 Between 20 and 40 Competing brandA B C D E 136 135 Between 40 and 60 Our brand 137 136 Over 60 Competing brand 138 137 Over 60 Competing brand 139 138 1 71 Between 20 and 40 Competing brand 140 139 Between 20 and 40 Competing brand 141 140 Between 40 and 60 Our brand 142 141 F Between 20 and 40 Our brand 143 142 M Over 60 Our brand 144 143 F Between 40 and 60 Competing brand 145 144 TI Between 20 and 40 Competing brand 146 145 F Less than 20 Competing brand 147 146 F Between 20 and 40 Competing brand 148 147 M Between 20 and 40 Competing brand 149 148 F Between 20 and 40 Our brand 150 149 M Over 60 Competing brand 151 150 M Over 60 Our brand 152 151 F Between 20 and 40 Competing brand 153 152 F Between 40 and 60 Competing brand 154 153 F Between 20 and 40 Our brand 155 154 Between 20 and 40 Competing brand 156 155 F Between 40 and 60 Competing brand 157 156 M Between 20 and 40 Our brand 158 157 F Between 40 and 60 Our brand 159 158 Between 20 and 40 Our brand 160 159 Over 60 Our brand 161 160 Between 20 and 40 Our brand 162 161 Over 60 Our brand 163 162 Between 20 and 40 Competing brand 164 163 Between 20 and 40 Competing brand 165 164 Between 20 and 40 Competing brand 166 165 TI Between 20 and 40 Competing brand 167 166 Between 20 and 40 Competing brand 168 167 F Between 40 and 60 Competing brand 169 168 M Between 20 and 40 Our brand 170 169 M Less than 20 Our brand 171 170 F Between 40 and 60 Our brand 172 171 F Over 60 Our brand 173 172 M Over 60 Our brand 174 173 F Between 20 and 40 Competing brand 175 174 M Less than 20 Competing brand 176 175 F Less than 20 Our brand 177 176 M Between 20 and 40 Our brand 178 177 F Between 20 and 40 Competing brand 179 178 Between 20 and 40 Our brand 180 179 F Between 20 and 40 Our brandA B C D E 136 135 Between 40 and 60 Our brand 137 136 Over 60 Competing brand 138 137 Over 60 Competing brand 139 138 1 71 Between 20 and 40 Competing brand 140 139 Between 20 and 40 Competing brand 141 140 Between 40 and 60 Our brand 142 141 F Between 20 and 40 Our brand 143 142 M Over 60 Our brand 144 143 F Between 40 and 60 Competing brand 145 144 TI Between 20 and 40 Competing brand 146 145 F Less than 20 Competing brand 147 146 F Between 20 and 40 Competing brand 148 147 M Between 20 and 40 Competing brand 149 148 F Between 20 and 40 Our brand 150 149 M Over 60 Competing brand 151 150 M Over 60 Our brand 152 151 F Between 20 and 40 Competing brand 153 152 F Between 40 and 60 Competing brand 154 153 F Between 20 and 40 Our brand 155 154 Between 20 and 40 Competing brand 156 155 F Between 40 and 60 Competing brand 157 156 M Between 20 and 40 Our brand 158 157 F Between 40 and 60 Our brand 159 158 Between 20 and 40 Our brand 160 159 Over 60 Our brand 161 160 Between 20 and 40 Our brand 162 161 Over 60 Our brand 163 162 Between 20 and 40 Competing brand 164 163 Between 20 and 40 Competing brand 165 164 Between 20 and 40 Competing brand 166 165 TI Between 20 and 40 Competing brand 167 166 Between 20 and 40 Competing brand 168 167 F Between 40 and 60 Competing brand 169 168 M Between 20 and 40 Our brand 170 169 M Less than 20 Our brand 171 170 F Between 40 and 60 Our brand 172 171 F Over 60 Our brand 173 172 M Over 60 Our brand 174 173 F Between 20 and 40 Competing brand 175 174 M Less than 20 Competing brand 176 175 F Less than 20 Our brand 177 176 M Between 20 and 40 Our brand 178 177 F Between 20 and 40 Competing brand 179 178 Between 20 and 40 Our brand 180 179 F Between 20 and 40 Our brandA B D E 226 225 F Between 20 and 40 Competing brand 227 226 M Between 40 and 60 Competing brand 228 227 F Over 60 Competing brand 229 228 M Less than 20 Our brand 230 229 F Over 60 Competing brand 231 230 F Between 20 and 40 Our brand 232 231 F Between 20 and 40 Competing brand 233 232 F Over 60 Our brand 234 233 F Over 60 Our brand 235 234 M Between 40 and 60 Competing brand 236 235 F Between 20 and 40 Our brand 237 236 Between 40 and 60 Our brand 238 237 Between 20 and 40 Our brand 239 238 Between 40 and 60 Our brand 240 239 Between 40 and 60 Our brand 241 240 Between 40 and 60 Competing brand 242 241 F Between 40 and 60 Our brand 243 242 F Between 20 and 40 Our brand 244 243 F Between 20 and 40 Competing brand 245 244 Over 60 Our brand 246 245 F Between 40 and 60 Competing brand 247 246 M Between 40 and 60 Competing brand 248 247 F Between 20 and 40 Competing brand 249 248 F Between 40 and 60 Our brand 250 249 M Between 20 and 40 Competing brand M Over 60 branA B C D Consumer Gender Age Preference F Over 60 Our brand WU N F Between 40 and 60 Our brand 4 M Between 40 and 60 Our brand Ln F Over 60 Competing brand M Between 20 and 40 Our brand Between 20 and 40 Competing brand 8 F Between 20 and 40 Our brand 8 Between 40 and 60 Competing brand 10 9 Between 20 and 40 Competing brand 11 10 F Between 40 and 60 Competing brand 12 11 Over 60 Competing brand 13 12 Between 20 and 40 Our brand 14 13 Over 60 Competing brand 15 14 F Between 40 and 60 Competing brand 16 15 Between 40 and 60 Competing brand 17 16 Between 20 and 40 Our brand 18 17 Between 20 and 40 Competing brand 19 18 F Between 40 and 60 Competing brand 20 19 F Over 60 Our brand 21 20 F Between 20 and 40 Our brand 22 21 M Over 60 Our brand 23 22 F Between 40 and 60 Competing brand 24 23 F Between 40 and 60 Competing brand 25 24 F Between 40 and 60 Our brand 26 25 F Between 20 and 40 Our brand 27 26 M Between 20 and 40 Our brand 28 27 M Between 20 and 40 Our brand 29 28 F Over 60 Competing brand 30 29 Between 20 and 40 Competing brand 31 30 Between 40 and 60 Competing brand 32 31 Between 20 and 40 Our brand 33 32 Between 20 and 40 Our brand 34 33 Between 20 and 40 Competing brand 35 34 Between 40 and 60 Competing brand 36 35 F Between 20 and 40 Competing brand 37 36 F Between 40 and 60 Our brand 38 37 F Between 40 and 60 Our brand 39 38 M Between 20 and 40 Our brand 40 39 F Between 20 and 40 Competing brand 41 40 F Between 40 and 60 Competing brand 42 41 M Less than 20 Our brand 43 42 M Less than 20 Our brand 44 43 F Between 40 and 60 Our brand 45 44 F Over 60 Competing brandA market research consultant hired by a leading softdrink company wants to determine the proportion of consumers who favor its low-calorie brand over the leading low-calorie competitor in a particular geographic region. A random sample of 250 consumers from the market under investigation is provided in the file P08_17.xlsx. Round your answers to three decimal places, if necessary. a. Calculate a 90% confidence interval for the proportion of all consumers in this market who prefer the company's brand. Lower Limit 0.484 Upper Limit 0.5879 b. The file contains the gender and age group for each customer in the sample. Calculate a separate 90% confidence for each gender for the proportion who prefer the company's brand. Preference(F) Preference(M) Lower Limit .4263 .3256 Upper Limit .1219 Calculate a separate 90% confidence for each age group for the proportion who prefer the company's brand. Between Between Less than 20 20 and 40 40 and 60 Over 60 Lower Limit 0.0353 0.1844 0.1219 0.0585 Upper Limit 0.847 0.2716 0.1981 0.1174 Confidence intervals become wider as sample size decreases