Use Excel to compute the descriptive statistics for the following data set: 25,

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.

1. If there are only 20 observations, then the standard deviation of this data set is _____

2. 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 ______

3. The minimum of this data set is ______

4. The maximum of this data set is _______

5. The range of this data set is __________

D.441

This data set can be represented by a symmetric distribution, such as a normal distribution.

A.2 B.445 C.443

D.441

This data set can be represented by a symmetric distribution, such as a normal distribution.

True False

Explanation / Answer

Answer: 1. If there are only 20 observations, then the standard deviation of this data set is _____

Mean = 1274/20 = 63.7

Standard deviation = square (171128.2/(20 -1))

=94.90

Answer 2. 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 ___

suppose no of items is 25 than

standad deviation = square (171128.2/(25 -1))

=84.44

Answer 3. The minimum of this data set is 2.

Answer 4. The maximum of this data set is 445.

Answer 5.The range of this data set is 443.

Range = Maximum data entry - Minimum data entry

= 445 - 2 = 443

so, Answer is c 443

x mean x-mean (x-mean)2 2 63.7 -61.7 3806.89 12 63.7 -51.7 2672.89 12 63.7 -51.7 2672.89 16 63.7 -47.7 2275.29 17 63.7 -46.7 2180.89 23 63.7 -40.7 1656.49 25 63.7 -38.7 1497.69 26 63.7 -37.7 1421.29 34 63.7 -29.7 882.09 34 63.7 -29.7 882.09 41 63.7 -22.7 515.29 45 63.7 -18.7 349.69 45 63.7 -18.7 349.69 56 63.7 -7.7 59.29 63 63.7 -0.7 0.49 73 63.7 9.3 86.49 97 63.7 33.3 1108.89 98 63.7 34.3 1176.49 110 63.7 46.3 2143.69 445 63.7 381.3 145389.7 Total 1274 171128.2

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.