A local state university athletic department wants to develop its budget for the coming year, using a forecast for football attendance. Football attendance accounts for the largest portion of its revenues, and the athletic director believes attendance is directly related to the number of wins by the team. The business manager has accumulated total annual attendance figures for the past 8 years:

Attendance Wins Advertising

36,300 4 $29,500

40,100 6 $55,700

41,200 6 $71,300

53,000 8 $87,000

44,000 6 $75,000

45,600 7 $72,000

39,000 5 $55,300

47,500 7 $81,600

a.What is the partial r²_y2.1?Interpret your result.

b.Provide your spreadsheet results.Interpret your results.What would you advise the business manager?