Provide a visual representation of the volume of sales for all variants across all weeks. Also provide the summary statistic of the sales volume of each of the variants. The summary statistics should contain a measures of representative sales and measures of spread. (10) Hint: Line charts with sales trajectories of all product variants should be presented separately. The summary statistics should provide the mean, median, standard deviation, min and max of the sales values for each of the 13 variants. b. Identify the top 4 selling variants among the 13 in the data. Explain your answer and illustrate your answer using a pie chart. (10) .
AutoSave OFF A ? " C ... Individual report data (3).xIsx - Group Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments Share Calibri (Body) 11 AA D Wrap Text v General Paste BIUV A J V Merge & Centre v 508 Conditional Format Cell Insert Delete Format Sort & Find & Analyse Formatting as Table Styles Filter Select Data R10 X V fx D G M N Q Weeks Variant 1 Sales Volume Variant 2 Variant 3 Variant 4 Variant 5 Variant Variant 8 358336.81 174545.94 Variant 7 Variant 9 Variant 10 38914.38 Variant 1 1 9611.87 Variant 12 53858.81 Variant 13 22131.2 50029.65 366630.87 67909.7 40672.97 83790.88 153163.85 21187.5. 8175.71 57484.51 8589.04 22998.11 38578.4 850.45 357282.91 74148.04 54303.25 7742.58 198721.17 170770.46 39079.43 28201.1 8767.03 8402.53 781.14 407163.85 217760.93 44821.68 99840.32 183134.87 155469.5 8190.49 8596.86 878.03 1 1955.44 37219.77 23131.68 45613.72 387225.9 218480.28 189402.92 89358.64 162645.6 17577.0 8352.36 827.93 10969.62 32636.61 321516.97 17330.27 160741.61 68185.13 79199.78 8981.05 168745.7 143560.5 15995.8 23858.28 886.83 13252.9 35449.59 8302.5 350335.72 160775.3 60111.01 69704.54 8168.07 136951.47 14402.9 20491.85 8502 .5 16520.96 918.43 45225.59 381877.95 170462.79 190224.7 164872.57 59737.2 8821.95 16110.36 40236.19 40453.45 8407.09 834.69 21214 334165.11 53532.03 56101.34 365.66 211415.16 184367.4 8109.56 16468.2 8044.0 894.11 2332.6 1264.21 337385.65 180633.08 148836.25 57020.08 14405.79 46053.27 9036.33 8339.62 867.5 10720.71 48861.42 34164.51 384001.25 142244.71 188549.4 $5394.21 9990.17 164190.01 15075.68 912 10981.95 8371.72 29746.5 36131.78 317641.4 116473.02 42689.96 210299.18 6106.28 41756.59 20881.0 9729.1 1 1093.79 847.3 22007.7 34575.29 305531.32 107701.3 01168.38 39294.89 173551.09 18823 .6 6682.82 7999.21 794.47 7527.34 20827.7 33368.55 300607.5 100590.15 41484.56 197830.01 4498.86 167783.32 6170.04 31105.62 21298.72 8054.76 693.23 299077.64 331.0 99255.2 38544.02 4219.63 200017.4 175314.75 4531.26 16008.32 8139.86 554.49 22019.85 29940.53 276408.09 199822.35 176253.52 31752.24 15662.7 83408.94 2994.35 7321.0 3818.86 318413.26 26301.01 18913.84 25929.65 585.02 76989.89 192999.15 3637.48 169571.91 15149.71 7697.98 579.55 3914.65 18886 284511.59 24250.74 78388.6 24423.15 241423.37 216007.03 16091.4 2782.29 3552.01 14145 .8 8 3485.27 943.86 284575.56 68353.76 206123 20526.11 180094.28 17104 .6 2766.42 8013.1 910.86 3269.3 12494.67 286035.29 29297.24 5999.89 16825.46 2137.11 322.12 12809.14 216221.79 192390.4 15524.6 676.09 26406.06 7630.6 328282.39 67253.4 15215.7 220035.4 1380.71 197242.9 7545.6 19623.2 14865.42 7309.55 617.5 23488.15 324792.75 261028.95 63859 15437.91 237085.63 1997.64 5530.43 7648.17 764.72 6441.9 23342.01 16639.54 67062.86 11316.38 632.86 260933.75 233032.43 18652.37 8539.97 708.98 342021.21 14152.17 74485.68 9855.32 63464.62 751.72 1668.78 236278.5 3179.4 43964.17 15817.93 373017.86 792.87 13307.29 67535.53 236428.87 1619.44 21458.08 9022 .8 2792.85 58942.75 378303.11 1130.54 111627.64 40953.16 85224.99 625.76 22410.25 2652.05 2174.96 252682.27 8154.55 27692.92 9347.9 784.49 101596.21 66675.47 161613.98 236264.29 71331.96 2948.24 1073.29 21086.61 8640.69 4856.1 51404.37 362824.17 239982.23 683-88 144129.43 72664.71 1063.77 211226.11 690.24 25561.68 19282.96 8737.7 735.37 353502.52 44149.03 138365 .18 77003.45 1009.83 218694.73 18470.19 190319.4 473.49 18789.87 8781.23 76133.43 $1408.22 215137.34 804.2 141266.35 83181.61 185274.49 1 143.03 20435.97 8559.4 575.77 16022.22 40343.72 867.42 334856.82 1 10005.43 63822.88 234867.08 203002.75 21218.9 513.28 13820.89 30963.32 9660.99 984.43 885.05 310152.9 89975.28 $2972. 20229.9 643.22 191.71 10326.1 224851.39 25043.28 194254.82 9057.2 1309.41 798.58 362124.9 112134.58 220177.64 185180.7 22901.5 56294.97 10779.97 1050.7 219.48 42799.25 1315.4 363517.75 8039.79 3730.39 129035.96 249990.32 67334.06 196873.4: 235.88 43192.98 383.05 9097.98 825.94 381385.87 177118.76 9659.12 94140.52 46807.52 4616.33 234481.83 343.17 214.41 5843.52 71377.25 185670.2 40380.65 7813.4 617.57 371487.06 5199.88 183811.16 204267.11 165319.4 32490.2 109833.68 3896.79 159.83 $765.0 3980.25 60782.61 692.37 5157.99 318665.85 154958.19 87675.89 148911.68 97175.51 33522.99 403.64 $38.02 4421.36 819.86 344543.68 4091.93 161619.82 102024.26 48046.66 4902.42 163707.66 339.93 209.57 132821.1 26698.4 3152.9 1035.2 5455.25 49289.42 4301.38 342223.98 137891.93 84185.02 82923.86 26711.5 403.46 148.9 152906.4 2308.82 997.06 296050.09 2117.42 4274.27 114660.79 46762.86 72176.75 204332.04 174392.9 27127.17 2064.42 747.52 120.01 333673.03 948.38 37652.88 119665.44 71078.22 3481.31 246.35 181389.3 163.03 154292.77 24687.2 1429.81 1759.56 43141.88 979.5 3276.39 352507.0 214007.59 183831.05 136176. $7590.97 274.56 1086.75 140.45 34520.31 41135.43 802.71 407128.5 2514.38 171553.3 57809.91 LEE917 188636.8 745.09 360.01 34.75 68557.38 1026.67 42216.71 345227.2 2574.53 51483.42 43181.23 235575.2 207641.2 281.44 26210.16 983.06 52.85 55451.64 740.77 318928.1 9805.97 2710.29 120173.38 193743.78 36835.03 212.33 168321.9 24020.38 671.04 259.96 298483.25 49193.98 31705.36 1966.72 730.45 12262.43 31326.77 198754.7 111.66 173634.3 23504.7 115.25 847.11 768.55 41600.2 326155.05 115731.89 2405.09 186220.82 31668.58 162310.47 155.42 43805.36 22626.12 130.2 38310.75 802.05 1661.59 298220.46 101777.04 29332.8 210423.16 184910.99 24027.09 600.72 207.63 73.07 36313.36 34405.65 884.36 335483.68 444.47 16297.36 27691.9 131.21 196443.42 172140.9 23124.39 408.53 769.51 84.51 47638.9 39496.1 1254.75 348269.95 126501.17 219186.32 194420.4 23788.3 37161.89 248.08 275.4 64.64 36022.89 996.23 729.45 352969.78 148754.79 $1980.12 21768.78 63737.6 197401.5 58.62 23410.49 225.29 15.6 33274.91 50833 . 12 731.48 353097.67 69061.23 834.94 204214.9 153178.52 49.27 177892.83 25267.4 205.03 849.72 31.57 31860.88 51328 .18 847.39 199919.15 171452.16 27101.6 331.83 1033.56 Weekly Sales Unit Price Distribution + Ready Accessibility: Good to go 75%
