Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide logical business questions that can be asked about the Data set above. How would you rearrange this pivot table for ordering columns and
Please provide logical business questions that can be asked about the Data set above. How would you rearrange this pivot table for ordering columns and rows to answer those questions about the data set you came up with. Please describe with maximum detail and please indicate any excel function to elaborate your explanations.
G E Sales 32098 F Profit Region 1926 W 65987 23091 7821 Product ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL 83017 45678 35009 58113 99867 4530 MNO City 2 Los Angeles 3 Los Angeles 4 Los Angeles 5 Los Angeles 6 Los Angeles 7 Los Angeles 8 Los Angeles 9 Los Angeles 10 Los Angeles 11 Los Angeles 12 Los Angeles 13 Los Angeles 14 Los Angeles 15 Los Angeles 16 Los Angeles 17 Los Angeles 18 Los Angeles 19 Los Angeles 20 Los Angeles 21 Los Angeles 22 Los Angeles 23 Los Angeles 24 Los Angeles 25 Los Angeles 26 Los Angeles 27 Los Angeles 28 Los Angeles 29 Los Angeles 30 Los Angeles 31 Los Angeles 32 Los Angeles 33 Los Angeles PQR ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 56023 6748 9821 58342 46009 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 77864 6745 6599 4156 -156 9132 9136 -1050 9298 1997 408 2241 1350 187 5251 4601 4173 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 7361 9344 607 DEF GHI JKL MNO PQR ABC DEF G E Sales 32098 F Profit Region 1926 W 65987 23091 7821 Product ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL 83017 45678 35009 58113 99867 4530 MNO City 2 Los Angeles 3 Los Angeles 4 Los Angeles 5 Los Angeles 6 Los Angeles 7 Los Angeles 8 Los Angeles 9 Los Angeles 10 Los Angeles 11 Los Angeles 12 Los Angeles 13 Los Angeles 14 Los Angeles 15 Los Angeles 16 Los Angeles 17 Los Angeles 18 Los Angeles 19 Los Angeles 20 Los Angeles 21 Los Angeles 22 Los Angeles 23 Los Angeles 24 Los Angeles 25 Los Angeles 26 Los Angeles 27 Los Angeles 28 Los Angeles 29 Los Angeles 30 Los Angeles 31 Los Angeles 32 Los Angeles 33 Los Angeles PQR ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 56023 6748 9821 58342 46009 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 77864 6745 6599 4156 -156 9132 9136 -1050 9298 1997 408 2241 1350 187 5251 4601 4173 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 7361 9344 607 DEF GHI JKL MNO PQR ABC DEFStep 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