# Question

(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?

(b) How many observations would be trimmed in each tail?

(c) How many would be trimmed overall?

## Answer to relevant Questions

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? An executive's telephone log showed the lengths of 65 calls initiated during the last week of July. (a) Find the mean, median, mode, midrange, geometric mean, and 10 percent trimmed mean. (b) Are the data symmetric or ...(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? In a regional high school swim meet, women's times (in seconds) in the 200-yard freestyle ranged from 109.7 to 126.2. Estimate the standard deviation, using the Empirical Rule. An executive's telephone log showed the lengths of 65 calls initiated during the last week of July. (a) Use Excel to find the quartiles. What do they tell you? (b) Find the midhinge. What does it tell you? (c) Make a box ...Post your question

0