Create an Excel file containing the prices for Google stock for 07/01/2019 - 11/25/2019 (inclusively). Use Yahoo Finance or similar websites to obtain historical data.

1) Assuming a linear relationship between the closing price and the business day (07/01/2019 - business day 1, 07/02/2019 - business day 2, etc), use the least-squares method to compute the regression coefficients. You can use Data Analysis Toolpack for this. State the obtained model with the found estimated parameters. b) State the extrapolated price for the Google stock for 11/26/2019 (since the date is out of the range, this predicted value for the stock for 11/26/2019 will be an extrapolation).