Under Session 3 there is a dataset named “stockprices.xls,” which contains historical time-series of daily closing stock price of Ford (column E in the spreadsheet). Assume you are interested in...

Under Session 3 there is a dataset named “stockprices.xls,” which contains historical time-series of daily closing stock price of Ford (column E in the spreadsheet). Assume you are interested in studying the behaviors of this (Ford) TS, please do the following to carry out a routine analysis. (For all hypothesis tests, please use significance level of a = 0.05). 1). Obtain a time-series plot of the data (only TS plot of Ford stock prices), and discuss what kind(s) of pattern you can identify from the plot. 2). Using Minitab, obtain the ACF function (plot) of Ford stock prices. 3). Using Bartlett test we discussed in the class, conduct test to see whether there exist significant autocorrelation at lag 1 and lag 6. In so doing, list your null and alternative hypotheses and show your test statistics which lead you to the conclusion. You must provide corresponding outputs from Minitab, from which you obtain estimates of autocorrelation coefficients at different lags. 4). Discuss whether Ford stock price time-series is a stationary time series, is it a white noise time series? (Check whether the definition conditions are violated.) 5). Check (using Portmanteau ?2 test) whether you can use a random walk model to represent the characteristics of Ford stock price TS.