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

 

1. Find the mean, median mode(s), range, standard deviation, and variance of the data:
   1. 21, 15, 16, 25, 13, 18
   2. 5, 3, 2, 6, 5, 2, 5
2. Eight car sales men sold cars at a dealership. Here is the distribution of cars sold last month:
   6, 45, 52, 43, 48, 41, 50, and 48.
   1. Find the mean, median mode(s), range, standard deviation, and variance of the data:
   2. Which measure of central tendency best represents the data? Explain.
3. You are planning a trip to Washington, D.C., and are looking up hotel room rates. On the Internet you find the following rates for a one-night stay in a hotel in Washington, D.C.
   $109, $126.50, $175.95, $139, $77.50, $145, $162.35, $173, $181.50, $105
   1. Find the mean, median mode(s), range, standard deviation, and variance of the data:
   2. Is there a great deal of dispersion among the rates? Explain.
4. 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, 89
   Low: 64, 53, 62, 66, 68, 69, 67
   1. Find the mean, median mode(s), range, standard deviation, and variance of the data.
   2. Is there a great deal of fluctuation in the daily prices of MYCC? Explain.
5. 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.