# 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 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) Make a frequency distribution and histogram (using appropriate bins) for these 28 observations on the amount spent for dinner for four in downtown Chicago on Friday night. (b) Repeat the exercise, using a different ...In the Excel function 5 TRIMMEAN (Data,.10) , how many observations would be trimmed from each end of the sorted data array named Data if (a) n = 41, (b) n = 66, and (c) n = 83? For each data set, is the mode a good measure of center? Explain. a. Genders of 12 CEOs: M, M, F, M, F, M, M, M, F, M, M, M b. Ages of 10 college freshmen: 17, 17, 18, 18, 18, 18, 18, 18, 19, 20 c. Ages of 8 MBA ...The mean monthly rent of students at Oxnard University is $875 with a standard deviation of $219. (a) John's rent is $1,325. What is his standardized z-score? (b) Is John's rent an outlier? (c) How high would the rent have ...Post your question

0