I am trying to think of a formula to calculate average football field position in American football. Lets say that in the first quarter, Team A has two drives that start at their own 49 yard line (T49), and a second that starts at their opponent’s 49 yard line (O49). The average field position would be the 50 yard line. How can I calculate that based solely upon the two variables (T49 and O49)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Calculating average field position
- Thread starter bmv505
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,313
- Office Version
- 365
- Platform
- Windows
I would recommend doing it from the perspective of how many yards away they are from their opponents goal line.
So, any starting position on their own side of the field would need to have (50 -yard line) yards added to it (i.e. T33 would need to add 50-33 = 17, so added to 50 = 67).
Once you have that, you can average that (and convert back to a yard line after the fact by reversing the process).
So, any starting position on their own side of the field would need to have (50 -yard line) yards added to it (i.e. T33 would need to add 50-33 = 17, so added to 50 = 67).
Once you have that, you can average that (and convert back to a yard line after the fact by reversing the process).
Upvote
0
Similar threads
- Question
