Please show step-by-step how to solve this. Excel or by hand is okay.

City government has collected the following data on annual sales tax collections and new car registrations Annual Sales Tax Collections (in millions) $1.02 $1.44 $1.88 $2.04 $1.84 $2.14 $2.30 New Car Registrations (in thousands) 11 13 16 16 15 17 21 a) The least squares regression equation that shows the best relationship between sales tax (in millions) and car registrations (in thousands) is (round your responses to three decimal places and include a minus sign if necessary) 9-1.) where y = Dependent Variable and x = independent Variable a) The least squares regression equation that shows the best relationship between sales tax (in millions) and car registrations (in thousands) is (round your responses to three decimal places and include a minus sign if necessary) 9 = where y = Dependent Variable and x = Independent Variable b) Using the least-squares regression equation, the estimated sales tax collection when the new number of registrations total is 23,000 $ million (round your response to two decimal places) c) The coefficient of correlation for the least-squares regression - (round your response to four decimal placos). The coefficient of determination for the least squares regression = (round your response to four decimal places)