The file P12_24.xlsx contains the daily closing prices of Procter & Gamble stock from July2014 to September 2015. Use only the 2014 data to estimate the trend component of the random walk model. Next, use the estimated random walk model to forecast the behavior of the time series for the 2015 dates in the series. Comment on the accuracy of the generated forecasts over this period. How could you improve the forecasts as you progress through the 2015trading days?