Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Game Comp Att Yds TD Int Row Game Comp Att Yds TD Int 1 37 54 450 2 1 13 12 19 39 273 1

Game Comp Att Yds TD Int Row Game Comp Att Yds TD Int
1 37 54 450 2 1 13 12 19 39 273 1 0
2 24 36 273 4 0 8 7 31 42 338 1 0
3 19 38 238 1 1 12 11 22 39 185 2 1
4 28 39 285 0 0 14 13 21 32 224 1 3
5 21 37 226 0 1 14 13 21 32 224 1 3
6 30 40 371 4 0 6 5 21 37 226 0 1
7 31 42 338 1 0 12 11 22 39 185 2 1
8 21 30 281 0 1 5 4 28 39 285 0 0
9 25 35 284 3 1 6 5 21 37 226 0 1
10 19 37 232 0 2 12 11 22 39 185 2 1
11 22 39 185 2 1 9 8 21 30 281 0 1
12 19 39 273 1 0 17 16 29 44 265 2 0
13 21 32 224 1 3 12 11 22 39 185 2 1
14 34 49 356 3 0 14 13 21 32 224 1 3
15 27 35 300 2 0 15 14 34 49 356 3 0
16 29 44 265 2 0 11 10 19 37 232 0 2
Total 407 626 4581 26 11 Total 374 606 3894 18 18
Rating(%) 65.02 Rating(%) 61.72
Talbe 1 Table 2
Aspeadsheet of Matt Ryan's game-by-game results A simulated season for Matt Ryan
Note. Comp = Passes completed; Att = Passes attempted; Yds = Yards gained by passing; Int = Interceptions thrown
Rating(%) = Percentage of passes completed
In this Practice, we will find out the true interval of Ryan's percentage of passes completed (Rating %) in the 2020 season by using the margin of error. (p. 97-99, 112)
Q1. First, fill in the "Row" column in Table 2 by using the Excel command "=RANDBETWEEN". We want to choose a random integer from 2 to 17. So, if you complete the command correctly, every time you run it, the cell will select a random number from 2 to 17. This is just a number but does not mean a row number. However, this random number will help to simulate Ryan's actual stats as the guideline of row number. Hint. You can use the auto-fill function, but all cells will be the same.
Q2. Next, fill in the simulated "Game" column (from I2 to I17) in Table 2 by using the Excel command "=INDIRECT". The original "Game" in Table 1 is from A2 to A17. For using the command "=INDIRECT", you need a "reference letter" for a column and a "cell location" for a random number of a row. As the example of the textbook, the command "=INDIRECT("B"&$H2)" means "finding the number on the location of B column and some row based on the random number in cell H2." Hint. You can use the auto-fill function. The "cell location" will be changed, but the "reference letter" will be maintained.
Q3. Please fill in the other columns in Table 2 bu using the Excel command "=INDIRECT". Hint. The "reference letter" in the command should be matched with correct column in Table 1.
Q4. Please fill in the total and rating(%) in Table 2 by using the Excel command (=SUM) and formula (=Comp/Att*100).
Q5. Now, we are ready to simulate the 2020 season of Ryan's game-by-game results. To run the simulation, we will use "Calculation Options" in the top menu, Formulas - Calculation Options - Automatic, as the screenshot below. Every time you click the 'Automatic' button (or you can simply double-click any cell and click another cell), you can see all numbers of Table 2 will be calculated again. First, please fill in the "Simulated Rating" row in Table 3 manually by clicking the 'Automatic' button ten times. Next, using the numbers in the "Simulated Rating" row, calculated standard deviation (SD) in cell B47. Youmust use "=STDEV.S" Excel command. Lastly, the margin of error is twice the standard deviation. Fill in cell B48 by using the Excel formula.

1st 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
Simulated Rating (%) 63.55 65.22 65.83 64.98 65.28 59.25 64.19 66.29 65.89 64.63
Standard Deviation (SD) of the 10 simulations 2.023174
Margin of Error (SD*2) 4.046348
Table 3
A simulated of Ryan's percentage of passes completed and the margin of error
Q6. As you can see in Table 1, the actual value of Ryan's percentage of passes completed (Rating) is 65.02% in the 2020 season. Finally, according to the simulations, what is the variability in Ryan's percentage of passes completed (Rating) values by the interval? Hint. The answer should be an interval (A, B)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Prealgebra

Authors: Elayn Martin Gay

7th edition

321955048, 978-0321955043

More Books

Students also viewed these Mathematics questions