please solve required 1,2, and 3

Ch 5 HW, Part 2 Sand 7 7 8 148 98 10,260 8,180 Part 2 of 3 0.51 points Required: 1. Perform a least-squares regression analysis on Camp Rainbow's data. 2. Using the regression output, create a cost equation (y = a + bx) for estimating Camp Rainbow's operating costs 3. Using the least-squares regression results, calculate the camp's expected operating cost if 148 children attend a session 5 mol Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 ferences Using the least squares regression results, calculate the camps expected operating cost 148 children attend a session (Round your intermediate calculations and final answer to 2 decimal places.) Tow Cost Ch 5 HW, Part 2 Saved 7 Part 2 of 3 Required: 1. Perform a least-squares regression analysis on Camp Rainbow's data 2. Using the regression output, create a cost equation ly = a + bx) for estimating Camp Rainbow's operating costs. 3. Using the least-squares regression results, calculate the camp's expected operating cost if 148 children attend a session. 051 pot Skood Complete this question by entering your answers in the tabs below. book References Required 1 Recuired 2 Required) Perform a least-squares regression analysis on Camp Rainbow's data (Use Microsoft Excel oda statistical package to find the coefficients using feast squares regression. Round your answers to 2 decimal places.) Coefficients Intercept X Variable 1 Required Required 2