Practice 2
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	Lng
Graham Gano	31	32	96.9	4	4	13	13	9	9	5	6	55
Chris Boswell	19	20	95	5	5	6	6	7	8	1	1	59
Younghoe Koo	37	39	94.9	10	10	11	12	8	9	8	8	54
Daniel Cartson	33	35	94.3	18	18	8	8	3	5	4	4	54
Cairo Santos	30	32	93.8	9	9	10	10	9	10	2	3	55
Nick Folk	26	28	92.9	6	6	7	7	11	12	2	3	51
Harrison Butker	23	25	92	7	7	9	9	3	5	4	4	58
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 shouldNOT 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	100
Daniel Cartson	100	100	60	100
Cairo Santos	100	100	90	66.67
Nick Folk	100	100	91.67	66.67
Harrison Butker	100	100	60	100
Q2. q20 denotes the proportion of each player's attempts in the range of 20 to 29 yards out of the total attempt. Please fill in the columns for the proportion of each player's four ranges of yards. Then, please fill in the overall field goal percentage in theF column. (F =q20F20 +q30F30 +q40F40+ q50F50)
	q20	q30	q40	q50	F	FG%
Graham Gano	12.5	40.625	28.125	15.625	96.9	96.9
Chris Boswell	25	30	35	5	95.0	95
Younghoe Koo	25.641026	28.205128	20.512821	20.512821	94.9	94.9
Daniel Cartson	51.428571	22.857143	8.5714286	11.428571	94.3	94.3
Cairo Santos	28.125	31.25	28.125	6.25	93.8	93.8
Nick Folk	21.428571	25	39.285714	7.1428571	92.9	92.9
Harrison Butker	28	36	12	16	92.0	92
Q3. In Table 1, FG% is a simple percentage from all field goals made (FGM) and its all attempt (Att). Compared with FG%, whose overall field goal percentage (F ) has been changed the most dramatically when we consider their attempt percentage per distance (i.e., the four ranges of yards) in Q2.
Name:
Cairo Santos
Q4. We want to adjust F for the distances of the attempts. Thus, it would be as follows:F*=p20F20+p30F30+ p40F40+P50F50. For specified "standard" values, we assume that the proportion of all NFL field goal attempts in 2020 in the various ranges are below. Please fill in adjustedFto the highlighted cellsby using an Excel formula that starts with the equal sign.
	p20	p30	p40	p50
Specified standard values	0.291	0.265	0.306	0.138
	F*
Graham Gano
Chris Boswell
Younghoe Koo
Daniel Cartson
Cairo Santos
Nick Folk
Harrison Butker
Q5. According to the FG% in Table 1, Graham Gano is ranked first, and Harrison Butker is ranked seventh. In Q2, we consider kickers' attempt percentage per distance. However, there were different conditions per kicker. Thus, to control the differences, we used the specified "standard" values to find the adjusted overall field goal percentage (F*) in Q4. When we overall field goal percentage, who is ranked fourth?
Name:
Q6. (page 73-77 in the textbook) Table 3 in this sheet provides top receiving yard performances, and top players' mean, SD states from 2013 to 2020. By using the "=STANDARDIZE" formula, fill in the Z-Score column. Then, please adjust the 'Receiving Yeards' column to the conditions of 2019 as a "standard" season. Based on the formula given below, you must show the process of Excel formulas that start the equal sign. Please input the adjustments in the 'Adj-Top' column.
		Y 0 = Receiving Yards of adjustment year
		Y bar 1 = mean of 2019 (standard year)
		Y bar 0 = mean of adjustment year
		S 0 = SD of adjustment year
		S 1 = SD of 2019 (standard year)
Table 3.Top receiving yard performances in different eras, Mean, and standard deviation of top players
Player	Year	Receiving Yards		Mean	SD	Z-Score	Adj-Top
Stefon Diggs	2020	1535	924	225	2.715556
Michael Thomas	2019	1725	948	359	3.453333	1725
Julio Jones	2018	1677	768	322	4.04
Antonio Brown	2017	1533	685	245	3.768889
T.Y. Hilton	2016	1448	784	192	2.951111
Josh Gordon	2013	1646	698	331	4.213333
Q7. According to the adjustment, who has the highest receiving yards in the same condition of 2019?
Name: