Please provide excel formulas

Problem 2: City government has collected the following data on annual sales tax collections and new car registrations: Annual Tax Collection (in Millions) 1.0 1.4 1.9 2.0 1.8 2.1 2.3 New Car Registrations in Thousands 10 12 15 16 14 17 20 a. Develop a linear regression model to predict the annual sales tax collections as a function of the new car registrations. Note that this is not a time-series data set because the weeks were selected at random; they were not a sequential set of seven years. (5 points) b. Comment on the strength of your model's ability to capture the variation in annual sales tax collections, 15 points) c. Report the estimated regression equation from your model that can be used to predict the annual sales tax collections as a functions of the new car registrations. (5 points) d. Use your estimated regression equation to predict the annual sales tax collections in a year where the new car registrations are expected to be 22,000. You should produce both a point estimate and a prediction interval. (15 points)