Date Price 2/5/2016 1880.05 2/4/2016 1915.45 2/3/2016 1912.53 2/2/2016 1903.03 2/1/2016 1939.38 1/29/2016 1940.24 1/28/2016 1893.36 1/27/2016 1882.95...

Prepare a brief, descriptive report based on the data file and submit it.

You may use any computer software you wish (e.g., Excel with MegaStat, MINITAB, StatPlus). Include relevant worksheets or graphs in your report. If some questions do not apply to your data set, explain why not. 

(1) Find maximum and minimum value of S&P 500 price and make a histogram for S&P 500 index price for recent 3 years. Describe its shape.

(2) Explain what is mean and median, and discuss the properties of mean and median. After then calculate the sample mean and median of S&P 500 index price for recent 3 years. Are the data skewed?

(3) Explain what is the geometric mean, min range and trimmed mean.After then calculate Geo-mean, mid-range and 5% trimmed mean of S&P 500 index price for recent 3 years.

(4) Discuss variance, standard deviation and mean absolute deviation. (What are mathematical definitions of them, what is the statistical mean, what are properties of them and so on.)After than calculate the sample standard deviation and the mean absolute deviation of S&P 500 index prices using the data file.

(5) Discuss empirical rule.Find outliers using standardized data (Z-score) for the given recent 3 years S&P 500 index prices.

(6) Discuss what are quantiles and calculate the quartiles (Q1, Q2, Q3) for the given recent 3 years S&P 500 index prices .

WILL TIP GENEROUSLY