0779 STATISTICS GB . Lesson 4 - Descriptive (or Summary) Statistics Lesson 4 - Guided Learning Assignment Use Excel to find the requested measures of center and spread for the following sample data set. You should be able to select the table and copy it directly to Excel. 33.3 36.9 40 45.6 52.6 59.9 63.1 69.6 48.8 48.6 52.7 44.3 40.6 46.3 44. 39.7 54.7 45.6 61.2 63.2 51 54.7 58 46.3 40.6 68.6 56.5 55. 38.8 58.3 61.8 60.7 40.2 47.8 50.6 55.9 37.6 50.4 45.1 47.6 54 66.4 38.2 44.1 45.6 47.1 44.3 47.3 43.3 59.8 49.6 51.4 48.6 59.4 48.8 54.4 51.6 51.8 48.4 66.4 40.6 68.6 52 60. 44.3 49.6 53.1 53.3 41 54.7 What is the mean of this data set? mean = Report answer to 2 decimal places. What is the median of this data set? median = Report answer to 2 decimal places. What is the maximum of this data set? max = What is the minimum of this data set? min = What is the mid-range of this data set? mid-range = What is the range of this data set? range = Report the standard deviation using the rounding rules suggested in class (two more decimal places than the data reports). Type here to search O E @ m L