Question
A drugstore manager needs to purchase adequate supplies of various brands of toothpaste to meet the ongoing demands of its customers. In particular, the company
A drugstore manager needs to purchase adequate supplies of various brands of toothpaste to meet the ongoing demands of its customers. In particular, the company is interested in estimating the proportion of its customers who favor the county's leading brand of toothpaste, Crest. The Data sheet of the file 'Toothpaste.xlsx' contains the toothpaste brand preferences of 200 randomly selected customers, obtained recently through customer survey.
a. Compute the proportion of customers who prefer each brand (Aquafresh, Colgate, Crest, Mentadent, and others)
Hint: You can use pivot table or 'Excel IF' function.
b. Calculate a 95% confidence interval for the proportion of customers who prefer Crest toothpaste.
c. How large should the sample be if they would like toensurethat MOE is no larger than 0.05 or 5% at 95% confidence?
| Customer | Preference |
| 1 | Colgate |
| 2 | Mentadent |
| 3 | Crest |
| 4 | Colgate |
| 5 | Aquafresh |
| 6 | Others |
| 7 | Others |
| 8 | Aquafresh |
| 9 | Crest |
| 10 | Others |
| 11 | Crest |
| 12 | Crest |
| 13 | Colgate |
| 14 | Colgate |
| 15 | Others |
| 16 | Colgate |
| 17 | Crest |
| 18 | Colgate |
| 19 | Others |
| 20 | Colgate |
| 21 | Others |
| 22 | Aquafresh |
| 23 | Crest |
| 24 | Crest |
| 25 | Mentadent |
| 26 | Others |
| 27 | Crest |
| 28 | Mentadent |
| 29 | Others |
| 30 | Colgate |
| 31 | Others |
| 32 | Crest |
| 33 | Mentadent |
| 34 | Others |
| 35 | Crest |
| 36 | Others |
| 37 | Others |
| 38 | Others |
| 39 | Crest |
| 40 | Mentadent |
| 41 | Crest |
| 42 | Colgate |
| 43 | Aquafresh |
| 44 | Crest |
| 45 | Others |
| 46 | Others |
| 47 | Mentadent |
| 48 | Others |
| 49 | Mentadent |
| 50 | Crest |
| 51 | Others |
| 52 | Others |
| 53 | Crest |
| 54 | Others |
| 55 | Crest |
| 56 | Crest |
| 57 | Mentadent |
| 58 | Others |
| 59 | Colgate |
| 60 | Mentadent |
| 61 | Crest |
| 62 | Mentadent |
| 63 | Others |
| 64 | Colgate |
| 65 | Crest |
| 66 | Crest |
| 67 | Colgate |
| 68 | Others |
| 69 | Colgate |
| 70 | Crest |
| 71 | Mentadent |
| 72 | Crest |
| 73 | Colgate |
| 74 | Colgate |
| 75 | Crest |
| 76 | Crest |
| 77 | Crest |
| 78 | Aquafresh |
| 79 | Aquafresh |
| 80 | Crest |
| 81 | Colgate |
| 82 | Crest |
| 83 | Others |
| 84 | Colgate |
| 85 | Crest |
| 86 | Others |
| 87 | Crest |
| 88 | Others |
| 89 | Crest |
| 90 | Crest |
| 91 | Mentadent |
| 92 | Mentadent |
| 93 | Others |
| 94 | Others |
| 95 | Colgate |
| 96 | Crest |
| 97 | Crest |
| 98 | Others |
| 99 | Colgate |
| 100 | Mentadent |
| 101 | Others |
| 102 | Aquafresh |
| 103 | Colgate |
| 104 | Others |
| 105 | Mentadent |
| 106 | Crest |
| 107 | Mentadent |
| 108 | Colgate |
| 109 | Colgate |
| 110 | Aquafresh |
| 111 | Crest |
| 112 | Crest |
| 113 | Aquafresh |
| 114 | Crest |
| 115 | Others |
| 116 | Aquafresh |
| 117 | Others |
| 118 | Aquafresh |
| 119 | Others |
| 120 | Crest |
| 121 | Crest |
| 122 | Crest |
| 123 | Colgate |
| 124 | Others |
| 125 | Others |
| 126 | Aquafresh |
| 127 | Others |
| 128 | Colgate |
| 129 | Crest |
| 130 | Mentadent |
| 131 | Others |
| 132 | Others |
| 133 | Crest |
| 134 | Others |
| 135 | Aquafresh |
| 136 | Others |
| 137 | Others |
| 138 | Crest |
| 139 | Mentadent |
| 140 | Others |
| 141 | Crest |
| 142 | Aquafresh |
| 143 | Crest |
| 144 | Mentadent |
| 145 | Mentadent |
| 146 | Crest |
| 147 | Others |
| 148 | Others |
| 149 | Others |
| 150 | Crest |
| 151 | Colgate |
| 152 | Aquafresh |
| 153 | Crest |
| 154 | Others |
| 155 | Mentadent |
| 156 | Crest |
| 157 | Others |
| 158 | Crest |
| 159 | Mentadent |
| 160 | Crest |
| 161 | Crest |
| 162 | Others |
| 163 | Crest |
| 164 | Others |
| 165 | Mentadent |
| 166 | Colgate |
| 167 | Others |
| 168 | Others |
| 169 | Others |
| 170 | Others |
| 171 | Crest |
| 172 | Others |
| 173 | Mentadent |
| 174 | Colgate |
| 175 | Crest |
| 176 | Others |
| 177 | Mentadent |
| 178 | Others |
| 179 | Others |
| 180 | Mentadent |
| 181 | Crest |
| 182 | Mentadent |
| 183 | Crest |
| 184 | Colgate |
| 185 | Colgate |
| 186 | Aquafresh |
| 187 | Crest |
| 188 | Others |
| 189 | Others |
| 190 | Others |
| 191 | Others |
| 192 | Colgate |
| 193 | Crest |
| 194 | Aquafresh |
| 195 | Aquafresh |
| 196 | Others |
| 197 | Colgate |
| 198 | Others |
| 199 | Others |
| 200 | Crest |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Prealgebra
Authors: Marvin L Bittinger, David J Ellenbogen, Barbara L Johnson
7th Edition
032164008X, 9780134347202
