Originally a manufacturing company determined whether there was a relationship between the age of an imaging tool and the annual maintenance cost and found a significant relationship between age and annual maintenance cost. The company would like to know if adding the number of defective parts produced per week would improve the model. A sample of 10 imaging tools resulted in the following data:

Accuracy of Imaging Tool	Age of Imaging Tool (Years)	Annual Maintenance Cost ($)
375	1	35
330	2	370
282	2	480
265	2	520
212	2	590
178	3	550
174	4	750
167	4	750
172	5	790
93	5	950

The Regression output for the original model of age of imaging tool and annual maintenance cost is as follows:

Because the p-value associated with the b1 is less than the 0.05 significance level, we can conclude that there is a significant relationship between age of imaging tool and annual maintenance cost.

Utilizing the data provided in the providedQ2ImagingToolAccAgeCostExcel file, construct an appropriate Excel file guided by the questions below. Then, answer the questions below either in a Word document or within yourcompleted Excel file. Acompleted Excel file must be attached to receive credit for this question.

a. Develop scatter charts for these data. What does the scatter chart indicate about the relationship between age of an imaging tool and the annual maintenance cost? What does the scatter chart indicate about the relationship between the accuracy of the imaging tool and the annual maintenance cost?

b. UseExcel's Regression toolto develop an estimated regression equation that could be used to predict the annual maintenance cost given the age of the imaging tool and the accuracy of the imaging tool parts. What is the estimated regression model?

c. For the model with age and accuracy, test whether each of the regression parameters b1 and b2 is equal to zero at a 0.10 level of significance. What are the interpretations of the estimated regression parameters?

d. How much of the variation in the sample values of annual maintenance cost do each of the models, (1) the original model with age only, and (2) the model with both age and accuracy, explain? e. Given the results for each model, would one model be preferred over the other? What are your recommendations with regards to which model should be used?