1. Use correlation and regression analysis to investigate the relationship between maintenance and age of the car. a) Identify the dependent and the independent variable. Use Excel to draw a scatterplot. Add a trend line. Explain your graph. (6 marks) b) Use Excel to generate a summary output for regression analysis. From the output, determine the regression equation. (4 marks) c) Write a short report based on your results in part (b). Interpret all the relevant analysis and conclude the significance of the model. (7 marks)