Question:

Answer Outline:

Question 1 - Football Play You are asked to simulate the results of one play in football. The following is expected: Percentage of plays: Running 60%, Passing 35%, QB Scramble 4%, QB Sack 1% Running yards: normal distribution with mean = 5.6 and SD = 3 Passing yards: 60% completion rate where yards gained follows normal distribution with mean = 15 and SD = 5, otherwise pass incomplete for 0 yards. QB Scramble: uniform distribution from 0 to 7 yards QB Sack: uniform distribution of loss from -3 to -7 yards Use Excel to simulate 1000 plays and produce statistics, such as: (a) Average yards per play, (b) Largest gain, (c) Largest loss, (d) Actual distribution of play options, and (e) Number and percentage of plays with loss of yards, 0 to 5 yards, 5 to 10 yards, 10 to 15 yards, and more than 15 yards. Hand in the top portion of your simulation showing the summary results and a small portion of the simulated data. Name: MATH 105 Lab #6 - Question 1 Football Play Play Running Passing QB Scramble QB Sack Play Options Percent Random Range 60% 0.00 0.60 35% 0.60 0.95 4% 0.95 0.99 1% 0.99 1.00 Type Running Passing Complete Mean 5.6 15 60% Std Dev 3.0 5.0 of the time Min Max Type QB Scramble QB Sack -3 Simulation Statistics Play Option Yards Play 1 Average Yards Largest Gain Largest Loss 2 Percentage Play Distribution Option Running Passing QB Scramble QB Sack Frequency Loss 0-5 5 - 10 10 - 15 Over 15 Question 1 - Football Play You are asked to simulate the results of one play in football. The following is expected: Percentage of plays: Running 60%, Passing 35%, QB Scramble 4%, QB Sack 1% Running yards: normal distribution with mean = 5.6 and SD = 3 Passing yards: 60% completion rate where yards gained follows normal distribution with mean = 15 and SD = 5, otherwise pass incomplete for 0 yards. QB Scramble: uniform distribution from 0 to 7 yards QB Sack: uniform distribution of loss from -3 to -7 yards Use Excel to simulate 1000 plays and produce statistics, such as: (a) Average yards per play, (b) Largest gain, (c) Largest loss, (d) Actual distribution of play options, and (e) Number and percentage of plays with loss of yards, 0 to 5 yards, 5 to 10 yards, 10 to 15 yards, and more than 15 yards. Hand in the top portion of your simulation showing the summary results and a small portion of the simulated data. Name: MATH 105 Lab #6 - Question 1 Football Play Play Running Passing QB Scramble QB Sack Play Options Percent Random Range 60% 0.00 0.60 35% 0.60 0.95 4% 0.95 0.99 1% 0.99 1.00 Type Running Passing Complete Mean 5.6 15 60% Std Dev 3.0 5.0 of the time Min Max Type QB Scramble QB Sack -3 Simulation Statistics Play Option Yards Play 1 Average Yards Largest Gain Largest Loss 2 Percentage Play Distribution Option Running Passing QB Scramble QB Sack Frequency Loss 0-5 5 - 10 10 - 15 Over 15