Solve clearly

Problem # 1. Enter the following table of sales data (i.e., units sold) by product in the spreadsheet. (8) Week Pepsi Diet Pepsi Cherry Pepsi Mountain Dew 985,000 654.000 225,600 387,900 888,863 657,200 325,000 410,900 934.900 643,980 299,756 402,385 866,500 610,900 302,888 395,654 923,800 598.459 304,380 402,000 943,238 633,800 285,690 406,900 995,082 632,900 309.684 411,873 867,000 586.941 278.651 378,451 A. Calculate the sum, mean and median sales for each soft drink over the eight-week period. B. Calculate the sum, mean and median sales for each week over the eight-week period.K14 fx A B C D E F G H 1 Week Pepsi Diet Pepsi Cherry Pepsi Mountain Dew Sum Mean Median 2 1 985000 654000 225600 387900 2252500 563125 2 888863 657200 325000 410900 2281963 570490.8 A 3 934900 643980 299756 402385 2281021 570255.3 5 4 866500 610900 302888 395654 2175942 543985.5 5 923800 598459 304380 402000 2228639 557159.8 7 6 943238 633800 285690 406900 2269628 567407 995082 632900 309684 411873 2349539 587384.8 9 8 867000 586941 278651 378451 2111043 527760.8 10 11 Sum 7404383 5018180 2331649 3196063 12 Mean 1057769 71882.85 333092.71 456580.42 13 Median 14 15 16