Answer:
Check Explanation and the third attached image to this solution for the summary of regression analysis.
Explanation:
The data for the question is missing. It was obtained online and is presented in the first and second attached images to this solution.
The regression analysis is then done with Excel and the results posted in the third attached image to this solution.
The residuals too are with the results.
Hope this Helps!!!