estimate the regression in problem 5 based on Table 5-6 using Excel´s regression function in the Data Analysis menu. b. Using the coefficients found in the regression estimate, enter a formula based in cells C6 though J6 to forecast the sales revenue when

estimate the regression in problem 5 based on Table 5-6 using Excel´s regression function in the Data Analysis menu. b. Using the coefficients found in the regression estimate, enter a formula based in cells C6 though J6 to forecast the sales revenue when quality control goes from $2 million to $9 million a year. c. Graph both the actual data and the forecast using the graphing tool. Does the forecast vary much from the actual data

additional information is attached such as Problem 5, Table 5-6 and cells C6 through J6