# Question

(a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective.

(b) Would more than one kind of display be acceptable? Why or why not?

(b) Would more than one kind of display be acceptable? Why or why not?

## Answer to relevant Questions

(a) Use Excel to prepare a Pareto chart of the following data. (b) Which three service providers account for approximately 80 percent of all responses? (a) For each data set, find the mean, median, and mode. (b) Discuss anything about the data that affects the usefulness of each statistic as a measure of center. a. Class absences (12 students): 0, 0, 0, 0, 0, 1, 2, 3, 3, ...On Friday night, the owner of Chez Pierre in downtown Chicago noted the amount spent for dinner at 28 four-person tables. (a) Find the mean, midrange, geometric mean, and 10 percent trimmed mean. (b) Do these measures of ...(a) Find the coefficient of variation for prices of these three stocks. (b) Which stock has the greatest relative variation? (c) To measure variability, why not just compare the standard deviations? Find the original data value corresponding to each standardized z-score. a. Student GPAs: Bob's z-score z = + 1.71, μ = 2.98, σ = 0.36 b. Weekly work hours: Sarah's z-score z = + 1.18, μ = 21.6, σ = 7.1 c. Bowling ...Post your question

0