Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Build a pivot table which calculates the average and maximum sales by department You will have to combine the data using VLOOKUP or MATCH/INDEX. Note
Build a pivot table which calculates the average and maximum sales by department
You will have to combine the data using VLOOKUP or MATCH/INDEX. Note any observations you see regarding trends in the results.
Use the data below to solve the problem. List steps and directions step by step with any formulas, what has been clicked on, and any other important information to solve the problem using Excel. Thank you.
| Sales Data | ||
| Loyalty ID # | Sale Total | Department |
| 1391 | $ 514.72 | Clothing |
| 1804 | $ 109.85 | Housing |
| 1473 | $ 328.42 | Housing |
| 1847 | $ 124.78 | Athletic |
| 1586 | $ 79.84 | Other |
| 1243 | $ 147.32 | Luggage |
| 1117 | $ 235.15 | Clothing |
| 1995 | $ 89.20 | Hardware |
| 1591 | $ 38.53 | Luggage |
| 1919 | $ 53.63 | Hardware |
| 1957 | $ 273.65 | Other |
| 1397 | $ 58.50 | Athletic |
| 1118 | $ 184.85 | Luggage |
| 1354 | $ 104.02 | Athletic |
| 1414 | $ 36.25 | Other |
| 1714 | $ 263.19 | Clothing |
| 1826 | $ 75.42 | Athletic |
| 1591 | $ 200.31 | Hardware |
| 1387 | $ 71.77 | Other |
| 1147 | $ 225.76 | Other |
| 1298 | $ 168.35 | Athletic |
| 1045 | $ 41.81 | Clothing |
| 1022 | $ 66.31 | Other |
| 1290 | $ 12.87 | Other |
| 1059 | $ 309.17 | Athletic |
| 1522 | $ 64.22 | Other |
| 1533 | $ 210.60 | Hardware |
| 1266 | $ 286.38 | Clothing |
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