1. For the company revenue data (page 1 of the Excel file) compute the sample statistics below using Excel statistical functions. Copy and paste both the formulas and the values into the boxes. In this course, never think outside the box. Use Paste Special/Formatted Text. Statistic Excel formula Value Mean =AVERAGE(A5:A76) 1176.766667 Median =MEDIAN(A5:A76) 319.4 Skewness =SKEW(A5:A76) 6.814984955 Standard deviation =STDEV.S(A5:A76) 3338.575649 Mean absolute deviation =AVEDEV(A5:A76) 1364.835185 Variance =VAR.S(A5:A76) 11146087.37 Q3 (exc) =QUARTILE.EXC(A5:A76,3) 847.5 30th percentile(exc) =PERCENTILE.EXC(A5:A76,0.3) 202.08 Kurtosis =KURT(A5:A76) 51.96464166 2. What relationship do you observe regarding the mean, median and skewness? Complete sentences. Read the background doc before answering this question.2. What relationship do you observe regarding the mean, median and skewness? Complete Isentences. Read the background doc before answering this question. Median is less than mean and skew is the smallest according to the given dataset 3. Use the Excel DAT \"Descriptive Statistics\" to compute a 'package' of statistics for the same data. Paste Special/Worksheet Object. 4. On page 2 of the Excel file, find annual percent returns for two mutual funds. Copy the descriptive statistics package for both into the box. 5. It is general desirable to have high average returns, but low return variance (i.e., volatility). How do the two funds compare in both these respects? | | 6. A similar problem: On page 3 of the data file, find the daily adjusted close for the S&P 500 over the same periods for 2019 and 2020. Copy the descriptive statistics package for both into the box. 7. The average adjusted close is similar for both periods. Explain in at least 2 complete sentences :So, what is the principal difference in these data sets and what circumstance do you think accounts for that (think global events)