Determine the least squares trend equation


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

Year Price Year Price Year Price Year Price
1990 12.61 1995 27.15 2000 49.76 2005 53.42
1991 16.62 1996 29.85 2001 48.88 2006 57.12
1992 20.51 1997 36.01 2002 42.72 2007 59.35
1993 20 1998 40.51 2003 43.42 2008 57.37
1994 18.21 1999 35.42 2004 50.52 2009 61.7

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

(b) Calculate the selling price for the years 1995 and 2000. (Round your answers to 3 decimal places.)

(c) Estimate the selling price in 2014. (Round your answer to 3 decimal places.)

(d) By how much has the stock price increased or decreased (per year) on average during the period? (Round your answer to 2 decimal places.)

Request for Solution File

Ask an Expert for Answer!!
Basic Statistics: Determine the least squares trend equation
Reference No:- TGS0104021

Expected delivery within 24 Hours