Chapter 12: Homework6. Wageweb conducts surveys of wage knowledge and presents summaries on its web site.Primarily based on wage knowledge as of October 1, 2002, Wageweb reported that the typical annualsalary for gross sales vice presidents was $142,111, with a mean annual bonus of $15,432.Assume the next knowledge are a pattern of the annual wage and bonus for 10 gross sales vicepresidents. Knowledge are in hundreds of .Vice President12345678910Wage13511514616716517698136163119Bonus1214161922247171811a) Develop a scatter diagram for these knowledge with wage because the impartial variable.b) What does the scatter diagram developed partially a) point out in regards to the relationshipbetween wage and bonus?c) Use the least squares methodology to develop the estimated regression equation.d) Present an interpretation for the slope of the estimated regression equation.e) Predict the bonus for a vice chairman with an annual wage of $120,000.f) Compute SST, SSR, and SSEg) Compute the coefficient of dedication r2. Touch upon the goodness of match.h) What’s the worth of the pattern correlation coefficient?i) Develop the null and various speculation to check the linear relationship betweensalary and bonusj) On the .05 degree of significance, decide whether or not wage and bonus are linearlyrelated.ok) Resolve the issue in Excel and examine your outcomes.