Number 9 (H1) please show work.

9) A resort catering to golfers has reported the average income of golfer households to be $95,000. Assume that this average had been based on the 100 incomes in file golf_income.xls. a) Calculate a histogram of the data and comment on its shape? Is it skewed? What is the value of the skewness statistic? b) Compare the standard deviation of this data set to the MAD. You can calculate MAD by first generating the absolute deviations from the mean using the stata generate command (generate x=abs(income-95000) then MAD will be the mean of this new variable. That is do the following in Stata i. generate x=abs(income-95000) ii. summarize x iii. The mean reported by the summarize command will be MAD for the data set. c) Suggest a transformation to fix the skewness (log the data? Invert the data?) d) Perform the transformation you suggest and produce a histogram for the new data. Does it look more symmetric? Has the value of the skewness statistic changed? e) Compare the standard deviation and MAD of the transformed data set. Are they closer than before the data was transformed?