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.

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.

Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...