Please Help, Professor said to do this using excel data analysis.

Autocorrelation in Stock Price. The following data show the daily closing prices (in dollars per share) for a stock.

Time Period	Price
3-Nov	82.87
4-Nov	83.00
5-Nov	83.61
6-Nov	83.15
7-Nov	82.84
10-Nov	83.99
11-Nov	84.55
12-Nov	84.36
13-Nov	85.53
14-Nov	86.54
17-Nov	86.89
18-Nov	87.77
19-Nov	87.29
20-Nov	87.99
21-Nov	88.80
24-Nov	88.80
25-Nov	89.11
26-Nov	89.10
27-Nov	88.90
28-Nov	89.21

a. Define the independent variable Period, where Period = 1 corresponds to the data for November 3, Period = 2 corresponds to the data for November 4, and so on. Develop the estimated regression equation that can be used to predict the closing price given the value of Period.

b. At the .05 level of significance, test for any positive autocorrelation in the data.