Refer to the worksheet named SALES. This worksheet provides customer account numbers and sales data for these customers. Provide numerical answers unless otherwise directed. 5. For the current year, what is the mean sales amount? 6. Comparing the current year to the prior year by what percent has total sales for the year increased? (For example, if current sales were $102 and prior sales were $100, then sales would have increased 2%...) 7 What is the standard deviation of sales for the current year? In this case, assume that you are using the current year data as a sample representing a larger population of similar accounts. (Note: provide a result that includes 3 digits to the right of the decimal.] 8 Column D is based on a formula, but that formula has been removed, and only the resulting values are currently visible. What formula would you enter in cell D3 to generate the % change, in a manner that could be copied and pasted into D4:D27? Assume column "D" is formatted as a percentage (%) (Note: Where there is no prior- year sales, the percent change should be shown as 100% by your formula). D A 1 2 Account Number 3 28371 4 10526 5 98254 6 25942 7 58721 8 33321 9 46551 10 12684 11 85126 12 33256 13 97754 14 32561 15 44115 16 32586 17 15498 18 88874 48857 20 63257 21 44589 22 32598 23 12563 24 74251 25 65324 85216 27 42165 28 29 B C Current YR Previous YR Sales Sales $ 698,770 $ 710,013 $ 467,353 $ 456,067 $ 363,219 $ 105,254 $ 349,025 $ $ 276,598 $ 207,695 $ 286,830 $ 369,930 $ 156,916 $ 3,703 120,683 $ 17,068 120,916 $ 72,487 $ 102,735 $ 96,801 $ 81,018 $ 66,726 $ 81,488 $ $ 75,264 $ 67,646 $ 57,774 $ 54,167 $ 38,535 $ $ 33,334 $ 5,369 $ 31,049 $ 3226197 36,674 $ 21,440 $ 31,271 $ 11,066 $ 33,744 $ 29,116 $ 33,688 $ 6,458 $ 32,413 $ 22,112 26,434 $ 31,109 $ 26,448 $ 22,192 $ % Change -1.6% 2.5% 245.1% 100.0% 33.2% -22.5% 4137.5% 607.1% 66.8% 6.1% 21.4% 100.0% 11.3% 6.7% 100.0% 520.9% -90.4% 71.1% 182.6% 15.9% 421.6% 46.6% -15.0% 100.0% 100.0% 19