Measures of Central Tendency and Variation Using Excel's Statistical Functions

Assignment Task

1. You are given the following data set: 5000, 6524, 8524, 7845, 2100, 9845, 1285, 3541, 4581, 2465, 3846. Using Excel's statistical functions, complete the following:

a. Calculate the simple mean.

b. Calculate the standard deviation.

c. Calculate the median.

d. Is the median equal to the mean? Why or Why not?

2. The following data were collected from the ECU baseball team regarding their pitcher's earned run averages (ERA) for the last 2 years. Using Excel's statistical functions, complete the following questions.

a. What is the mean of the data set for the ECU
pitcher's ERA?

b. What is the standard deviation of the data set for the ECU pitcher?

c. Construct a histogram for the ECU pitcher's ERA data set, using 0.5 as your class width and starting with 2.0 as your lowest class.

3. The following data were collected on scores (out of a possible 100) for a pretest in quantitative methods. Using Excel's statistical functions, complete the following questions.
Scores

a. What is the mean of the data set for pretest scores?

b. What is the median of the data set for the scores on the pretest? Is there a difference or similarity? Explain the similarity or difference.

c. What is the standard deviation of the data set?

d. Construct a histogram for the pretest score data set, using 5 as your class width and starting with 0 as your lowest class.

This Management has been solved by our PhD Experts at My Uni Paper.