Excel application of statistics Restaurant data : Restaurant Quality Rating Meal Price ($)1 Good 182 Very Good 223 Good 284 Excellent 385 Very Good 336 Good 287 Very Good 198 Very Good 119 Very Good 2310 Good 1311 Very Good 3312 Very Good 4413 Excellent 4214 Excellent 3415 Good 2516 Good 2217 Good 2618 Excellent 1719 Very Good 3020 Good 1921 Very Good 3322 Very Good 2223 Excellent 3224 Excellent 3325 Very Good 3426 Very Good 3827 Good 2728 Good 2729 Very Good 2630 Very Good 3431 Very Good 3532 Good 2533 Excellent 4434 Good 2635 Excellent 4736 Good 1037 Excellent 3538 Good 1239 Good 1540 Excellent 2741 Good 1942 Excellent 4543 Very Good 3244 Very Good 1445 Excellent 4046 Excellent 3147 Very Good 1748 Very Good 2049 Excellent 3650 Excellent 2451 Very Good 3852 Good 1053 Very Good 1054 Excellent 2155 Very Good 3456 Very Good 3157 Excellent 2558 Good 2259 Very Good 2860 Good 1061 Very Good 2762 Excellent 4163 Very Good 3564 Good 1165 Good 1866 Excellent 4067 Very Good 4868 Excellent 2669 Very Good 1270 Good 2071 Very Good 3872 Very Good 3673 Very Good 3774 Very Good 2475 Very Good 1876 Very Good 3477 Very Good 2878 Very Good 2579 Very Good 2580 Very Good 3081 Very Good 2182 Excellent 2883 Very Good 1684 Good 2385 Excellent 4686 Very Good 1487 Good 1188 Very Good 2089 Very Good 3290 Excellent 2091 Very Good 2492 Very Good 1493 Very Good 2494 Excellent 3395 Good 2396 Very Good 2897 Very Good 1798 Excellent 2899 Very Good 16100 Excellent 31101 Very Good 27102 Excellent 30103 Good 33104 Excellent 32105 Good 19106 Very Good 25107 Very Good 25108 Good 20109 Excellent 37110 Very Good 27111 Very Good 28112 Good 20113 Very Good 31114 Very Good 26115 Very Good 38116 Good 15117 Good 25118 Very Good 40119 Very Good 35120 Good 20121 Very Good 23122 Very Good 13123 Good 20124 Good 20125 Good 10126 Very Good 17127 Very Good 20128 Very Good 21129 Excellent 35130 Excellent 41131 Good 28132 Excellent 30133 Very Good 31134 Excellent 33135 Excellent 32136 Good 18137 Good 27138 Excellent 38139 Very Good 23140 Very Good 32141 Very Good 25142 Very Good 28143 Good 19144 Very Good 14145 Very Good 19146 Very Good 18147 Very Good 16148 Very Good 42149 Very Good 12150 Good 14151 Very Good 26152 Good 15153 Very Good 14154 Good 20155 Very Good 30156 Good 16157 Good 21158 Excellent 35159 Very Good 30160 Very Good 31161 Very Good 28162 Very Good 19163 Excellent 43164 Good 17165 Excellent 27166 Excellent 32167 Excellent 36168 Very Good 21169 Very Good 11170 Excellent 48171 Very Good 13172 Good 19173 Very Good 35174 Very Good 28175 Good 13176 Very Good 32177 Excellent 27178 Very Good 33179 Very Good 37180 Very Good 28181 Good 24182 Good 10183 Very Good 36184 Very Good 37185 Very Good 25186 Very Good 11187 Good 11188 Very Good 11189 Good 10190 Good 29191 Very Good 14192 Very Good 21193 Good 28194 Very Good 42195 Very Good 30196 Excellent 41197 Good 22198 Good 23199 Very Good 27200 Very Good 13201 Very Good 28202 Good 12203 Excellent 23204 Very Good 30205 Good 17206 Good 20207 Good 20208 Good 26209 Good 18210 Very Good 13211 Very Good 25212 Very Good 22213 Very Good 27214 Very Good 21215 Very Good 32216 Very Good 16217 Very Good 20218 Good 27219 Excellent 44220 Very Good 35221 Very Good 21222 Very Good 30223 Good 23224 Good 19225 Very Good 18226 Excellent 36227 Good 29228 Very Good 20229 Good 17230 Very Good 45231 Good 20232 Excellent 41233 Good 26234 Good 16235 Very Good 23236 Excellent 31237 Very Good 23238 Very Good 20239 Very Good 38240 Good 17241 Excellent 46242 Very Good 26243 Very Good 24244 Very Good 21245 Excellent 30246 Excellent 13247 Excellent 23248 Very Good 25249 Very Good 28250 Very Good 13251 Very Good 27252 Very Good 15253 Good 11254 Excellent 40255 Good 28256 Excellent 46257 Very Good 32258 Good 12259 Good 37260 Excellent 22261 Excellent 42262 Very Good 21263 Excellent 32264 Excellent 34265 Very Good 37266 Excellent 20267 Very Good 21268 Very Good 16269 Excellent 47270 Very Good 33271 Excellent 48272 Very Good 33273 Very Good 25274 Very Good 34275 Very Good 20276 Excellent 36277 Excellent 40278 Good 13279 Very Good 12280 Very Good 27281 Very Good 20282 Excellent 30283 Good 29284 Very Good 22285 Good 27286 Very Good 20287 Excellent 37288 Very Good 27289 Good 23290 Good 16291 Very Good 23292 Very Good 24293 Excellent 45294 Good 14295 Good 18296 Good 17297 Good 16298 Good 15299 Very Good 38300 Very Good 31

fx A B C D E G H K L M N O P Problem Using the Restaurant dataset provided at the last tab of this spreadsheet: Ol) Develop a pivot table that shows the number of restaurants and the average meal price in each quality group. 3 ma (2) Develop a pivot table that indicates the number of restaurants in each quality group and price range. For the price ranges. use a class width of 10. 3 ma (3) Construct a 3-D stacked column chart for the pivot table in question 2. taking the following into consideration: 4 ma a. add a chart title that gives a reasonable description of what the chart depicts b. add "Frequency" and " Meal Price Category" as the axes titles (4) Based on the data provided and information presented by the pivot tables, comment on the quality rating of the restaurant and whether or not the quality of meals is related to meal price. 3 ma