Linear Regression

Download JP Morgan stock historical prices from Yahoo Finance with the following characteristics:

• Period: February 1, 2018 - December 30, 2018
• Frequency: Daily
• Price considered in the analysis: Close price adjusted for dividends and splits

Implement a two-variable regression in R language using the following data:

1. Explained variable: JP Morgan stock (adjusted close price)
2. Explanatory variable: S&P500
3. Period: February 1, 2018 - December 30, 2018
4. Frequency: Daily

With the same variables as above (JP Morgan Stock and S&P500), implement a two variable regression in Excel using LINEST function and Analysis ToolPak.