Julie owns 100 shares of Apple stock (lucky her) and is trying to decide how much her

Question:

Julie owns 100 shares of Apple stock (lucky her) and is trying to decide how much her portfolio will be worth next month. The data in the Excel file Apple stock price.

xlsx show the closing price of a share of Apple stock at the end of each month from October 2011 until May 2013.

Based on: BigCharts.com data.

a. Construct a graph showing the Apple stock price over time.

b. Forecast the closing price for Apple stock at the end of June 2013 using a trend projection.

c. Calculate the MAD for this forecast.

d. Check for the presence of positive autocorrelation.

e. What concerns should you have using trend projection to forecast with this data.

AppendixLO1

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics

ISBN: 9780133852288

2nd Edition

Authors: Robert A Donnelly, Robert Donnelly Jr

Question Posted: