Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Listed below is the selling price for a share of PepsiCo Inc. at thecloseof eachyear from 1990 to 2012. Year Price Year Price Year Price
Listed below is the selling price for a share of PepsiCo Inc. at thecloseof eachyear from 1990 to 2012. |
Year | Price | Year | Price | Year | Price | Year | Price | ||||
1990 | 12.51 | 1996 | 29.95 | 2002 | 42.92 | 2008 | 56.37 | ||||
1991 | 16.22 | 1997 | 36.61 | 2003 | 43.72 | 2009 | 60.8 | ||||
1992 | 20.51 | 1998 | 40.61 | 2004 | 50.22 | 2010 | 66.6 | ||||
1993 | 20.8 | 1999 | 35.12 | 2005 | 54.32 | 2011 | 68 | ||||
1994 | 18.51 | 2000 | 49.36 | 2006 | 56.82 | 2012 | 69.1 | ||||
1995 | 27.25 | 2001 | 48.48 | 2007 | 61.05 |
b. | Determinethe least squares trend equation.(Roundy-intercept to 3 decimal places and the otheranswerto 4 decimal places.) |
=+t |
c. | Calculate the selling price for the years 1995 and 2000.(Round your answers to 3 decimal places.) |
For 1995,=and for 2000,= |
d. | Estimate the selling price in 2017.(Round your answer to 3 decimal places.) |
For 2017,=. |
e. | By how much has the stock price increased or decreased (per year) on average during the period?(Round your answer to 2 decimal places.) |
(Click to select)IncreasedDecreasedper year. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started