PLEASE PROVIDE FUNCTIONS

On the workbook's Descriptive Stats tab:

• Insert the relevant values in each cell in row 2 using these functions and formulas applied to the range of observations in column A:
  • AVERAGE (under the "Mean" column header)
  • MEDIAN
  • MODE.SNGL
  • MIN
  • MAX
  • RANGE (Calculated by subtracting MIN from MAX)
  • STDEV.S
  • COUNT.

1 Observations 50 55 55 60 60 60 65 65 65 65 75 75 75 75 75 75 80 80 80 80 80 85 85 85 85 90 90 90 95 95 100 WN 45 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 25 26 27 30 31 32 33 34 35 36 37 38 39 40 41 B Mean TI D E Median Mode Min G Max H Range I Std. Dev. J Count K L 1 Observations 50 55 55 60 60 60 65 65 65 65 75 75 75 75 75 75 80 80 80 80 80 85 85 85 85 90 90 90 95 95 100 WN 45 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 25 26 27 30 31 32 33 34 35 36 37 38 39 40 41 B Mean TI D E Median Mode Min G Max H Range I Std. Dev. J Count K L