Linear Regression – An 80-Year Study of the Dow Jones ...

Enter them into an Excel Spreadsheet with a column for the years and a column for the Dow prices. Scale the years appropriately. Create an appropriate display to show the trend in the DJIA over the past 80 years. Answer question #1. Create a linear model to predict “DJIA price” from “Years Since 1930”. Include the model in your display. ................
................