Question

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

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

Year Price
1998 40.6111
1999 35.0230
2000 49.5625
2001 48.68
2002 42.22
2003 46.62
2004 52.20
2005 59.85
2006 62.00
2007 77.51
2008 54.77
2009 60.80
2010 65.33
2011 66.35
2012 68.43
2013 82.94
2014 94.56
2015 99.92

  1. Plot the stock price in the order in which the data are presented.

  2. Determine the least squares trend equation. (Round your answers to 2 decimal places.)

  3. Calculate the selling price for the years 2008 and 2013. (Round your answers to 2 decimal places.)

  4. Estimate the selling price in 2018. (Round your answer to 2 decimal places.)

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

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The table below reports the earnings per share of common stock for Home Depot Inc. for...
The table below reports the earnings per share of common stock for Home Depot Inc. for 2003 through 2015. Year Earnings per Share 2003 $ 1.64 2004 1.94 2005 2.33 2006 2.81 2007 2.81 2008 2.44 2009 1.40 2010 1.66 2011 2.04 2012 2.55 2013 3.80 2014 6.40 2015 9.63 Click here for the Excel Data File Develop an index, with 2003 as the base, for earnings per share for years 2004 through 2015. (Round your answers to 1 decimal...
The following data the performance of the Eurozone blue-chips stock in the form of end-of-year values...
The following data the performance of the Eurozone blue-chips stock in the form of end-of-year values of the Euro Stoxx index from 1995 to 2015. Year Euro Stoxx Index 1995 1507 1996 1850 1997 2532 1998 3342 1999 4904 2000 4772 2001 3806 2002 2386 2003 2761 2004 2951 2005 3579 2006 4120 2007 4400 2008 2451 2009 2966 2010 2793 2011 2317 2012 2636 2013 3109 2014 3146 2015 3268 Question Using a smoothing coefficient of W = 0.25,...
The following data set provides information on acres harvested and planted by year and value in...
The following data set provides information on acres harvested and planted by year and value in the US. Year ASPARAGUS - ACRES HARVESTED ASPARAGUS - ACRES PLANTED 2015 21,700 23,500 2014 23,800 25,800 2013 24,500 26,800 2012 25,300 27,800 2011 26,800 28,400 2010 28,000 29,200 2009 29,200 30,700 2008 32,200 33,700 2007 38,600 40,900 2006 43,200 44,700 2005 49,300 51,700 2004 61,500 66,000 2003 58,000 62,000 2002 66,000 70,500 2001 70,150 75,150 2000 77,400 82,800 1999 75,890 79,590 1998 74,430...
The table below contains average annual retail value data for crude oil in the US (actual...
The table below contains average annual retail value data for crude oil in the US (actual data is $/barrel). The data was obtained from the inflationdata.com. year actual year actual 1997 28.43 2007 75.66 1998 17.89 2008 103.67 1999 24.28 2009 60.91 2000 38.92 2010 79.93 2001 31.81 2011 94.73 2002 31.02 2012 92.20 2003 36.85 2013 95.79 2004 48.77 2014 88.47 2005 62.66 2015 43.22 2006 70.77 2016 37.02 Problem 2 (moving average), c onstruct the worksheet for three...
Sales for the La Parisienne Cosmetics Company (in $ millions) are as follows: Year Sales ($...
Sales for the La Parisienne Cosmetics Company (in $ millions) are as follows: Year Sales ($ millions) Year Sales ($ Millions) Year Sales ($ Milions 1996 2.3 2003 4.5 2010 4.5 1997 2.9 2004 4.7 2011 4.9 1998 3.4 2005 5.0 2012 5.2 1999 4.5 2006 5.2 2013 5.5 2000 3.4 2007 5.5 2014 5.8 2001 4.0 2008 4.3 2002 4.2 2009 4.4 (a) Develop a three-year moving average. (b) Develop a four-year moving average. (c) Develop a five-year moving...
Consider the following data: Number of Deaths in the U.S. by Drug Overdose Year 2000 2001...
Consider the following data: Number of Deaths in the U.S. by Drug Overdose Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 Deaths 17,055 17,511 14,316 13,342 17,776 14,516 11,152 18,656 16,643 Find the three-period moving average for the year 2004. If necessary, round your answer to one decimal place.
Year Period (t) Enrollment (1,000s) 2001 1 6.5 2002 2 8.1 2003 3 8.4 2004 4...
Year Period (t) Enrollment (1,000s) 2001 1 6.5 2002 2 8.1 2003 3 8.4 2004 4 10.2 2005 5 12.5 2006 6 13.3 2007 7 13.7 2008 8 17.2 2009 9 18.1 (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 = MSE = (c) What is the forecast for year 10? Do not round...
The following table contains the historic returns from a portfolio consisting of large stocks and a...
The following table contains the historic returns from a portfolio consisting of large stocks and a portfolio consisting of long-term Treasury bonds over the last 20 years. T-bills returns represent risk-free returns. Analyze the risk-return trade-off that would have characterized these portfolios. The following dataset is also available in Excel format in Module 3 Resources on Canvas. Returns in the dataset are in percents. For example, 31.33 means 31.33% per year. Year Large Stock Long-Term T-Bonds T-Bills 1997 31.33 11.312...
3. Below table contains the total number of fatal motor vehicle crashes in Canada for the...
3. Below table contains the total number of fatal motor vehicle crashes in Canada for the period from 1994 to 2011. ( 8 marks) Year Total crashes Year Total crashes 1994 36254 2004 38444 1995 37241 2005 39252 1996 37494 2006 38648 1997 37324 2007 37435 1998 37107 2008 34172 1999 37140 2009 30862 2000 37526 2010 30296 2001 37862 2011 29757 2002 38491 Total 653782 2003 38477 Answer the following questions: a. What is the percentage of deaths measured...
You have the following historical annual total returns on Terlingua Oil & Gas Exploration: Year Annual...
You have the following historical annual total returns on Terlingua Oil & Gas Exploration: Year Annual total return (%) 2001 0% 2002 6% 2003 13% 2004 9% 2005 2% 2006 4% 2007 -1% 2008 -6% 2009 0% 2010 4% Calculate the sample standard deviation of annual return. Do not round at intermediate steps in your calculation. Express your answer in percent. Round to two decimal places. Do not type the % symbol.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT