Based on the data in the following link, please fill in Table 1. Based on your learning in Practice 3, please fill in Tables 2 and 3.
https://www.pro-football-reference.com/players/M/MahoPa00/gamelog/2020/
Game	Comp	Att	Yds	TD
1	24	32	211	3
2	27	47	302	2
3	31	42	385	4
4	19	29	236	2
5	22	43	340	2
6	21	26	225	2
7	15	23	200	1
8	31	42	416	5
9	30	45	372	4
10	34	45	348	2
11	37	49	462	3
12	25	40	318	1
13	24	34	393	2
14	26	47	254	3
15	24	44	278	2
16	0	0	0	0
Total	390	588	4740	38
Rating of passes completed (%)	66.32653	< - Do NOT use percentage cell format
Talbe 1
A spreadsheet of Patrick Mahomes's game-by-game results in 2020 regular season
Note. Comp = Passes completed; Att = Passes attempted; Yds = Yards gained by passing; Int = Interceptions thrown
Row	Comp	Att	Yds	TD
8	31	42	385	4
9	19	29	236	2
15	34	45	348	2
9	19	29	236	2
8	31	42	385	4
8	31	42	385	4
8	31	42	385	4
6	24	32	211	3
9	19	29	236	2
15	34	45	348	2
21	0	0	0	0
6	24	32	211	3
6	24	32	211	3
9	19	29	236	2
7	27	47	302	2
14	30	45	372	4
Total	397	562	4487	43
Rating of passes completed (%)	70.64057	< - Do NOT use percentage cell format
Talbe 2
A simulator of Patrick Mahomes in the 2020 regular season
Simulation No.	Simulated Rating (%)
1	63.87435
2	70.14925
3	67.51468
4	67.51468
5	61.12805
6	67.24138
7	64.07767
8	68.04836
9	64.93056
10	64.92411
11	63.03901
12	68.03738
13	66.25578
14	65.74394
15	68.31683
16	67.08464
17	63.56822
18	67.33668
19	67.98561
20	73.47611
	2.7498399	Standard Deviation
	5.50	Margin of Error	<- Round to two decimal places

"Let's assume that Matt Ryan's passes completed rating in the 2020 season was 65.02%, with a margin of error of 4.29 based on 20 simulations. The game numbers (16) and simulation numbers (20) are the same to compare Matt Ryan and Patrick Mahomes. So, we simply use the margin of errors of both players to compare their passes' completed rating in the 2020 season. (Hint. see page 107-108.)

Q2. What is the difference between the passes completed rating in the 2020 season for Ryan and Mahomes? Who has a higher rating?" "Q3. What is the difference with a margin of error between Ryan and Mahomes? (Hint. Please use '=SQRT()' command to calculate a sqaure root. You must show your Excel formula) " Q4. Is the difference of the passes completed rating in the 2020 season for Ryan and Mahomes (Q2) statistically significant? Why or why not?