Excel's PivotTable Report provides an excellent way to summarize data for two or more variables simultaneously. The goal

Post by **answerhappygod** » Wed May 11, 2022 10:31 am

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 1 (103.9 KiB) Viewed 31 times

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 2 (236.26 KiB) Viewed 31 times

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 3 (222.15 KiB) Viewed 31 times

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 4 (214.4 KiB) Viewed 31 times

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 5 (217.99 KiB) Viewed 31 times

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 6 (219.26 KiB) Viewed 31 times

: Excel S Pivottable Report Provides An Excellent Way To Summarize Data For Two Or More Variables Simultaneously The Goal 7 (199.23 KiB) Viewed 31 times

Excel's PivotTable Report provides an excellent way to summarize data for two or more variables simultaneously. The goal of this Excel Graded Tutorial is to familiarize you with Excel's Pivottable feature and learn about its uses. You will learn how to use Pivot Tables by developing a crosstabulation of region, quality rating, and meal price for 300 restaurants and then answering questions about the data. The data for this problem is located on the 'Data' sheet in columns A through D of the Excel Online file below. An empty Pivot Table is provided on the 'Pivot' sheet. Click on the 'Pivot' tab to select the PivotTable sheet. Inside the Pivot Table1 area right-click and select Show Field List. The Pivottable task pane should now be displayed on the right side of the spreadsheet. In the field list you should see Restaurant, Region, Quality Rating, and Meal Price ($). Construct a spreadsheet to answer the following questions. Open spreadsheet Questions 1. What are the sales totals for each region? answer this question, proceed as follows. First, click on Region in the Field List and then drag it to the rows box in the PivotTable pane. You will see the four regions enter the Pivot Table. Next, drag Meal Price ($) into the values box of the Pivot Table pane. The second column in the Pivot Table should now be Sum of Meal Price ($). What are the total sales for each Region and the Grand Total? Total Sales East $ North $ South $ West $ Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question, proceed as follows. First, click on Region in the rows box of the Pivot Table (where it was used to answer Question 1) and then drag it back into the field List. Next, drag Quality Rating from the Field List into the rows box of the Pivot Table pane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good $ 3. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent restaurants in the West? To answer this question, proceed as follows. Drag Quality rating from the rows box to the column box in the Pivot Table pane. Then drag Region from the Field List into the rows box. The intersection of West and Excellent in the Pivot Table provides the answer. Total sales for Excellent meals in the West Region. Total sales for Excellent restaurants in the West are $ 4. What is the average meal price for the entire East region and Very Good meals in the East region to the nearest cent? To answer this question, proceed as follows. Select all numeric values in the Pivot Table as is appears from Question 3 above. Next, go to the values box in the Pivottable pane and click on Sum of Meal Prices and select Value Field Settings. In Value Field Settings select Average. Then click OK. In the Values box, it should now read Average of Meal Price ($). Average meal price in the East Region is $ (to the nearest cent). Average meal price for Very Good meals in the East Region is $ (to the nearest cent)

E F G 1 Question 1 Total Sales East North South West Grand Total Question 2 Total Sales Excellent Good Very Good Question 3 Total Sales (Excellent, West) Question 4 Average Meal Price (East) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Average Meal Price (Very Good, East) A B С D Restaurant Region Quality Rating Meal Price SI 1 South Very Good 15 2 West Excellent 20 3 West Very Good 43 4 North Excellent 44 5 North Excellent 48 6 East Excellent 22 7 West Good 33 8 South Excellent 55 9 South Very Good 14 10 North Good 28 11 West Good 51 12 North Good 52 13 South Excellent 40 14 North Excellent 30 15 East Very Good 28 16 North Very Good 36 17 West Good 30 18 South Very Good 26 19 North Excellent 50 20 South Good 34 21 North Very Good 24 22 West Good 52 23 West Good 54 24 West Very Good 21 25 East Very Good 54 26 East Excellent 41 27 North Very Good 17 28 South Very Good 19 29 West Very Good 34 30 South Excellent 37 31 East Good 35 32 West Good 43 33 South Good 16 34 South Excellent 18 35 North Good 49 36 South Good 35 37 West Very Good 54 38 South Good 47 39 East Very Good 31 40 North Excellent 13 41 North Excellent 17 42 South Excellent 51 43 North Very Good 20 44 East Very Good 45 West Good 10 46 North Excellent 38 47 North Very Good 37 48 West Good 40 49 West Excellent 15 50 South Very Good 19 51 South Very Good 12 46 47 48 49 50 51 52

Name Box Region E Meal Price ($) UUULI 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 52 West 53 West 54 East 55 North 56 North 57 East 58 East 59 North 60 West 61 South 62 South 63 East 64 North 65 East 66 West 67 South 68 South 69 South 70 West 71 North 72 South 73 West 74 South 75 North 76 North 77 North 78 North 79 North 80 South 81 East 82 North 83 South 84 North 85 East 86 West 87 West 88 East 89 South 90 East 91 North 92 South 93 West 94 East 95 South 96 South 97 North 98 West 99 East 100 West 101 North 102 West Quality Rating veiyuuuu Good Good Good Good Good Good Good Very Good Excellent Very Good Very Good Very Good Very Good Excellent Good Very Good Good Very Good Good Excellent Very Good Very Good Very Good Good Excellent Very Good Good Good Good Excellent Very Good Excellent Good Excellent Excellent Excellent Very Good Very Good Good Good Very Good Excellent Very Good Good Very Good Good Very Good Excellent Excellent Very Good Excellent 30 46 25 54 45 15 17 51 12 32 34 48 31 49 35 14 27 49 50 30 12 14 13 16 39 52 25 54 29 25 51 13 55 35 22 15 42 46 26 14 52 49 31 12 38 55 19 55 11 50 33 102 103

Restaurant Region Meal Price ($) E F IU IUL VVVUL 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 103 West 104 East 105 East 106 West 107 West 108 West 109 East 110 East 111 East 112 South 113 North 114 North 115 North 116 South 117 South 118 North 119 East 120 South 121 West 122 West 123 East 124 East 125 West 126 North 127 North 128 East 129 West 130 West 131 West 132 North 133 West 134 East 135 South 136 West 137 East 138 North 139 South 140 East 141 East 142 West 143 West 144 North 145 East 146 East 147 East 148 South 149 West 150 South 151 North 152 East 153 North Quality Rating LAUUHUTTL Good Good Very Good Excellent Good Very Good Excellent Excellent Excellent Excellent Excellent Excellent Good Good Excellent Excellent Very Good Good Excellent Very Good Very Good Excellent Excellent Excellent Excellent Good Good Very Good Excellent Excellent Good Excellent Excellent Very Good Good Very Good Excellent Good Good Excellent Excellent Excellent Very Good Good Excellent Very Good Very Good Good Excellent Good Very Good 23 25 42 51 42 49 28 48 29 20 30 32 49 49 15 11 55 20 33 11 37 13 12 44 44 31 10 11 52 53 18 13 53 48 11 10 16 30 11 24 11 27 42 32 44 55 39 18 22 50 55

Restaurant Region Meal Price ($) E IJT IVV ITIL 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 154 North 155 North 156 East 157 South 158 South 159 North 160 West 161 North 162 East 163 East 164 West 165 North 166 East 167 North 168 West 169 South 170 North 171 East 172 North 173 East 174 West 175 South 176 West 177 South 178 South 179 East 180 East 181 North 182 South 183 West 184 East 185 North 186 North 187 North 188 West 189 North 190 North 191 West 192 East 193 East 194 West 195 North 196 East 197 East 198 East 199 South 200 South 201 South 202 West 203 North 204 South Quality Rating Viyuuuu Good Excellent Excellent Good Excellent Excellent Excellent Good Good Excellent Very Good VeryGood Good Very Good Good Very Good Very Good Good Excellent Very Good Excellent Good Excellent Good Good Very Good Excellent Excellent Very Good Good Good Excellent Very Good Excellent Good Good Very Good Good Good Excellent Very Good Very Good Good Excellent Very Good Excellent Very Good Very Good Very Good Very Good Good 53 32 43 19 17 54 48 24 32 17 48 42 13 51 39 30 23 42 35 50 50 31 47 39 18 29 35 36 37 29 25 25 35 22 15 52 32 35 15 27 15 37 18 35 10 21 37 47 33 12 26 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205

Meal Price ($) E 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 estaurant Region 205 North 206 East 207 South 208 West 209 West 210 South 211 West 212 East 213 North 214 South 215 West 216 South 217 West 218 North 219 West 220 East 221 East 222 North 223 North 224 North 225 East 226 South 227 North 228 South 229 North 230 North 231 South 232 North 233 North 234 South 235 South 236 South 237 West 238 West 239 West 240 West 241 North 242 North 243 West 244 East 245 East 246 West 247 West 248 West 249 South 250 West 251 East 252 South 253 South 254 South 255 West Quality Rating Excellent Good Excellent Good Very Good Excellent Very Good Excellent Very Good Very Good Very Good Very Good Good Very Good Excellent Excellent Good Good Excellent Excellent Excellent Very Good Excellent Excellent Good Very Good Very Good Excellent Excellent Excellent Very Good Very Good Good Excellent Excellent Very Good Good Very Good Excellent Very Good Good Good Excellent Excellent Good Excellent Good Good Very Good Very Good Good 36 11 53 24 49 10 11 43 22 50 20 21 25 11 32 48 43 48 52 42 27 38 45 35 48 33 43 35 17 23 36 36 42 44 47 15 35 49 42 33 39 23 53 53 41 34 48 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 33 34 49 18

Meal Price ($) E Restaurant Region 257 256 East 258 257 South 259 258 West 260 259 West 261 260 East 262 261 South 263 262 East 264 263 South 265 264 South 266 265 South 267 266 South 268 267 South 269 268 East 270 269 West 271 270 East 272 271 North 273 272 East 274 273 South 275 274 North 276 275 East 277 276 East 278 277 South 279 278 South 280 279 West 281 280 East 282 281 East 283 282 North 284 283 East 285 284 East 286 285 South 287 286 East 288 287 West 289 288 West 290 289 East 291 290 North 292 291 East 293 292 West 294 293 South 295 294 East 296 295 West 297 296 South 298 297 West 299 298 East 300 299 North 301 300 East 302 Quality Rating Very Good Good Excellent Excellent Good Excellent Excellent Excellent Good Very Good Very Good Good Excellent Good Excellent Excellent Excellent Very Good Excellent Good Excellent Very Good VeryGood Very Good Good Excellent Very Good Good Very Good Very Good Excellent Excellent Good Good Good Very Good Good Excellent Excellent Excellent Excellent Excellent Excellent Very Good Excellent 53 13 19 21 30 14 52 34 36 16 22 31 54 41 21 17 33 31 43 38 34 32 53 52 13 31 36 51 12 34 18 34 25 19 38 33 12 20 13 21 38 22 49 37 45.