Please help me answer this Business Analytics question below:

R10 viXVfx S B C D E F G H K L M N 41 411 438 359 420 403 631 778 358 398 378 555 282 374 42 415 431 354 460 485 634 781 365 408 388 550 294 375 43 412 432 345 439 472 582 767 343 404 385 541 298 371 44 414 468 348 445 458 578 747 358 392 373 545 291 374 45 418 488 350 443 611 582 747 354 387 368 547 296 379 46 433 510 350 443 601 585 752 346 397 376 554 310 377 47 423 506 351 417 328 587 786 350 392 373 547 288 376 48 428 516 352 472 392 592 768 319 397 378 542 275 376 49 423 522 357 403 285 588 770 345 391 372 549 252 378 50 423 520 357 540 557 589 777 344 393 373 550 298 375 51 417 528 360 532 580 577 745 347 384 364 550 329 377 52 412 503 333 476 648 573 739 357 382 362 557 328 378 53 412 472 348 380 664 580 757 349 384 362 547 288 377 54 412 471 353 411 880 581 765 339 383 357 551 300 377P14 v x \\/ g 1 A B C D E G H | K M N 1 Weekly Distribution 2 Weeks Variant 1 Variant 2 Variant 3 Variant 4 Variant 5 Variant 6 Variant 7 Variant 8 Variant 9 Variant 10 Variant 11 Variant 12 Variant 13 3 1 53.5 20.6 10 2.6 7.6 7.9 6.5 0 51.8 36.5 17.3 23.9 9.7 4 2 54.6 20.9 10 2.5 7.8 8.1 6.1 0 52.4 36.7 16.9 24.2 9.2 5 3 55.8 22 12 2.8 7.4 7.4 7.9 0 53.8 36.9 16.6 25.2 10.3 6 4 53.2 21.8 13.6 2.6 6.5 6.7 7.6 0 51 35.1 15.6 23.4 8.9 7 5 53.7 20.7 13.3 2.8 5.9 5.7 7.8 0 51.8 35.8 15.4 23.6 9.8 8 6 54.6 20.7 12.9 2.8 5.4 5.6 7.4 0 52 34.5 14.9 24.8 10.5 9 7 54.6 21.3 12.4 2.8 4.9 6.3 7.8 0 51.8 36.1 15.8 22.5 9.3 10 8 53.2 21.4 12.2 2.9 4.1 8.5 7.6 0 50.9 35.4 16.4 22.1 9.9 11 9 53.8 20.8 11.2 2.5 3.8 9.1 7.2 0 51.1 34.9 14.2 24.1 9.9 12 10 54.7 19.7 10.3 2.5 3.6 7.4 6.9 0 52.5 35.8 15.5 24.1 10 1; 11 54.8 19.1 9.6 2.7 3.2 7.8 6.3 0 53.2 37.2 17.8 24.7 8.8 14 12 53.7 19.1 9 2.4 2.7 7.7 6.4 0 51.6 35.8 17.7 23.4 9.8 15 13 50.7 17.4 8.4 2.4 2.3 6.6 5.6 0 49 35.7 17 22.5 8.3 16 14 53.8 17.9 8.7 2.3 2 6.9 5.4 0 52.2 36.9 16.3 24.8 7.3 17 15 49.9 16.9 8.4 2.2 1.8 6.1 5.3 0 48.3 36.7 16.4 21.1 7 18 16 52.5 16.4 7.7 1.9 2 6.4 4.9 0 50.7 37.4 16 23 7.1 19 17 53.4 16.1 7.6 2 1.7 5.8 4.7 0 52 37.8 16.5 23.6 9.6 20 18 53.1 15.3 7.2 2 1.6 5.7 4 0 51.7 37.8 17.2 23.3 9.9 P14 V XVfx A B C D E F G H L 21 19 53.1 K 14.2 L 6.3 M 1.9 N 1.3 5 4.2 22 0 20 52 52.3 38.9 13.1 16.3 5.8 22.6 1.3 8.9 1.3 4.6 4 23 0 21 51.4 54 39.7 13.7 16.7 5.6 21.3 1.2 7.3 1.3 5.4 3.6 24 0 52.6 22 40.3 53 15.9 12.7 23.2 5.2 1.4 9.1 5.4 3.1 O 25 23 52.1 52.4 38.4 13.4 17.2 4 23.7 1.4 8.3 0.9 7.2 2.8 26 0 24 51.2 54.9 39.2 14.1 16.8 4.3 22.7 1.5 8.8 0.8 7.9 2.7 27 0 53.5 25 54.4 40.1 13.2 18.2 3.7 24.5 1.4 7.5 0.8 7.9 2.5 28 0 26 53.4 52.4 39.7 15.1 18.1 6.3 24.7 1.1 9.1 0.7 7.3 4.1 29 0 51.3 27 52.7 38.3 16.6 18.3 22.7 8.5 1 7.9 0.5 5.7 5.8 30 0 28 51.8 53.4 38.7 17.1 17.3 9.4 23.3 1.4 0.4 7.7 6 6.3 O 31 29 53.7 52.3 38 17 17.2 10.3 24.3 1.1 8 0.4 5.3 6.4 32 0 30 51.9 52.2 16.3 37.7 17.9 10.2 24 1.1 8.9 0.5 4.7 5.8 33 0 50.5 31 50.9 37.4 17.8 15.5 24.6 9.6 0.7 9.1 0.5 4.2 6 34 0 49.6 32 36.9 52 15.1 18.3 9.3 21.6 0.6 10.3 0.2 3.5 6.2 0.9 35 33 50.8 51.5 36.9 17.1 17.7 9.2 25.3 0.7 10.8 0.1 3.1 9.1 36 3.3 34 50.3 52.1 17.7 37.2 19 10 22.6 0.7 8.1 0.2 3.2 10.2 37 3.9 35 50.7 50.3 37.6 19.6 18.5 12.4 21.5 0.6 6.2 0.2 2.6 11.5 4.3 38 48.7 36 54.1 35.3 19.3 22.9 12.7 17.2 0.4 7.6 0.2 2.2 11.8 4.5 39 37 52.3 52.1 36.5 25.2 19.3 13.3 14.1 0.4 9.6 0.1 1.7 11 40 4.2 38 50.5 53.3 34.8 20 25.5 13.4 10.8 0.4 11.1 0.2 1.4 11.5 4.3 51.5 34.6 27.6 9.5 11.1\fB C D E G H K M N Sales Volume Weeks Variant 1 Variant 2 Variant 3 Variant 4 Variant 5 Variant 6 Variant 7 Variant 8 Variant 9 Variant 10 Variant 11 Variant 12 Variant 13 W N 358336.81 174545.94 38914.38 9611.87 53858.81 22131.23 50029.65 0 183790.88 153163.85 21187.54 8589.04 850.45 366630.87 167909.7 40672.97 8175.71 57484.51 22998.11 38578.4 O 198721.17 170770.46 18767.03 8402.53 781.14 357282.91 174148.04 54303.25 7742.58 39079.43 28201.1 44821.68 183134.87 155469.5 18190.49 8596.86 878.03 w I 6 407163.85 217760.93 99840.32 11955.44 37219.77 23131.68 45613.72 189402.92 162645.62 17577.02 8352.36 827.93 387225.99 218480.28 89358.64 10969.62 32636.61 17330.27 68185.13 0 168745.72 143560.5 15995.8 8302.59 886.83 8 6 321516.97 160741.61 79199.78 8981.05 23858.28 13252.9 35449.59 160775.36 136951.47 14402.9 8502.57 918.43 9 350335.72 160111.01 69704.54 8168.07 20491.85 16520.96 45225.59 190224.7 164872.57 16110.36 8407.09 834.69 10 8 381877.95 170462.79 59737.2 8821.95 21214 40236.19 40453.45 211415.16 184367.44 18109.56 8044.06 894.11 11 9 334165.11 153532.03 56101.34 7365.66 16468.2 32332.63 41264.21 180633.08 157020.08 14405.79 8339.62 867.59 12 10 337385.65 148836.25 46053.27 9036.33 10720.71 48861.42 34164.51 188549.4 164190.01 15075.68 8371.72 912 13 11 384001.29 142244.71 55394.21 9990.17 10981.95 29746.59 36131.78 241756.59 210299.18 20881.01 9729.1 847.3 14 12 317641.4 116473.02 42689.96 6106.28 11093.79 22007.7 34575.29 201168.38 173551.09 18823.6 7999.21 794.47 15 13 305531.32 107701.3 39294.89 6682.82 7527.34 20827.7 33368.55 197830.01 167783.32 21298.72 8054.76 693.23 16 14 300607.57 100590.15 41484.56 4498.86 6170.04 17331.07 31105.62 200017.41 175314.75 16008.32 8139.86 554.49 17 15 299077.64 99255.29 38544.02 4219.63 4531.26 22019.85 29940.53 199822.35 176253.52 15662.75 7321.06 585.02 18 16 276408.09 83408.94 31752.24 2994.35 3818.86 18913.84 25929.65 192999.15 169571.91 15149.71 7697.98 579.55 o o o o o o o o o o o o o o O O O O O O O O 19 17 318413.26 76989.89 26301.01 3637.48 3914.65 18886 24250.74 241423.37 216007.03 16091.41 8381.07 943.86 20 18 284511.59 78388.6 24423.15 2782.29 3552.01 14145.88 33485.27 206123 180094.28 17104.67 8013.18 910.86 21 19 284575.56 68353.76 20526.11 2766.42 3269.33 12494.67 29297.24 216221.79 192390.49 15524.6 7630.61 676.09 22 20 286035.29 65999.89 16825.46 2137.11 7822.12 12809.14 26406.06 220035.4 197242.9 14865.42 7309.55 617.52 23 21 328282.39 67253.44 15215.7 1380.71 7545.68 19623.2 23488.15 261028.95 237085.63 15530.43 7648.17 764.72 24 22 324792.75 63859 15437.91 1997.64 6441.9 23342.01 16639.54 260933.75 233032.43 18652.37 8539.97 708.98 25 23 330527.48 67062.86 11316.38 1632.86 4111.03 35850.43 14152.17 263464.62 236278.55 18238.64 8195.71 751.72 26 24 342021.21 74485.68 9855.32 1668.78 3179.48 43964.17 15817.93 267535.53 236428.87 21458.08 9022.81 625.76 27 25 373017.86 87792.87 13307.29 1619.44 2792.85 58942.75 11130.54 285224.99 252682.27 22410.25 9347.98 784.49 28 26 378303.11 111627.64 40953.16 2652.05 2174.96 38154.55 27692.92 266675.47 236264.29 21086.61 8640.69 683.88 29 27 401596.21 161613.98 71331.96 2948.24 1073.29 34856.12 51404.37 239982.23 211226.11 19282.96 8737.78 735.37 28 362824.17 144129.43 72664.71 1063.77 690.24 25561.68 44149.03 218694.73 190319.44 18789.87 8781.23 804.2P43 viXVfx SSSS A B D E F G H K M N 31 29 353502.52 138365.18 77003.45 1009.83 473.49 18470.19 41408.22 0 215137.34 185274.49 20435.97 8559.46 867.42 30 376133.43 141266.35 83181.61 1143.03 575.77 16022.22 40343.72 O 234867.08 203002.75 21218.91 9660.99 984.43 33 31 334856.82 110005.43 63822.88 885.05 513.28 13820.89 30963.32 224851.39 194254.82 20229.93 9057.23 1309.41 34 32 310152.92 89975.28 52972.4 643.22 191.71 10326.1 25043.28 798.58 220177.64 185180.71 22901.56 10779.97 1315.4 35 33 362124.9 112134.58 56294.97 1050.7 219.48 8039.79 42799.25 3730.39 249990.32 196873.43 43192.98 9097.98 825.94 36 34 363517.79 129035.96 67334.06 383.05 235.88 9659.12 46807.52 4616.33 234481.83 185670.2 40380.65 7813.41 617.57 37 35 381385.87 177118.76 94140.52 343.17 214.41 5843.52 71377.25 5199.88 204267.11 165319.41 32490.24 5765.09 692.37 38 36 371487.06 183811.16 109833.68 3896.79 159.83 3980.25 60782.61 5157.99 187675.89 148911.68 33522.99 4421.36 819.86 39 37 318665.85 154958.19 97175.51 403.64 338.02 4091.93 48046.66 4902.42 163707.66 132821.1 26698.46 3152.9 1035.2 40 38 344543.68 161619.82 102024.26 339.93 209.57 5455.25 49289.42 4301.38 182923.86 152906.4 26711.57 2308.82 997.06 41 39 342223.98 137891.93 84185.02 403.46 148.9 2117.42 46762.86 4274.27 204332.04 174392.93 27127.17 2064.42 747.52 42 40 296050.09 114660.79 72176.75 281.46 120.01 948.38 37652.88 3481.31 181389.3 154292.77 24687.22 1429.81 979.5 43 41 333673.03 119665.44 71078.22 246.35 163.03 1759.56 43141.88 3276.39 214007.59 183831.05 28287.08 1086.75 802.71 44 42 352507.09 136176.1 57590.97 274.56 140.45 34520.31 41135.43 2514.38 216331 188636.86 25922.38 1026.67 745.09 45 43 407128.5 171553.3 57809.91 360.01 34.75 68557.38 42216.71 2574.53 235575.2 207641.21 26210.16 983.06 740.77 46 44 345227.2 151483.42 43181.23 281.44 52.85 55451.64 49805.97 2710.29 193743.78 168321.91 24020.38 671.04 730.45 47 318928.11 120173.38 36835.03 212.33 259.96 49193.98 31705.36 1966.72 198754.73 173634.3 23504.76 847.11 768.55 48 46 298483.25 112262.43 31326.77 111.66 115.25 41600.2 36703.46 2405.09 186220.82 162310.47 22626.12 482.18 802.05 49 47 326155.05 115731.89 31668.58 155.42 130.2 43805.36 38310.75 1661.59 210423.16 184910.99 24027.09 600.72 884.36 50 48 298220.46 101777.04 29332.87 207.63 73.07 36313.36 34405.65 1444.47 196443.42 172140.99 23124.39 408.53 769.51 51 49 335483.68 116297.36 27691.9 131.21 84.51 47638.9 39496.1 1254.75 219186.32 194420.49 23788.3 248.08 729.45 52 50 348269.95 126501.17 37161.89 275.4 64.64 36022.89 51980.12 996.23 221768.78 197401.51 23410.49 225.29 731.48 53 51 352969.78 148754.79 63737.6 58.62 15.6 33274.91 50833.12 834.94 204214.99 177892.83 25267.41 205.03 849.72 54 52 353097.67 153178.52 69061.23 49.27 31.57 31860.88 51328.18 847.39 199919.15 171452.16 27101.6 331.83 1033.56R10 v x \\/ j} E C D E F G H | J K L M N 1 Weekly Unit Price 2 Variant 1 Variant 2 Variant 3 Variant 4 Variant 5 Variant 6 Variant 7 Variant 8 Variant 9 Variant 10 Variant 11 Variant 12 Variant 13 3 440 530 371 398 543 657 787 0 394 375 643 329 376 4 428 516 370 405 536 649 789 0 387 371 651 329 378 5 432 509 374 409 545 606 81 9 0 389 372 662 330 377 6 414 460 359 406 540 613 833 0 380 361 668 328 377 7 431 487 368 403 536 636 81 1 0 387 369 680 329 376 8 414 460 365 409 539 647 835 0 384 368 682 322 377 9_ 417 485 372 416 537 637 821 0 382 366 669 330 378 11 422 505 373 41 3 526 637 826 0 381 364 663 331 379 1 1 427 505 370 41 3 531 641 820 0 387 372 698 328 377 1 2 427 508 372 378 544 605 822 0 389 373 709 329 378 1 3 424 497 374 385 558 643 824 0 397 379 722 330 378 14 426 512 376 390 532 663 821 0 396 375 725 330 378 15 428 510 369 407 548 657 815 0 401 377 719 330 378 16 416 499 365 413 560 660 817 0 390 373 725 327 376 17 420 510 366 416 569 639 843 0 393 376 723 324 376 18 418 516 370 418 562 639 839 0 393 377 712 325 377 19 406 531 373 427 571 643 847 0 382 367 719 328 375 20 422 547 373 432 568 652 808 0 395 378 715 326 378 R10 V : XVfx B C D E F G H 21 J 418 K 550 369 L M 434 N 565 654 813 22 394 414 379 559 726 378 328 438 378 504 647 818 23 403 390 559 375 729 379 451 328 376 507 616 808 24 382 407 368 539 722 362 433 327 377 507 623 815 25 389 402 559 373 712 360 329 462 378 521 604 828 26 381 408 365 578 704 371 329 454 377 544 605 816 27 407 383 366 549 682 346 424 330 378 532 597 832 28 407 384 501 366 700 360 330 370 376 505 603 805 29 383 413 365 486 710 370 oooo oo oo 330 359 377 525 595 758 30 384 411 472 365 720 369 328 437 378 563 589 761 31 410 387 367 465 718 367 330 432 566 379 594 792 32 406 387 368 457 683 369 447 329 376 566 599 782 33 401 387 367 458 705 364 327 469 376 591 614 793 0 34 399 382 364 459 679 370 325 498 367 593 606 802 35 334 383 396 366 480 653 365 312 407 360 573 616 800 36 375 393 371 360 457 470 346 299 480 355 567 599 797 37 372 369 409 358 460 468 360 302 467 362 575 604 770 38 369 378 409 359 441 534 365 284 293 360 584 609 785 363 39 386 413 366 438 521 363 285 441 366 573 614 796 40 357 405 396 430 372 558 356 377 304 470 369 550 785 361 390 367 552 293 372Your entire submission should be no more than 1,500 words, excluding references, tables, and figures. The attached data set is an Excel file with three spreadsheets (Sales data.xIsx). The Excel file contains sales, pricing and distribution figures of the different variants of a particular product for a full year. The spreadsheets each contain different data, as described as below: a. Weekly Sales (Spreadsheet 1). This contains weekly sales figures for 13 different variants of the same product from a particular supermarket chain. There are total 52 weeks of data, that is, one full year of sales. The sales figures are in number of units sold. b. Unit Price (Spreadsheet 2). This contains the average unit price charged per variant per week for all 13 variants. The figures are in average prices in pence. So a 100 implies fl. c. Distribution (Spreadsheet 3). This contains the percentage of stores of the supermarket chain that stored each product variant in its shelves per week. A 100 for a particular variant for a given week meant that this supermarket listed this product on its shelves in all its stores that week. Use this data set to answer the following questions. You are free to use any statistical software of your choice. Whichever software you use, its name and version should be clearly indicated at the beginning of your report. All figures and tables need to be clearly labelled. Please note that some marks are allocated for visual clarity and ease of interpretation of the tables and figures.Question 1 (20) a. 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 ofthc l3 variants. Identify the top 4 selling variants among the 13 in the data. Explain your answer and illustrate your answer using a pie chart. {10) Question 2 (40) Provide a correlation table indicating overall relationships between the various prices. (10) Can you identify those variants, whose prices match each other relatively closely. Explain using the correlation table. Please propose methods for detecting and solving multicollinearity (10) Conduct an exploratory factor analysis of distribution variants and generate an aggregated index. Please present results in tables. (20) Question 3 (40) :1. Using the multivariate regression methodology, can you identify which price; directly affect the sales of Variant 2? (20) b. Interpret the regression results and discuss the model explanation power (20)