The file Midterm Data.xls has a tab labeled "National Grid vs. Alcoa" which presents historical price data for two stocks. Using the National Grid price as the X-value and the Alcoa price as the Y-value, we will perform a long-form regression analysis on this data.
• Compute the values of, , SSXX, SSYY, SSXY.
• Determine the regression equation.
• Compute the standard error of the estimate se.
• Determine 95% confidence interval for the price of Alcoa, , when the price of National Grid is at 60.