INSTRUCTIONS:
This project is to determine who is the greatest of all time! Well, sort of. We will look at the NFL quarterbacks from 2000 – 2011 and attempt to determine who was the best and worst over this time period. The general idea is to use this type of analysis to compare quarterbacks in the modern age. The issue is that you can not directly compare the numbers from one season to another as the rules, defenses, and other conditions change, so direct comparisons of a single statistic is not valid, therefore, we use the z-score. Take into account standard deviation for each season.
Your job in this project is to answer the simple questions:
• Which quarterback had the best single season during this period?
• Which quarterback had the worst single season?
When answering these questions, please use the WP/Game statistic to determine a quarterback’s performance. Also, please justify how you determine the best performance for each year. Remember that defenses, weather, rules, number of QBs considered, etc., change each year. Last point, before you go about calculating some of the variables, check the excel help menus, they might have a function for that!
It’s my final paper for my math class and I couldn’t think of how to do it so I decided why not leave it to the professionals? My instructor wants us to use the z-score along with standard deviations to ultimately decide which QB is the best.