Please use excel to solve the calculations. the excel sheet should be

 

  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.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.