Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
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.
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
a) Here,
As we know that for trimmed mean, We remove 20% from top and 20% form bottom values.
Therefore,
Excel Function: TRIMMEAN(A1:A60,0.40)
b) Computation of No. of Observations (Trimmed in Each Tail):
Number of Observations = 60*0.20 = 12
c) Computation of No. of Observations (Trimmed Overall):
Number of Observations = 12+12 = 24
