Statistics Homework Solutions
Problem
#8634

Word Problem: Coca Cola share prices.

Listed below is the selling price for a share of Coca Cola, at the close of the year.

Year Price Year Price Year Price
1990 12.9135 1994 18.3160 1998 40.6111
1991 16.8250 1995 27.7538 1999 35.0230
1992 20.6125 1996 29.0581 2000 49.5625
1993 20.3024 1997 36.0155

1. Plot the data.
2. Determine the least squares trend equation.
3. Calculate the points for the years 1993 & 1998
4. Estimate the selling price in 2003. Does this seem like a reasonable estimate based on the historical data?
5. By how much has the stock price increased or decreased per year on average during the period?


Solution Summary

This solution calculates the least squares trend equation, future selling price, price increases, decreases based on historical selling prices for shares of Coca Cola.

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
  • Attached file(s):
    • BrainMass - Statistics - 8634.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse