Share
Explore BrainMass

Regression for effect of sack yardage on quarterback rating.

Analyze the effect of sack yardage has on quarterback rating.

a)Does the sack yardage predict the QB rating?

b)What is the regression equation and is this a significant equation?

c)What is your prediction for the QB rating of a quarterback that has 300 sack yards?

Player sack
yardage quarterback rating
1 0 131.9
2 0 122.2
3 22 118.1
4 45 101.4
5 108 100.4
6 0 100
7 107 99
8 8 98.6
9 54 96.6
10 196 96.4
11 130 92.6
12 73 91.2
13 48 90.6
14 137 90.4
15 0 90.3
16 46 89.7
17 246 88.8
18 195 88.8
19 3 88.2
20 249 87.4
21 219 85.9
22 15 84.8
23 57 84.3
24 160 82.9
25 27 82.8
26 111 81.5
27 288 81.4
28 168 80.6
29 104 80.1
30 25 79.7
31 253 79.6
32 0 78.8
33 116 77.6
34 206 75.8
35 242 75.3
36 41 74.8
37 166 74.6
38 90 73.5
39 371 73
40 90 73
41 38 72.9
42 126 72.4
43 125 72.3
44 185 71.4
45 164 70.7
46 174 70.3
47 132 69.6
48 90 69.5
49 83 69.2
50 64 69

Solution Preview

Please see the attachments

Q1 Analyze the effect of sack yardage has on quarterback rating.
a. Does the sack yardage predict the QB rating?
b. What is the regression equation and is this a significant equation?
c. What is your prediction for the QB rating of a quarterback that has 300 sack yards

Answer

We can observe a ...

Solution Summary

The solution provides step by step method for the calculation of Regression for effect of sack yardage on quarterback rating.. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.

$2.19