Business Finance
Emerson College Social Media Marketing Excel Pivot Table Homework

MIS 11

Emerson College

MIS

Question Description

I don’t know how to handle this Social Media Marketing question and need guidance.

create at least two-three different pivot tables (or pivot charts) to answer the following questions. Then anslyse it.

please write half page first draft( like what are you going to do) and then write the final draft. using two document to sparete first draft and final draft please. and the requirement is below. please follow the pivot table rubric.


Part One - Basic Pivot Tables (3 points)Excel 2007 format data file (.xlsx)

Excel 97-2003 format data file (.xls)

Using the Excel spreadsheet found above, create at least two-three different pivot tables (or pivot charts) to answer the following questions.

  1. What do the numbers/data tell us about the purchases in each region?
  2. What form of payment is most common?
  3. Do our customers shop online?

Please submit the pivot tables that you used to answer each question together with your essay via canvas on March 17 at 11:59am.

Part Two – Analysis (5 points)

This is a written component that is designed to test your critical thinking ability.

The company’s approach has been to distribute advertising efforts equally between web banner ads and email ads, and to give equal resource levels to each area. What are the weaknesses of this approach?

Also, what changes would you suggest to their advertising plan? For example, should the company cease all advertising in the North? concentrate on web banner ads of books in the South? stop using PayPal? etc.

Present your answer in paragraph form. Be sure to include all pivot tables or other charts that you used in your decision-making process.

Your grade for Part Two of this assignment will be based on correct identification of the problem, identification of any underlying assumptions, the quality of your supporting data, and the clarity of your conclusions. Please consult Canvas for the grading rubric.

Unformatted Attachment Preview

Excel Pivot Table Rubric Part 1: Creation of Tables & Charts /2 p oi nt s Created at least 2-3 Tables & Charts that summarized the raw data assigned 0 1 Described if the tables created answered the following questions: 0 1 (a) what do the numbers tell us about the purchases in each region 0 1 (b) What form of payment is most common 0 1 (c) Do our customers shop online 0 1 (d) Do you have a title for each table e.g. Table 0 A: Analysis of regional sales or sales by region. This type of caption will enable your reader to gain a clear understanding of the purpose of each table found in your report. 0 Or A caption that contrast two charts e.g. Web vs. Email or PayPal vs. Credit card. 1 1 Part Two-Analysis Introduction: Stated the purpose of your report and how your analysis was conducted /3 points 0 1 Explained the weakness/s of the company’s 0 practice of allocating equal advertising resources to Email & Web banner ads. 1 Recommendation & Justification Explicitly recommended changes and provided justification for your suggestions. Data & Evidence 3points 0 1 Explained how your suggestions/recommendations are based upon the data and showed the evidence in form charts and tables 0 1 Conclusions Described why conclusion(s) derived from your analysis is important 2 p oi nt s 0 1 Paper clearly organized: Proper title that reflect the overall purpose of your report 0 1 Conformed to formatting instructions and length limit 1-3 pages double-spaced, Times New Roman 12 Points. Attached Pivot Tables as appendix 0 1 Conformed to standards of appropriate university 0 writing (e.g., grammar, punctuation, spelling, clarity, sentence structure, proper expression, etc.) 1 Technical Merit Submitted on time to Canvas If NO, submitted to Canvas at least 24 hours prior to class the next day TOTAL Other Comments: Yes Yes (-2 points) No No (No Credit for Assignment) /10 points MIS11 Chapter 12 Hands-on MIS Exercise Online Managment Training Inc. Transaction Log: October 28 Cust ID 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 Region East West North West South West East West West South South East North East West West West West West West North West South West West West West South East West North East South West West East South East North South West West Payment Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Source Web Web Web Email Web Email Web Web Web Web Email Web Web Web Web Web Email Web Web Web Email Web Email Web Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Web Web Web Amount $20.19 $17.85 $23.98 $23.51 $15.33 $17.30 $177.72 $21.76 $15.92 $23.39 $24.45 $20.39 $19.54 $151.67 $21.01 $22.91 $19.51 $20.16 $17.53 $17.74 $17.16 $205.58 $18.12 $20.04 $23.21 $22.79 $16.91 $20.22 $18.36 $206.80 $17.95 $18.29 $18.55 $18.82 $16.35 $16.30 $217 $16.15 $18.78 $150.99 $21.39 $16.60 1 Product Online Online Online Book Book Online Book Book Online Online Book Book Online Book Online Online Book Book Online Online Book Book Book Online Online Online Online Book Online Book Online Book Book Book Book Online Book Online Online Book Online Online Time Of Day 22:19 13:27 14:27 15:38 15:21 13:11 21:59 4:04 19:35 13:26 14:17 1:01 10:04 9:09 5:05 20:29 15:03 18:54 20:00 12:37 5:05 20:42 10:12 16:27 20:22 19:58 19:44 19:28 15:48 18:14 15:15 12:59 17:38 2:02 14:05 4:04 0:00 10:28 5:05 7:07 19:20 16:23 10043 10044 10045 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 South South West South South West West West East West North East East North West East East East West East South North North East East South South South West South West North East East South North West West North West South North East East East East North West East Paypal Credit Credit Credit Paypal Paypal Credit Paypal Paypal Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Web Web Web Web Web Email Web Web Web Web Email Web Web Web Email Web Web Web Web Web Email Email Email Email Email Web Web Email Web Web Email Email Email Web Email Web Web Web Web Email Web Web Web Web Email Web Web Email Email $23.81 $15.87 $20.82 $21.15 $19.66 $21.02 $23.13 $15.17 $209.51 $16.03 $16.17 $18.37 $15.96 $19.29 $16.49 $18.12 $18.22 $18.32 $23.77 $24.35 $20.13 $20.77 $16.98 $19.40 $23.49 $15.58 $21.94 $229.73 $16.06 $22.21 $21.58 $16.09 $16.10 $15.95 $17.77 $19.30 $21.75 $20.51 $16.14 $157.76 $21.55 $21.85 $21.70 $20.31 $23.62 $216.37 $21.99 $18.20 $17.31 2 Book Book Online Book Online Online Online Online Book Book Online Online Book Book Online Book Online Book Online Book Online Online Online Book Book Book Online Book Book Online Online Book Online Online Book Online Book Book Online Book Book Online Online Book Book Book Online Online Book 7:07 13:46 9:09 6:06 18:50 3:03 6:06 18:53 9:09 17:28 13:18 8:08 8:08 0:00 19:59 17:35 15:52 10:15 19:53 15:16 13:55 13:34 19:21 15:02 4:04 11:39 20:19 1:01 10:31 10:01 0:00 3:03 10:13 0:00 1:01 11:24 10:23 11:29 4:04 19:02 9:09 12:24 13:33 19:26 22:20 10:20 3:03 5:05 0:00 10092 10093 10094 10095 10096 10097 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 West West West North North West South West West East West North West East North North North West West East West North East East South North South East East North West West North South East West North West West South East West East South West West West East South Credit Paypal Paypal Credit Paypal Paypal Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Web Email Web Web Web Web Email Web Web Web Web Email Email Web Web Web Email Web Web Web Email Web Web Email Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Email Web Email Email Web $23.94 $174.25 $20.26 $18.73 $22.88 $19.15 $15.33 $20.82 $20.61 $16.43 $21.10 $21.64 $18.06 $19.35 $23.70 $18.93 $16.83 $22.19 $23.90 $17.47 $209.37 $18 $22.83 $20.31 $22.06 $15.22 $20.60 $18.25 $174.18 $19.58 $17.91 $22.90 $22.26 $19.04 $17.42 $18.54 $19.74 $22.03 $236.49 $19.30 $23.73 $19.96 $20.75 $22.37 $24.03 $24.59 $155.91 $16.43 $15.71 3 Book Book Online Online Book Online Book Online Online Online Online Book Book Book Online Book Book Book Book Online Book Online Book Online Online Book Online Online Book Online Book Book Book Book Online Book Online Online Book Online Online Book Online Online Online Online Book Book Book 16:08 18:31 4:04 0:00 13:09 14:44 1:01 18:01 18:29 11:23 2:02 22:40 16:00 10:06 19:02 9:09 16:20 18:52 19:40 10:53 20:11 8:08 10:17 14:34 11:07 10:39 20:46 20:42 12:42 22:31 19:14 12:16 17:50 15:23 5:05 19:30 12:49 14:49 16:24 17:00 16:57 16:50 15:02 8:08 11:14 4:04 18:38 9:09 16:44 10141 10142 10143 10144 10145 10146 10147 10148 10149 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 10188 10189 West West West West East East East East West West East West South West East North South South West South North North West East West West North East West West North North West West East South West North West West East South West South West West West West North Paypal Paypal Credit Credit Paypal Paypal Credit Credit Paypal Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Paypal Paypal Paypal Paypal Paypal Web Web Web Web Web Web Web Email Web Email Email Web Web Web Web Web Web Web Email Email Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Web Web Web Web Web Email Web Email Email Web Web Web Web Web $15.19 $21.35 $19.47 $21.49 $22.20 $21.15 $15.16 $15.71 $24.65 $24.88 $17.49 $19.71 $17.33 $15.56 $18.94 $22.86 $15.18 $22.46 $21.39 $22.17 $234.63 $24.97 $15.72 $24.35 $16.09 $23.51 $22.59 $15.59 $190.81 $21.12 $24.60 $21.22 $21.78 $16.54 $177.32 $21.50 $24.65 $19.43 $21.12 $18.10 $24.40 $19.37 $19.17 $241.77 $19.65 $19.88 $15.18 $15.08 $23.74 4 Book Online Online Online Online Online Online Book Book Book Book Online Book Online Online Book Book Book Book Online Book Book Book Book Book Book Book Online Book Book Online Online Online Online Book Book Online Online Online Online Book Book Online Book Book Book Online Book Book 16:22 17:54 18:17 9:09 12:29 7:07 11:19 9:09 20:41 15:23 21:46 7:07 2:02 21:07 20:00 16:02 6:06 17:44 17:17 10:23 9:09 22:11 10:53 8:08 8:08 16:18 16:51 9:09 21:57 16:40 20:38 12:20 7:07 17:52 15:52 10:53 20:45 9:09 20:13 20:32 13:25 21:48 0:00 9:09 20:46 8:08 12:30 12:15 5:05 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 10201 10202 10203 10204 10205 10206 10207 10208 10209 10210 10211 10212 10213 10214 10215 10216 10217 10218 10219 10220 10221 10222 10223 10224 10225 10226 10227 10228 10229 10230 10231 10232 10233 10234 10235 10236 10237 10238 North South West East West West North West West South South North South East North South South East West West East South West South North East East West West East West West West East West West West South West West North North East West North East West West West Credit Credit Credit Paypal Paypal Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Credit Paypal Credit Credit Web Web Web Email Web Web Web Web Web Web Email Email Web Web Web Web Web Web Email Web Web Web Email Email Web Web Web Web Web Email Web Web Web Email Web Email Web Web Web Web Email Web Email Web Web Web Email Email Web $19.44 $17.70 $16.99 $16.13 $24.80 $17.52 $23.63 $23.03 $21.03 $21.88 $24.86 $21.43 $16.32 $17.20 $17.87 $17.27 $19.76 $17.10 $15.66 $22.37 $15.81 $18.75 $192.41 $242.52 $20.40 $24.71 $21.49 $22.26 $22.39 $21.01 $226.15 $20.67 $21.72 $16.34 $19.19 $19.21 $16.06 $20.87 $15.33 $23.58 $15.34 $216.20 $21.85 $23.59 $20.44 $22.05 $20.42 $20.49 $161.46 5 Book Online Online Book Online Book Book Online Online Book Book Online Online Online Online Online Book Book Book Book Online Online Book Book Book Online Online Online Book Book Book Book Online Book Book Online Book Online Online Online Book Book Online Book Book Online Book Online Book 9:09 2:02 17:34 13:37 20:28 20:35 19:47 11:27 19:18 3:03 17:27 7:07 15:09 0:00 7:07 7:07 21:13 6:06 11:18 16:21 12:26 2:02 20:23 9:09 0:00 12:45 8:08 5:05 16:16 8:08 16:41 19:27 20:04 17:53 19:08 2:02 17:30 13:41 5:05 2:02 10:08 10:33 14:28 3:03 11:52 8:08 0:00 20:10 14:23 10239 10240 10241 10242 10243 10244 10245 10246 10247 10248 10249 10250 10251 10252 10253 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 South South East East West West South West West West West North South North East East West West East North South East East West South South West West West East North East North East South West West West South South West South West South South South West West West Paypal Paypal Credit Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Credit Credit Credit Paypal Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Paypal Paypal Credit Paypal Paypal Credit Credit Web Web Web Web Web Email Email Web Email Web Email Email Web Web Email Email Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Web Web Web Web Email Email Web Web Web Web Web $19.69 $24.16 $22.80 $243.70 $210.38 $161.50 $21.92 $23.75 $23.74 $21.67 $22.04 $17.83 $23.60 $19.90 $209.20 $24 $17.81 $24.77 $21 $191.43 $24.52 $17.34 $17.19 $22.55 $15.35 $23.20 $241.65 $242.40 $23.01 $17.22 $15.96 $15.45 $17.41 $21.64 $157.86 $18.17 $18.73 $17.24 $23.91 $22.12 $15.25 $24.77 $20.28 $20.33 $16.90 $16.47 $21.18 $15.86 $24.42 6 Online Book Online Book Book Book Online Online Online Book Book Online Book Book Book Book Book Online Online Book Online Online Book Book Online Book Book Book Online Online Online Online Online Book Book Online Book Book Online Book Online Book Book Online Book Book Book Book Book 4:04 2:02 10:59 20:26 12:19 16:15 6:06 20:34 3:03 12:41 3:03 12:55 2:02 14:04 17:19 11:52 12:36 0:00 17:14 16:36 21:59 8:08 3:03 11:43 10:15 15:38 20:39 17:19 17:44 1:01 1:01 9:09 5:05 10:39 5:05 16:09 20:18 20:47 13:59 17:31 19:11 0:00 6:06 8:08 21:41 16:22 15:10 18:00 1:01 10288 10289 10290 10291 10292 10293 10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 South South East West East West West East East North East East South West West West South West East South West South North South West West South East East South West West North South West North South South East West South South North West West East North East South Paypal Paypal Credit Credit Credit Credit Paypal Credit Paypal Credit Paypal Credit Credit Credit Paypal Paypal Credit Credit Credit Paypal Credit Credit Paypal Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Web Web Web Email Web Email Web Web Web Web Email Web Web Email Web Web Email Web Email Web Web Email Email Web Web Email Web Web Web Web Email Email Web Email Web Web Web Web Email Email Email Email Email Web Email Web Web Web Web $222.38 $188.85 $15.32 $24.71 $20.97 $21.92 $15.40 $23.08 $23.40 $22.65 $24.61 $24.97 $18.57 $16.15 $19.95 $15.61 $19.13 $231.23 $244.75 $21.36 $21.83 $21.58 $17.51 $23.29 $18.35 $23.06 $19.81 $162.74 $16.86 $23.31 $22.92 $22.84 $16.97 $188.16 $22.57 $24.71 $246.67 $20.97 $19.83 $19.09 $16.52 $22.31 $19.52 $24.79 $18.84 $24.58 $17.19 $19.65 $17.35 7 Book Book Book Book Book Online Book Book Online Book Book Book Book Online Book Online Book Book Book Online Book Online Book Online Book Online Online Book Online Book Book Online Online Book Online Online Book Book Book Book Book Book Online Online Online Online Book Book Book 18:53 5:05 9:09 16:22 11:17 19:17 17:16 7:07 1:01 6:06 13:08 16:53 12:45 3:03 19:35 22:02 22:55 0:00 10:13 20:25 1:01 1:01 20:19 4:04 20:54 11:48 21:19 9:09 9:09 16:23 0:00 17:37 4:04 19:21 18:45 13:34 16:47 8:08 4:04 11:45 6:06 2:02 0:00 9:09 22:04 0:00 12:19 6:06 21:37 10337 10338 10339 10340 10341 10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 West North West West West West North East West West East South East West North West West South East North South North West South North South South West West East East West East North North West West North West South East South North West West South West South West Paypal Credit Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Paypal Paypal Paypal Paypal Credit Credit Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Credit Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Web Email Web Email Web Email Web Web Web Email Email Email Web Web Email Web Web Web Web Web Email Web Email Web Web Email Web Email Web Web Web Web Web Web Web Web Web Web Web Email Web Web Email Web Web Web Web Web Web $22.92 $18.81 $20.08 $24.54 $24.81 $15.94 $18.29 $15.55 $19.20 $17.34 $22.51 $23.45 $16.15 $17.68 $22.11 $18.41 $17.08 $15.77 $22.41 $20.63 $18.14 $20.18 $177.30 $15.71 $21.75 $18.25 $203.72 $15.54 $17.50 $21.32 $150.86 $17.39 $23.87 $21.53 $19.64 $18.27 $19.27 $20.16 $15.59 $16.34 $199.18 $19.99 $18.44 $23.75 $20.88 $197.43 $20.32 $16.82 $20.16 8 Online Online Book Book Book Online Online Online Online Online Online Online Online Book Book Online Online Online Book Online Book Book Book Online Online Book Book Book Online Book Book Book Online Book Online Book Online Book Online Online Book Book Online Book Online Book Book Online Book 16:23 7:07 3:03 4:04 14:40 0:00 8:08 6:06 20:52 18:10 5:05 2:02 13:45 0:00 11:28 1:01 17:06 10:36 7:07 3:03 3:03 11:13 11:33 5:05 17:22 5:05 14:29 19:36 5:05 2:02 13:17 4:04 13:52 16:04 16:14 18:39 6:06 14:38 4:04 12:35 14:00 20:29 18:38 9:09 0:00 10:43 18:33 8:08 13:40 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 West North South North East West East South West West West West West East West West West South North North East North South West West South East North North West North North West East West South North West East North North West North West East West North North West Credit Credit Paypal Paypal Paypal Credit Paypal Paypal Credit Credit Paypal Paypal Credit Credit Credit Credit Credit Paypal Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Credit Credit Credit Credit Credit Credit Credit Paypal Credit Credit Paypal Credit Credit Paypal Paypal Credit Credit Paypal Credit Credit Paypal Web Email Email Email Web Web Web Email Email Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Email Web Email Web Web Email Web Web Web Web Web Email Email Email $16.79 $22.53 $21.68 $23.54 $17.67 $22.79 $24.80 $15.27 $18.74 $16.47 $18.11 $20.73 $21.64 $17.38 $17.70 $24.66 $24.24 $19.79 $16.86 $19.97 $22.99 $153.83 $15.20 $16.01 $18.88 $21.54 $24.11 $21.43 $24.80 $19.76 $23.97 $19.96 $18.19 $17.28 $24.84 $16.32 $23.47 $16.65 $22.64 $16.66 $21.78 $21.29 $160.78 $21.10 $169.79 $16.99 $23.64 $18.92 $23.96 9 Book Book Book Book Online Book Book Book Book Online Online Online Online Book Online Book Online Book Online Online Book Book Online Online Online Book Book Book Online Online Online Online Book Online Book Book Book Book Book Book Book Online Book Book Book Book Online Book Book 21:27 11:41 14:32 6:06 9:09 0:00 18:09 8:08 22:41 20:26 ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Attached.

Running head: EXCEL PIVOT TABLES DECISION SUPPORT

Pivot Tables Decision Support
Name of Student
Name of Institution

1

EXCEL PIVOT TABLES DECISION SUPPORT
Part One - Basic Pivot Tables
What do the numbers/data tell us about the purchases in each region?

Fig: Pivot table showing average purchases in each region

2

EXCEL PIVOT TABLES DECISION SUPPORT
The average amount of purchases in the West region stands at $38.08 while the average
amount of purchases in the East region stands at $41.86. On the other hand, the average amount
of purchases in the South regions is $42.94, while that of North averages ate $32.48.

What form of payment is most common?

Fig: number of customers shopping online

3

EXCEL PIVOT TABLES DECISION SUPPORT

4

Credit cards are the most commonly used form of payment with 322 transa...

Purdue University

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
I did not know how to approach this question, Studypool helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4