Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me answer 1-5. Thank you Hi Columns Show Me Rows AGG(Sale Year SUM(Net inc AGG(Return AGG(Assets ACG Profit Right of Retum-Variable SUMAR SUMNet

please help me answer 1-5. Thank you
image text in transcribed
image text in transcribed
Hi Columns Show Me Rows AGG(Sale Year SUM(Net inc AGG(Return AGG(Assets ACG Profit Right of Retum-Variable SUMAR SUMNet sa SUMEL Return on Company NI A Retail B Retail . Sales Retur.. Year 14.93% 2021 12.64% 2018 11.95% 2019 10.7394 2017 10.5796 2020 9.60% 2016 9.38% 2021 9.10% 2015 9.06% 2012 9.02% 2014 8.45% 2018 8.37% 2019 8.3394 2020 8.0296 2013 7.73% 7.39% 2014 7.52% 2015 7.33% 2017 7.00% 2016 6.30% 2012 Null Null 4.22% 6.46% 5.59% 6.18% 6.53% 6.47% 6.95% 4,59% 7.43% 4,02% 8.53% 10.09% 9,65% Assets Tur Profit Marg Less Sales returns Sales teve Net of returns 4229 4.22% 47.930.43464 320,982 273,051.56536 6.46% 6.46% 43.5068128 344.188 3006811872 5.59% 5.59% 19,182.01018 327.851 288,698.98932 6.18% 6.18% -36.96649864 344.654 307,687.50136 6.53% 6.53% -43.279.4496 415,012 371.132 3501 6.47% 6.47% -34.220.70792 356.546 332.325 29208 6.95% 6.95% -41,860 446,296 404,436 4.59% 4.59% 32,051,56828 352,340 320.288.43172 7.43% 7.43% -30,981.20658 341,836 310,85479342 4,02% -32,046 56272 355.163 323.116.43728 8.53% 8.53% 41,057 485.992 444,935 10.09% 10.09% -40,105 479,084 438.976 9,65% 9.6596 -32,332 627955 575,623 8.67% 8.67% -28,77643619 358.90 330,131,56361 7.57% 7.57% 438R3 567,419 521.536 8.34% 8.34% -43,883 578 167 534,284 8.10% 8.10% -42.100 560,083 517,979 8.30% 8.30% 37,728 514,401 476,673 8.68% 8.68% -38,095 544,518 506.433 7.35% 7.38% -36,099 572,852 536,753 Null Null Null Nell HABIBBIES 8.67% 2013 7.5796 8.34% 8.10% 8.3046 8.68% 7.38% Null . Nuti Please answer the following questions. 1. Which company exhibited a more favorable sales returns percentage in 2021, Retail A or Retail B? What percentage of that company's customer purchases were returned? 2. During the period 2015-2021, which company did show a higher growth in sales? 3. During the period 2015-2021, did Retail A's sales return percentage become (a) more favorable or (b) less favorable? 4. During the period 2015-2021, did Retail B's sales return percentage become (a) more favorable or (b) less favorable? 5. Which company exhibited a more favorable sales returns percentage in 2012. Retail A or Retail B? What percent of that company's customer purchases were returned? 6. When you drag company to "Color" on the "Marks" card (at Tableau direction 5), what does happen? 7. Explain what happens when you change to "Discrete data type" (at Tableau direction 2) To answer these questions, you may want to draw charts using Tableau as follows: The following is a nart of the

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel For Accountants Tips, Tricks & Techniques

Authors: Conrad Carlberg

1st Edition

1932925015, 9781932925012

More Books

Students also viewed these Accounting questions

Question

When do I give in to my bad habit?

Answered: 1 week ago