Listed below is the selling price for a share of PepsiCo Inc. at the close of ea

Question

Listed below is the selling price for a share of PepsiCo Inc. at the close of each year.

Year Price
1990 12.61
1991 16.32
1992 20.11
1993 20.2
1994 18.01
1995 27.25
1996 29.35
1997 36.91
1998 40.21
1999 35.22
2000 49.26
2001 48.48
2002 42.82
2003 43.22
2004 50.42
2005 54.82
2006 57.92
2007 60.75
2008 56.47
2009 63.1

(a)
Determine the least squares trend equation. (Round y-intercept to 3 decimal places and the other answer to 4 decimal places.)

= + t


I solved for it using excel and got y = 2.6472x - 5253.9, but the "5253.9" part is incorrect. does anybody know why?

Explanation / Answer

Take year 1990 as 0, 1991 as 1 and so on.. I have solved this and below is the answer. Y= 14.0243+2.6472x If that aslo doesn't give the right answer then Try taking Year 1990 as 1 and 1991 as 2 and so on...

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.