I need help figuring out this problem I'm not sure how to format it on EXCEL And you formulas and what night can you please help me I'm not really good at this

A large school district is reevaluating its teachers' salaries. They have decided to use regression analysis to predict mean teachers' salaries at each elementary school. The researcher uses years of experience to predict salary. The raw data is given in the table below. 5 7 3 A. Create scatter diagram for this data to determine iflinear model is reasonable (10 points) B. What is the regression line equation? (20 points) C. If a teacher has 10 years of experience, what is the forecasted salary? (10 points) D. Based on the equation, for every additional year of service, a teacher could expect his or her salary to increase by how much? (10 points) 3 4 15 16 Salary Years of experience 17 $24,265.00 8 18 $27.140.00 5 19 $22,195.00 2 20 $37,950.00 15 21 $32,890.00 11 22 $40,250.00 14 23 $36,800.00 9 24 $30,820.00 6 25 $44,390.00 21 26 $24,955.00 2 27 $18,055.00 1 28 $23,690.00 7 29 $48,070.00 20 30 $42,205.00 16 31 32 34 35 36 37 38 39 40 A