Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Table 1. NFL Field Goals Stats 2020 FGM Att FG% 20-29 M 20-29 Att 30-39 M 30-39 Att 40-49 M 40-49 Att 50 M 50
Table 1. NFL Field Goals Stats 2020 FGM Att FG% 20-29 M 20-29 Att 30-39 M 30-39 Att 40-49 M 40-49 Att 50 M 50 Att Graham Gano 31 32 96.9 4 4 13 13 9 9 5 6 Chris Boswell 19 20 95 5 5 6 6 7 8 1 1 Younghoe Koo 37 39 94.9 10 10 11 12 8 9 8 8 Daniel Cartson 33 35 94.3 18 18 8 8 3 5 4 4 Cairo Santos 30 32 93.8 9 9 10 10 9 10 2 3 Nick Folk 26 28 92.9 6 6 7 7 11 12 2 3 Harrison Butker 23 25 92 7 7 9 9 3 5 4 4 Q1. (Page 69 in the textbook) Based on Table 1 in this sheet, please fill in the highlighted cells in Table 2 by using an Excel formula that starts with the equal sign. The percentage sign should NOT be included in each cell because it was alredy included in the table's title. Table 2. Field Goal Percentages for the Four Ranges (%) F20 F30 F40 F50 Graham Gano 100 100 100 83.33 Chris Boswell 100 100 87.50 100 Younghoe Koo 100 91.67 88.89
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started