Please solve on Excel if possible. Thank you

1. Baby It's You, a maker of baby foods, has found a high correlation between the aggregate company sales (in $100,000 ) and the number of births nationally the preceding year. Suppose that the sales and the birth figures during the past eight years are a) ( 30 points) Determine a regression equation for predicting sales based on births. Use years 2 through 8 as your baseline. b) (10 points) Suppose that births are forecasted to be 3.3 million in year 9 . What forecast for sales revenue in year 10 do you obtain using the results of part (a)