# Question: a Use Excel to prepare an appropriate type of chart

(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 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 ...(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) Write the Excel function for the 10 percent trimmed mean of a data set in cells A1:A50. (b) How many observations would be trimmed in each tail? (c) How many would be trimmed overall? (a) Find the mean and standard deviation for each sample. (b) What does this exercise show about the standard deviation? Sample A: 6, 7, 8 Sample B: 61, 62, 63 Sample C: 1000, 1001, 1002 An exam has a mean of 70 with a standard deviation of 10. Use Chebyshev's Theorem to find a lower bound for the number of students in a class of 400 who scored between 50 and 90.Post your question