Question
6 Dominos DeepPan 10.69 23 Dominos DeepPan 10.47 56 Dominos DeepPan 10.23 65 Dominos DeepPan 10.38 88 Dominos DeepPan 10.46 113 Dominos DeepPan 10.47 148
6 Dominos DeepPan 10.69 23 Dominos DeepPan 10.47 56 Dominos DeepPan 10.23 65 Dominos DeepPan 10.38 88 Dominos DeepPan 10.46 113 Dominos DeepPan 10.47 148 Dominos DeepPan 10.52 178 Dominos DeepPan 10.34 184 Dominos DeepPan 10.72 189 Dominos DeepPan 10.54 200 Dominos DeepPan 10.54 208 Dominos DeepPan 10.47 243 Dominos DeepPan 10.67 249 Dominos DeepPan 10.38 3 Dominos DeepPan 10.65 37 Dominos DeepPan 10.37 71 Dominos DeepPan 10.53 75 Dominos DeepPan 10.41 110 Dominos DeepPan 10.63 150 Dominos DeepPan 10.40 175 Dominos DeepPan 10.43 181 Dominos DeepPan 10.65 198 Dominos DeepPan 10.45 203 Dominos DeepPan 10.51 218 Dominos DeepPan 10.54 224 Dominos DeepPan 10.47 250 Dominos DeepPan 10.28 25 Dominos DeepPan 10.43 27 Dominos DeepPan 10.49 30 Dominos DeepPan 10.58 33 Dominos DeepPan 10.48 59 Dominos DeepPan 10.50 62 Dominos DeepPan 10.27 64 Dominos DeepPan 10.68 90 Dominos DeepPan 10.69 137 Dominos DeepPan 10.34 142 Dominos DeepPan 10.30 145 Dominos DeepPan 10.51 228 Dominos DeepPan 10.51 230 Dominos DeepPan 11.33 28 Dominos Mid 10.30 31 Dominos Mid 10.46 38 Dominos Mid 10.71 39 Dominos Mid 10.48 60 Dominos Mid 10.62 77 Dominos Mid 10.60 78 Dominos Mid 10.40 89 Dominos Mid 10.74 130 Dominos Mid 10.04 139 Dominos Mid 10.54 140 Dominos Mid 10.35 143 Dominos Mid 10.42 144 Dominos Mid 10.52 231 Dominos Mid 10.47 242 Dominos Mid 10.56 5 Dominos Mid 10.47 24 Dominos Mid 10.49 32 Dominos Mid 10.49 87 Dominos Mid 10.54 111 Dominos Mid 10.54 129 Dominos Mid 10.51 149 Dominos Mid 10.35 177 Dominos Mid 10.46 179 Dominos Mid 10.49 183 Dominos Mid 10.69 187 Dominos Mid 10.49 199 Dominos Mid 10.44 223 Dominos Mid 10.35 247 Dominos Mid 10.15 26 Dominos Mid 10.45 70 Dominos Mid 10.56 76 Dominos Mid 10.65 108 Dominos Mid 10.65 180 Dominos Mid 10.74 182 Dominos Mid 11.38 197 Dominos Mid 10.68 202 Dominos Mid 10.65 207 Dominos Mid 10.62 209 Dominos Mid 10.83 219 Dominos Mid 10.55 225 Dominos Mid 10.45 252 Dominos Mid 10.52 2 Dominos Thin 11.67 36 Dominos Thin 11.42 73 Dominos Thin 11.29 74 Dominos Thin 11.46 109 Dominos Thin 11.30 138 Dominos Thin 11.59 188 Dominos Thin 11.35 201 Dominos Thin 11.28 204 Dominos Thin 11.23 206 Dominos Thin 11.58 210 Dominos Thin 10.65 217 Dominos Thin 11.43 226 Dominos Thin 11.39 251 Dominos Thin 11.47 22 Dominos Thin 11.36 29 Dominos Thin 11.39 34 Dominos Thin 11.32 57 Dominos Thin 11.43 58 Dominos Thin 11.42 61 Dominos Thin 11.56 79 Dominos Thin 11.49 85 Dominos Thin 11.68 127 Dominos Thin 11.40 131 Dominos Thin 11.45 141 Dominos Thin 11.50 146 Dominos Thin 11.47 227 Dominos Thin 11.36 229 Dominos Thin 10.07 1 Dominos Thin 11.57 4 Dominos Thin 10.81 21 Dominos Thin 10.39 35 Dominos Thin 11.55 63 Dominos Thin 11.54 86 Dominos Thin 11.48 112 Dominos Thin 11.49 147 Dominos Thin 11.33 176 Dominos Thin 11.55 185 Dominos Thin 11.47 186 Dominos Thin 11.51 190 Dominos Thin 11.15 205 Dominos Thin 11.20 241 Dominos Thin 11.41 248 Dominos Thin 11.35 10 EagleBoys DeepPan 11.57 41 EagleBoys DeepPan 11.21 50 EagleBoys DeepPan 11.57 84 EagleBoys DeepPan 11.29 103 EagleBoys DeepPan 11.27 118 EagleBoys DeepPan 11.39 119 EagleBoys DeepPan 11.57 126 EagleBoys DeepPan 11.24 153 EagleBoys DeepPan 11.29 157 EagleBoys DeepPan 11.63 160 EagleBoys DeepPan 11.10 173 EagleBoys DeepPan 11.26 194 EagleBoys DeepPan 11.72 235 EagleBoys DeepPan 11.45 237 EagleBoys DeepPan 11.82 8 EagleBoys DeepPan 11.33 45 EagleBoys DeepPan 11.65 68 EagleBoys DeepPan 11.14 72 EagleBoys DeepPan 11.74 98 EagleBoys DeepPan 11.69 120 EagleBoys DeepPan 11.36 132 EagleBoys DeepPan 11.78 135 EagleBoys DeepPan 11.50 156 EagleBoys DeepPan 11.48 165 EagleBoys DeepPan 11.21 167 EagleBoys DeepPan 11.43 172 EagleBoys DeepPan 11.49 191 EagleBoys DeepPan 11.42 211 EagleBoys DeepPan 11.54 215 EagleBoys DeepPan 11.33 220 EagleBoys DeepPan 11.55 40 EagleBoys DeepPan 11.31 42 EagleBoys DeepPan 11.42 46 EagleBoys DeepPan 11.43 49 EagleBoys DeepPan 11.40 52 EagleBoys DeepPan 11.26 69 EagleBoys DeepPan 11.41 91 EagleBoys DeepPan 11.41 105 EagleBoys DeepPan 11.32 116 EagleBoys DeepPan 11.41 124 EagleBoys DeepPan 11.56 233 EagleBoys DeepPan 11.96 244 EagleBoys DeepPan 11.56 13 EagleBoys Mid 11.41 19 EagleBoys Mid 11.28 43 EagleBoys Mid 11.31 47 EagleBoys Mid 11.43 55 EagleBoys Mid 11.41 81 EagleBoys Mid 11.28 95 EagleBoys Mid 11.60 96 EagleBoys Mid 11.57 99 EagleBoys Mid 11.49 104 EagleBoys Mid 11.32 107 EagleBoys Mid 11.36 123 EagleBoys Mid 11.36 133 EagleBoys Mid 11.16 234 EagleBoys Mid 11.27 236 EagleBoys Mid 11.29 12 EagleBoys Mid 11.51 15 EagleBoys Mid 11.39 44 EagleBoys Mid 11.26 83 EagleBoys Mid 11.54 94 EagleBoys Mid 11.34 100 EagleBoys Mid 11.33 115 EagleBoys Mid 11.08 161 EagleBoys Mid 11.41 166 EagleBoys Mid 11.10 171 EagleBoys Mid 11.39 174 EagleBoys Mid 11.14 195 EagleBoys Mid 11.74 213 EagleBoys Mid 11.33 246 EagleBoys Mid 11.38 7 EagleBoys Mid 11.48 51 EagleBoys Mid 11.31 67 EagleBoys Mid 11.45 93 EagleBoys Mid 11.24 121 EagleBoys Mid 11.21 128 EagleBoys Mid 10.46 136 EagleBoys Mid 11.45 151 EagleBoys Mid 11.19 155 EagleBoys Mid 11.42 164 EagleBoys Mid 11.34 168 EagleBoys Mid 11.33 216 EagleBoys Mid 11.17 221 EagleBoys Mid 11.40 238 EagleBoys Mid 11.32 9 EagleBoys Thin 11.83 48 EagleBoys Thin 11.71 92 EagleBoys Thin 11.59 114 EagleBoys Thin 11.61 134 EagleBoys Thin 12.07 154 EagleBoys Thin 11.55 159 EagleBoys Thin 11.32 169 EagleBoys Thin 11.69 170 EagleBoys Thin 11.62 212 EagleBoys Thin 11.87 222 EagleBoys Thin 11.70 239 EagleBoys Thin 11.76 14 EagleBoys Thin 11.80 18 EagleBoys Thin 11.81 20 EagleBoys Thin 11.98 53 EagleBoys Thin 11.77 54 EagleBoys Thin 11.57 66 EagleBoys Thin 11.95 80 EagleBoys Thin 11.58 97 EagleBoys Thin 11.24 106 EagleBoys Thin 11.93 117 EagleBoys Thin 11.78 125 EagleBoys Thin 11.88 232 EagleBoys Thin 11.30 240 EagleBoys Thin 11.31 11 EagleBoys Thin 11.47 16 EagleBoys Thin 11.60 17 EagleBoys Thin 11.81 82 EagleBoys Thin 12.01 101 EagleBoys Thin 11.84 102 EagleBoys Thin 11.57 122 EagleBoys Thin 11.57 152 EagleBoys Thin 12.23 158 EagleBoys Thin 11.62 162 EagleBoys Thin 11.64 163 EagleBoys Thin 11.52 196 EagleBoys Thin 11.76 214 EagleBoys Thin 11.59 245 EagleBoys Thin 11.55
This data represents the diameter (inches) of a sample of 250 pizzas selected from two different chains (Dominos, EagleBoys) and for 3 different types of crust (DeepPan, Mid, Thin). For this assignment, you need to compute the average (mean) pizza diameter for each store and crust type as well as the variability (standard deviation) for each store/crust combo. You will use the =AVERAGE function in each of the cells in the top table and the =STDEV.P function in the bottom table. Each time you create a function for a certain store/crust combination, you will need to select the correct range of cells from the raw data on the left. After creating your tables above with the mean for each type of pizza, you will then create a line graph that will visually depict those 6 means. Paste both your tables and graph into a Word document and also answer the questions for this assignment in that same Word file.
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