(this is being done in excel so if you can provide excel formulas and what not that'd be a great help!)

Sporty cars are designed to provide better handling, acceleration, and a more responsive driving experience than a typical sedan. But, even within this select group of cars, performance as well as price can vary. Consumer Reports provided road- test scores and prices for the following 10 sporty cars. Prices are in thousands of dollars and road- test scores are based on a 0– 100 rating scale, with higher values indicating better performance. a) Develop a scatter diagram with price as the independent variable.
b) What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
c) Develop the estimated regression equation. Write down the estimated regression equation for this problem.
d) Provide an interpretation for the slope of the estimated regression equation. (Pay attention to Units while answering the question).
e) Another sporty car that Consumer Reports tested is the BMW 135i; the price for this car was $ 36,700. Predict the road- test score for the BMW 135i using the estimated regression equation developed (Pay attention to Units while answering the question).
f) Find the 98% Confidence and Prediction Intervals for the BMW 135i in part (e).
g) Conduct p-Value as well as Critical-Value based Hypothesis Tests to determine the significance of regression. Use α = 0.01. Is the regression statistically significant?