The file named Qbinfo.xlsx lists quarterback ratings for NFL quarterbacks during the 2009 season. The quarterback rating is based on the quarterback’s completion percentage, the percentage of passes that result in a touchdown, the yards made per pass attempt, and the percentage of passes that are intercepted.

Develop a formula to predict a quarterback’s rating, based on his season statistics.

How accurate are your predictions?