Question: Using Data/Filter and Sort make a subset of the main data table for Symbol HPQ (Hewlett Packard) for the year 2000. Make a line chart of the closing prices for the year 2000 from Jan through Dec. Using only the period from 1 Jan 2000 to 1 Apr 2000 create a linear regression showing the predicted stock price at the end of December 2000. (hint: use the general regression equation on page 399 and the discussion on the following pages. Remember to count “trading days” and not “calendar days”.) Make a column that numbers the days in the data from 1 to 252 and use that as the horizontal axis, not the date column. You can use the Regression function in Data Analysis to determine the intercept and slope of the regression line. Slope is the “X Variable 1” coefficient. 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?