Using the attached data on HPQ for the year 2000 (Jan-Dec). Make a line chart of the closing process for the year 2000 from January through December 2000. Next, using only the period from 1 January to 1 April 2000 (only use trading days vs calendar days = 250) create a linear regression showing the predicted stock price at the end of December 2000.
Make a column that number the days in the data from 1 to 252 and use that as the horizontal axis, not the date column. Also, use the Regression function of the Data Analysis to determine the intercept and slop of the regression line. Slope is the "X Variable 1" coefficient.
Question: What is the difference between this regression-predicted value and the actual price at the end of December 2000? What is your analysis of linear regression in stock-prediction scenarios?