Answer the following questions using the information and data below

The following is a small data set of 25 observations. I want you to calculate some basic descriptive statistics for the data. I suggest that you use Excel to do this, but you can also do the work with a calculator. lwill aks for the answers, but also that you know the formulas, including the computation formula for the variance that uses the Sum(X) and the Sum()(2}. For the computational formula, you will want to calculate a separate row of each value squared in order to calculate the Sum()(1), Excel will also calculate this for you. The Excel le Basic Stat 2020.xlsx would be helpful for this assignment. The data below is in table form and can be copied directly into Excel. Va r1 33 53 40 43 33 47 51 35 37 60 37 36 43 51 41 45 40 29 14 38 33 12 28 42 . Create a Stem and Leaf Plot of the data (it is easy to do in Word by making a two-column table and entering the numbers in there, holding the stems) . Calculate the Sum(X) and the Sum()(2). You want to be able to show the variance calculated from the computational formula generates the same result as using the VAR.S function in Excel. Calculate the following (be prepared to show intermediate steps}: " Mean ' Median ' Mode ' Range ' Variance ' Std. Deviation ' Coefcient of Variation c. Calculate a z-score for a data value of 20. Describe this in words