Excel formula for NFL passer rating

I've got columns for completions / attempts / TDs / interceptions --

I need a formula for passer rating.  I can't seem to get an accurate one that matches NFL stats.

Presume Completions is C2, Attempts is A2, TDs is T2, and Interceptions is I2

Thanks.
LVL 9
blakogreAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
..and here's an example using that last formula

I checked with an online calculator and it appears to give the correct results

regards, barry
27400456.xls
0
 
barry houdiniCommented:
According to Wikipedia you also need Passing Yards for the NFL version - do you have that?

regards, barry
0
 
blakogreAuthor Commented:
Ah, yes: P2.  Sorry :-)
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
barry houdiniCommented:
Try this formula for the rating

=(MEDIAN(0,2.375,(C2*100/A2-30)/20)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,(P2/A2-3)/4))/0.06

regards, barry
0
 
barry houdiniCommented:
Sorry, that was wrong, I repeated the touchdown calculation and missed out the interceptions - should be like this

=(MEDIAN(0,2.375,(C2*100/A2-30)/20)+MEDIAN(0,2.375,2.375-I2*25/A2)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,(P2/A2-3)/4))/0.06

regards, barry
0
 
blakogreAuthor Commented:
That seems to work, thanks :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.