PLEASE USE EXCEL TO SOLVE THE CALCULATIONS. THE EXCEL SHEET SHOULD BE UPLOADED WITH YOUR WRITTEN RESPONSES.

Need assignment help for this question?
If you need assistance with writing your essay, we are ready to help you!

Order Now

Find the mean, median mode(s), range, standard deviation, and variance of the data:
Is there a great deal of dispersion among the rates? Explain.

The stock prices for Club Corp (MYCC–this is a real company) for last week are given below.High: 81, 78, 83, 89, 90, 87, 89Low: 64, 53, 62, 66, 68, 69, 67

Find the mean, median mode(s), range, standard deviation, and variance of the data.
Is there a great deal of fluctuation in the daily prices of MYCC? Explain.

In this module we discussed The Wall Street Journal Dow Jones Industrial Average. Go to The Wall Street Journal website and use the historical tool to calculate the mean and standard deviation for the month of August 2018 for your projections. Using the closing data only, is there fluctuation in the data? Explain. Use the instructions from M2D1 and chane the dates in the tool to 08/01/2018 and 08/31/2018.

This assignment should take you approximately an hour. Please use Excel to do your calculations.