Reference no: EM132235620
Question: Use Excel to compute the descriptive statistics for the following data set: 25, 45, 73, 16, 34, 98, 34, 45, 26, 2, 56, 97, 12, 445, 23, 63, 110, 12, 17, and 41.
Please fill the below questions based on above question:
1) The mean of this data set is _________________? (Please round to two decimal points.)?
2) The median of this data set is __________________? . (Please round to two decimal points.)
3) The mode of this data set is ___________________.? (Please round to two decimal points.)
4) In general, the mode always lies in between the mean and the median?
(True or False)?
5) If there are only 20 observations, then the standard deviation of this data set is ________________________? . (Please round to two decimal points.)
6) If there are more than 20 observations in total or in the population, then the standard deviation of this data set (a sample from the population) is_________________ ? . (Please round to two decimal points.)
7) The minimum of this data set is _____________________? . (Please round to two decimal points.)
8) The maximum of this data set is ____________________?. (Please round to two decimal points.)
9) The range of this data set is __________________? (Please round to integer if needed.)
10) This data set can be represented by a symmetric distribution, such as a normal distribution._____________________?
(True or false)?