Homework answers / question archive / Select the Excel function for the 20 percent trimmed mean of a data set in cells A1:A60

Select the Excel function for the 20 percent trimmed mean of a data set in cells A1:A60

Finance

Share With

Select the Excel function for the 20 percent trimmed mean of a data set in cells A1:A60.

Excel function =TRIMMEAN(A1:A60,0.20)

Excel function =TRIMMEAN(A1:A60,0.40)

Excel function =MEAN(A1:A60,0.40)

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

No of observations          

(c) How many would be trimmed overall?

No of observations