Data Analysis -

profilesloezh
NationalFootballLeague.xlsx
Home>Mathematics homework help>Statistics homework help>Data Analysis -

Scatter Plot5

Scatter Plot

Fumbles Recovered 11 12 6 12 16 17 16 10 10 16 18 9 14 15 10 8 8 16 12 10 10 6 8 8 14 18 10 14 9 19 12 10 12 9 26 7 12 13 10 9 5 14 14 9 17 5 13 13 13 16 6 12 14 6 17 12 8 8 17 11 9 12 17 18

X

Y

PlotData10

Fumbles Fumbles Recovered
11 12
12 9
6 26
12 7
16 12
17 13
16 10
10 9
10 5
16 14
18 14
9 9
14 17
15 5
10 13
8 13
8 13
16 16
12 6
10 12
10 14
6 6
8 17
8 12
14 8
18 8
10 17
14 11
9 9
19 12
12 17
10 18

Residual Plot5

Residual Plot

Residuals 11 12 6 12 16 17 16 10 10 16 18 9 14 15 10 8 8 16 12 10 10 6 8 8 14 18 10 14 9 19 12 10 -0.18840579710144922 -3 12.869565217391305 -5 0.75362318840579512 1.9420289855072443 -1.2463768115942049 -3.3768115942028984 -7.3768115942028984 2.7536231884057951 3.1304347826086936 -3.5652173913043477 5.3768115942028967 -6.4347826086956541 0.62318840579710155 0.2463768115942031 0.2463768115942031 4.7536231884057951 -6 -0.37681159420289845 1.6231884057971016 -7.1304347826086953 4.2463768115942031 -0.7536231884057969 -3.6231884057971033 -2.8695652173913064 4.6231884057971016 -0.62318840579710333 -3.5652173913043477 1.3188405797101428 5 5.6231884057971016

X

Residuals

PlotData9

Fumbles Residuals
11 -0.1884057971
12 -3
6 12.8695652174
12 -5
16 0.7536231884
17 1.9420289855
16 -1.2463768116
10 -3.3768115942
10 -7.3768115942
16 2.7536231884
18 3.1304347826
9 -3.5652173913
14 5.3768115942
15 -6.4347826087
10 0.6231884058
8 0.2463768116
8 0.2463768116
16 4.7536231884
12 -6
10 -0.3768115942
10 1.6231884058
6 -7.1304347826
8 4.2463768116
8 -0.7536231884
14 -3.6231884058
18 -2.8695652174
10 4.6231884058
14 -0.6231884058
9 -3.5652173913
19 1.3188405797
12 5
10 5.6231884058

Residuals5

Observation Fumbles Predicted Y Fumbles Recovered Residuals
1 11 12.1884057971 12 -0.1884057971
2 12 12 9 -3
3 6 13.1304347826 26 12.8695652174
4 12 12 7 -5
5 16 11.2463768116 12 0.7536231884
6 17 11.0579710145 13 1.9420289855
7 16 11.2463768116 10 -1.2463768116
8 10 12.3768115942 9 -3.3768115942
9 10 12.3768115942 5 -7.3768115942
10 16 11.2463768116 14 2.7536231884
11 18 10.8695652174 14 3.1304347826
12 9 12.5652173913 9 -3.5652173913
13 14 11.6231884058 17 5.3768115942
14 15 11.4347826087 5 -6.4347826087
15 10 12.3768115942 13 0.6231884058
16 8 12.7536231884 13 0.2463768116
17 8 12.7536231884 13 0.2463768116
18 16 11.2463768116 16 4.7536231884
19 12 12 6 -6
20 10 12.3768115942 12 -0.3768115942
21 10 12.3768115942 14 1.6231884058
22 6 13.1304347826 6 -7.1304347826
23 8 12.7536231884 17 4.2463768116
24 8 12.7536231884 12 -0.7536231884
25 14 11.6231884058 8 -3.6231884058
26 18 10.8695652174 8 -2.8695652174
27 10 12.3768115942 17 4.6231884058
28 14 11.6231884058 11 -0.6231884058
29 9 12.5652173913 9 -3.5652173913
30 19 10.6811594203 12 1.3188405797
31 12 12 17 5
32 10 12.3768115942 18 5.6231884058

SLRData5

Fumbles Fumbles Recovered
11 12
12 9
6 26
12 7
16 12
17 13
16 10
10 9
10 5
16 14
18 14
9 9
14 17
15 5
10 13
8 13
8 13
16 16
12 6
10 12
10 14
6 6
8 17
8 12
14 8
18 8
10 17
14 11
9 9
19 12
12 17
10 18

COMPUTE5

Fumbles Recovered vs Fumbles Calculations
b1, b0 Coefficients -0.1884 14.2609
Regression Statistics b1, b0 Standard Error 0.2229 2.7929
Multiple R 0.1525 R Square, Standard Error 0.0233 4.5362
R Square 0.0233 F, Residual df 0.7142 30.0000
Adjusted R Square -0.0093 Regression SS, Residual SS 14.6957 617.3043
Standard Error 4.5362
Observations 32 Confidence level 95%
t Critical Value 2.0423
ANOVA Half Width b0 5.7038
df SS MS F Significance F Half Width b1 0.4553
Regression 1 14.6957 14.6957 0.7142 0.4047
Residual 30 617.3043 20.5768
Total 31 632.0000
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95% Upper 95%
Intercept 14.2609 2.7929 5.1062 0.0000 8.5570 19.9647 8.5570 19.96469
Fumbles -0.1884 0.2229 -0.8451 0.4047 -0.6437 0.2669 -0.6437 0.26690

Scatter Plot4

Scatter Plot

Passes Intercepted 18 16 17 18 14 16 19 17 19 14 17 19 11 22 20 14 14 15 19 13 15 15 18 11 11 30 12 20 18 16 22 14 24 15 14 14 17 21 20 20 19 15 22 15 21 14 8 20 16 14 9 18 20 19 20 15 14 16 17 13 28 8 17 11

X

Y

PlotData8

Interceptions Passes Intercepted
18 24
16 15
17 14
18 14
14 17
16 21
19 20
17 20
19 19
14 15
17 22
19 15
11 21
22 14
20 8
14 20
14 16
15 14
19 9
13 18
15 20
15 19
18 20
11 15
11 14
30 16
12 17
20 13
18 28
16 8
22 17
14 11

Residual Plot4

Residual Plot

Residuals 18 16 17 18 14 16 19 17 19 14 17 19 11 22 20 14 14 15 19 13 15 15 18 11 11 30 12 20 18 16 22 14 7.4234404536862009 -1.7456116662165826 -2.6610856062651891 -2.5765595463137991 8.5336213880637501E-2 4.2543883337834174 3.5079665136375908 3.3389143937348109 2.5079665136375908 -1.9146637861193625 5.3389143937348109 -1.4920334863624092 3.8317580340264641 -2.2384553065082358 -8.4075074264110192 3.0853362138806375 -0.9146637861193625 -2.8301377261679725 -7.4920334863624092 1.0008101539292475 3.1698622738320275 2.1698622738320275 3.4234404536862009 -2.1682419659735359 -3.1682419659735359 0.43775317310288919 -8.3715906022142406E-2 -3.4075074264110192 11.423440453686201 -8.7456116662165826 0.76154469349176424 -5.9146637861193625

X

Residuals

PlotData7

Interceptions Residuals
18 7.4234404537
16 -1.7456116662
17 -2.6610856063
18 -2.5765595463
14 0.0853362139
16 4.2543883338
19 3.5079665136
17 3.3389143937
19 2.5079665136
14 -1.9146637861
17 5.3389143937
19 -1.4920334864
11 3.831758034
22 -2.2384553065
20 -8.4075074264
14 3.0853362139
14 -0.9146637861
15 -2.8301377262
19 -7.4920334864
13 1.0008101539
15 3.1698622738
15 2.1698622738
18 3.4234404537
11 -2.168241966
11 -3.168241966
30 0.4377531731
12 -0.083715906
20 -3.4075074264
18 11.4234404537
16 -8.7456116662
22 0.7615446935
14 -5.9146637861

Residuals4

Observation Interceptions Predicted Y Passes Intercepted Residuals
1 18 16.5765595463 24 7.4234404537
2 16 16.7456116662 15 -1.7456116662
3 17 16.6610856063 14 -2.6610856063
4 18 16.5765595463 14 -2.5765595463
5 14 16.9146637861 17 0.0853362139
6 16 16.7456116662 21 4.2543883338
7 19 16.4920334864 20 3.5079665136
8 17 16.6610856063 20 3.3389143937
9 19 16.4920334864 19 2.5079665136
10 14 16.9146637861 15 -1.9146637861
11 17 16.6610856063 22 5.3389143937
12 19 16.4920334864 15 -1.4920334864
13 11 17.168241966 21 3.831758034
14 22 16.2384553065 14 -2.2384553065
15 20 16.4075074264 8 -8.4075074264
16 14 16.9146637861 20 3.0853362139
17 14 16.9146637861 16 -0.9146637861
18 15 16.8301377262 14 -2.8301377262
19 19 16.4920334864 9 -7.4920334864
20 13 16.9991898461 18 1.0008101539
21 15 16.8301377262 20 3.1698622738
22 15 16.8301377262 19 2.1698622738
23 18 16.5765595463 20 3.4234404537
24 11 17.168241966 15 -2.168241966
25 11 17.168241966 14 -3.168241966
26 30 15.5622468269 16 0.4377531731
27 12 17.083715906 17 -0.083715906
28 20 16.4075074264 13 -3.4075074264
29 18 16.5765595463 28 11.4234404537
30 16 16.7456116662 8 -8.7456116662
31 22 16.2384553065 17 0.7615446935
32 14 16.9146637861 11 -5.9146637861

SLRData4

Interceptions Passes Intercepted
18 24
16 15
17 14
18 14
14 17
16 21
19 20
17 20
19 19
14 15
17 22
19 15
11 21
22 14
20 8
14 20
14 16
15 14
19 9
13 18
15 20
15 19
18 20
11 15
11 14
30 16
12 17
20 13
18 28
16 8
22 17
14 11

COMPUTE4

Passes Intercepted vs Interceptions Calculations
b1, b0 Coefficients -0.0845 18.0980
Regression Statistics b1, b0 Standard Error 0.2105 3.6036
Multiple R 0.0731 R Square, Standard Error 0.0053 4.5298
R Square 0.0053 F, Residual df 0.1612 30.0000
Adjusted R Square -0.0278 Regression SS, Residual SS 3.3071 615.5679
Standard Error 4.5298
Observations 32 Confidence level 95%
t Critical Value 2.0423
ANOVA Half Width b0 7.3595
df SS MS F Significance F Half Width b1 0.4300
Regression 1 3.3071 3.3071 0.1612 0.6909
Residual 30 615.5679 20.5189
Total 31 618.8750
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95% Upper 95%
Intercept 18.0980 3.6036 5.0222 0.0000 10.7386 25.4575 10.7386 25.45750
Interceptions -0.0845 0.2105 -0.4015 0.6909 -0.5145 0.3455 -0.5145 0.34546

Scatter Plot3

Scatter Plot

Penalty Yards 137 105 107 78 95 111 90 114 104 90 100 113 82 67 76 101 91 86 78 68 77 63 120 83 80 94 97 59 94 81 101 90 1128 891 873 633 801 839 670 868 815 610 676 1006 636 515 594 697 732 662 690 581 652 486 864 649 651 761 702 428 794 614 773 751

X

Y

PlotData6

Penalties Penalty Yards
137 1128
105 891
107 873
78 633
95 801
111 839
90 670
114 868
104 815
90 610
100 676
113 1006
82 636
67 515
76 594
101 697
91 732
86 662
78 690
68 581
77 652
63 486
120 864
83 649
80 651
94 761
97 702
59 428
94 794
81 614
101 773
90 751

Residual Plot3

Residual Plot

Residuals 137 105 107 78 95 111 90 114 104 90 100 113 82 67 76 101 91 86 78 68 77 63 120 83 80 94 97 59 94 81 101 90 52.979724336118124 66.308073013676676 32.662551221329295 19.522617210366661 54.535681975413695 -32.628492363365467 -37.350513543717739 -27.096775051886652 -1.8691660901496334 -97.350513543717739 -109.57812250545476 118.72598584428704 -8.7684263743282145 -12.427012931722629 -3.8318609972859576 -96.400883401628448 16.826725560108457 -14.059469959022977 76.522617210366661 45.75022617210368 46.345378106540352 -10.135969347027867 -78.033340428928796 -3.591187270501905 21.877095418019167 22.358442871587386 -60.109839816933686 -36.844925762333048 55.358442871587386 -22.945665478154524 -20.400883401628448 43.649486456282261

X

Residuals

PlotData5

Penalties Residuals
137 52.9797243361
105 66.3080730137
107 32.6625512213
78 19.5226172104
95 54.5356819754
111 -32.6284923634
90 -37.3505135437
114 -27.0967750519
104 -1.8691660901
90 -97.3505135437
100 -109.5781225055
113 118.7259858443
82 -8.7684263743
67 -12.4270129317
76 -3.8318609973
101 -96.4008834016
91 16.8267255601
86 -14.059469959
78 76.5226172104
68 45.7502261721
77 46.3453781065
63 -10.135969347
120 -78.0333404289
83 -3.5911872705
80 21.877095418
94 22.3584428716
97 -60.1098398169
59 -36.8449257623
94 55.3584428716
81 -22.9456654782
101 -20.4008834016
90 43.6494864563

Residuals3

Observation Penalties Predicted Y Penalty Yards Residuals
1 137 1075.0202756639 1128 52.9797243361
2 105 824.6919269863 891 66.3080730137
3 107 840.3374487787 873 32.6625512213
4 78 613.4773827896 633 19.5226172104
5 95 746.4643180246 801 54.5356819754
6 111 871.6284923634 839 -32.6284923634
7 90 707.3505135437 670 -37.3505135437
8 114 895.0967750519 868 -27.0967750519
9 104 816.8691660901 815 -1.8691660901
10 90 707.3505135437 610 -97.3505135437
11 100 785.5781225055 676 -109.5781225055
12 113 887.2740141557 1006 118.7259858443
13 82 644.7684263743 636 -8.7684263743
14 67 527.4270129317 515 -12.4270129317
15 76 597.8318609973 594 -3.8318609973
16 101 793.4008834016 697 -96.4008834016
17 91 715.1732744399 732 16.8267255601
18 86 676.059469959 662 -14.059469959
19 78 613.4773827896 690 76.5226172104
20 68 535.2497738279 581 45.7502261721
21 77 605.6546218935 652 46.3453781065
22 63 496.135969347 486 -10.135969347
23 120 942.0333404289 864 -78.0333404289
24 83 652.5911872705 649 -3.5911872705
25 80 629.122904582 651 21.877095418
26 94 738.6415571284 761 22.3584428716
27 97 762.1098398169 702 -60.1098398169
28 59 464.8449257623 428 -36.8449257623
29 94 738.6415571284 794 55.3584428716
30 81 636.9456654782 614 -22.9456654782
31 101 793.4008834016 773 -20.4008834016
32 90 707.3505135437 751 43.6494864563

SLRData3

Penalties Penalty Yards
137 1128
105 891
107 873
78 633
95 801
111 839
90 670
114 868
104 815
90 610
100 676
113 1006
82 636
67 515
76 594
101 697
91 732
86 662
78 690
68 581
77 652
63 486
120 864
83 649
80 651
94 761
97 702
59 428
94 794
81 614
101 773
90 751

COMPUTE3

Penaly Yards vs Penalties Calculations
b1, b0 Coefficients 7.8228 3.3020
Regression Statistics b1, b0 Standard Error 0.5606 52.2568
Multiple R 0.9309 R Square, Standard Error 0.8665 54.3405
R Square 0.8665 F, Residual df 194.7119 30.0000
Adjusted R Square 0.8620 Regression SS, Residual SS 574963.1474 88586.7276
Standard Error 54.3405
Observations 32 Confidence level 95%
t Critical Value 2.0423
ANOVA Half Width b0 106.7225
df SS MS F Significance F Half Width b1 1.1449
Regression 1 574963.1474 574963.1474 194.7119 0.0000
Residual 30 88586.7276 2952.8909
Total 31 663549.8750
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95% Upper 95%
Intercept 3.3020 52.2568 0.0632 0.9500 -103.4205 110.0246 -103.4205 110.02456
Penalties 7.8228 0.5606 13.9539 0.0000 6.6778 8.9677 6.6778 8.96769

Scatter Plot2

Scatter Plot

Opponent Rushing Yards/ Game 330.2 355.5 301.60000000000002 362.9 324.8 354.7 348.8 359.6 307.60000000000002 336 377.6 313.3 344.2 279.7 313.8 319.39999999999998 342.2 338.1 288.3 348.1 305 331.9 341.6 311.39999999999998 266.39999999999998 320.3 346.2 321.8 341.1 278.39999999999998 291.60000000000002 305.3 97.9 127.1 79.3 124.6 110.7 122.9 118.3 129.5 94.6 142.6 119.4 102.9 114.1 106.9 100.3 130.6 153.5 74.099999999999994 98.3 102.9 97.7 134.80000000000001 145.9 95.8 89.9 107 118.5 102.8 115.3 107.9 92.4 91.3

X

Y

PlotData4

Opponent Yards/ Game Opponent Rushing Yards/ Game
330.2 97.9
355.5 127.1
301.6 79.3
362.9 124.6
324.8 110.7
354.7 122.9
348.8 118.3
359.6 129.5
307.6 94.6
336 142.6
377.6 119.4
313.3 102.9
344.2 114.1
279.7 106.9
313.8 100.3
319.4 130.6
342.2 153.5
338.1 74.1
288.3 98.3
348.1 102.9
305 97.7
331.9 134.8
341.6 145.9
311.4 95.8
266.4 89.9
320.3 107
346.2 118.5
321.8 102.8
341.1 115.3
278.4 107.9
291.6 92.4
305.3 91.3

Residual Plot2

Residual Plot

Residuals 330.2 355.5 301.60000000000002 362.9 324.8 354.7 348.8 359.6 307.60000000000002 336 377.6 313.3 344.2 279.7 313.8 319.39999999999998 342.2 338.1 288.3 348.1 305 331.9 341.6 311.39999999999998 266.39999999999998 320.3 346.2 321.8 341.1 278.39999999999998 291.60000000000002 305.3 -14.939743089608314 4.5425461849397522 -22.554504878227888 -0.79978817744539299 -6.5607203543478931E-2 0.64982557546788655 -1.6839889193872182 5.3677393084831095 -9.5591003071888281 27.532481329062776 -11.646046978399653 -3.4484659647016969 -4.1171324238504923 13.457268437479527 -6.2405155837817858 21.908528682521364 36.051066052469835 -41.774127071073551 1.5540149893021749 -16.815119452675091 -5.4604422879723984 21.307288205519441 28.681525595365898 -9.8186774121974025 1.5657883050096046 -2.03716063182278 62 -0.48533090017080838 -6.8133094890630161 -1.7264247855540304 14.956597447087731 -5.6135124966263277 -11.975672059420461

X

Residuals

PlotData3

Opponent Yards/ Game Residuals
330.2 -14.9397430896
355.5 4.5425461849
301.6 -22.5545048782
362.9 -0.7997881774
324.8 -0.0656072035
354.7 0.6498255755
348.8 -1.6839889194
359.6 5.3677393085
307.6 -9.5591003072
336 27.5324813291
377.6 -11.6460469784
313.3 -3.4484659647
344.2 -4.1171324239
279.7 13.4572684375
313.8 -6.2405155838
319.4 21.9085286825
342.2 36.0510660525
338.1 -41.7741270711
288.3 1.5540149893
348.1 -16.8151194527
305 -5.460442288
331.9 21.3072882055
341.6 28.6815255954
311.4 -9.8186774122
266.4 1.565788305
320.3 -2.0371606318
346.2 -0.4853309002
321.8 -6.8133094891
341.1 -1.7264247856
278.4 14.9565974471
291.6 -5.6135124966
305.3 -11.9756720594

Residuals2

Observation Opponent Yards/ Game Predicted Y Opponent Rushing Yards/ Game Residuals
1 330.2 112.8397430896 97.9 -14.9397430896
2 355.5 122.5574538151 127.1 4.5425461849
3 301.6 101.8545048782 79.3 -22.5545048782
4 362.9 125.3997881774 124.6 -0.7997881774
5 324.8 110.7656072035 110.7 -0.0656072035
6 354.7 122.2501744245 122.9 0.6498255755
7 348.8 119.9839889194 118.3 -1.6839889194
8 359.6 124.1322606915 129.5 5.3677393085
9 307.6 104.1591003072 94.6 -9.5591003072
10 336 115.0675186709 142.6 27.5324813291
11 377.6 131.0460469784 119.4 -11.6460469784
12 313.3 106.3484659647 102.9 -3.4484659647
13 344.2 118.2171324239 114.1 -4.1171324239
14 279.7 93.4427315625 106.9 13.4572684375
15 313.8 106.5405155838 100.3 -6.2405155838
16 319.4 108.6914713175 130.6 21.9085286825
17 342.2 117.4489339475 153.5 36.0510660525
18 338.1 115.8741270711 74.1 -41.7741270711
19 288.3 96.7459850107 98.3 1.5540149893
20 348.1 119.7151194527 102.9 -16.8151194527
21 305 103.160442288 97.7 -5.460442288
22 331.9 113.4927117945 134.8 21.3072882055
23 341.6 117.2184744046 145.9 28.6815255954
24 311.4 105.6186774122 95.8 -9.8186774122
25 266.4 88.334211695 89.9 1.565788305
26 320.3 109.0371606318 107 -2.0371606318
27 346.2 118.9853309002 118.5 -0.4853309002
28 321.8 109.6133094891 102.8 -6.8133094891
29 341.1 117.0264247856 115.3 -1.7264247856
30 278.4 92.9434025529 107.9 14.9565974471
31 291.6 98.0135124966 92.4 -5.6135124966
32 305.3 103.2756720594 91.3 -11.9756720594

SLRData2

Opponent Yards/ Game Opponent Rushing Yards/ Game Opponent Passing Yards/ Game
330.2 97.9 232.3
355.5 127.1 228.4
301.6 79.3 222.3
362.9 124.6 238.4
324.8 110.7 214.1
354.7 122.9 231.8
348.8 118.3 230.4
359.6 129.5 230.1
307.6 94.6 213.1
336 142.6 193.4
377.6 119.4 258.2
313.3 102.9 210.4
344.2 114.1 230.1
279.7 106.9 172.8
313.8 100.3 213.5
319.4 130.6 188.9
342.2 153.5 188.7
338.1 74.1 264.1
288.3 98.3 190.1
348.1 102.9 245.3
305 97.7 207.3
331.9 134.8 197.1
341.6 145.9 195.8
311.4 95.8 215.6
266.4 89.9 176.5
320.3 107 213.3
346.2 118.5 227.7
321.8 102.8 219.1
341.1 115.3 225.8
278.4 107.9 170.5
291.6 92.4 199.2
305.3 91.3 214

COMPUTE2

Opponent Yards Calculations
b1, b0 Coefficients 0.3841 -13.9898
Regression Statistics b1, b0 Standard Error 0.1065 34.7480
Multiple R 0.5500 R Square, Standard Error 0.3025 16.0071
R Square 0.3025 F, Residual df 13.0108 30.0000
Adjusted R Square 0.2793 Regression SS, Residual SS 3333.7044 7686.8044
Standard Error 16.0071
Observations 32 Confidence level 95%
t Critical Value 2.0423
ANOVA Half Width b0 70.9648
df SS MS F Significance F Half Width b1 0.2175
Regression 1 3333.7044 3333.7044 13.0108 0.0011
Residual 30 7686.8044 256.2268
Total 31 11020.5088
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95% Upper 95%
Intercept -13.9898 34.7480 -0.4026 0.6901 -84.9546 56.9750 -84.9546 56.97497
Opponent Yards/ Game 0.3841 0.1065 3.6070 0.0011 0.1666 0.6016 0.1666 0.60157

Scatter Plot

Scatter Plot

Rushing Yards/ Game 344.1 301 302 277.10000000000002 284.89999999999998 293.2 348 351.3 365.7 346.3 322.89999999999998 370.7 333.6 358.7 357.4 276.8 287.5 336.2 411.2 361.2 331.4 294.7 294.8 358.1 327.39999999999998 315.2 237.3 348.9 297.5 326.8 311.7 333.4 90 95 112.3 112.5 114 83.1 97.3 118.4 109.1 122.3 80.5 99.8 99.1 106.6 149.4 78 98.1 164.6 115.6 91.6 134.30000000000001 106.3 130.4 123.4 135.5 127.4 92.3 101.2 95.4 117 131.80000000000001 116.9

X

Y

PlotData2

Yards/Game Rushing Yards/ Game
344.1 90
301 95
302 112.3
277.1 112.5
284.9 114
293.2 83.1
348 97.3
351.3 118.4
365.7 109.1
346.3 122.3
322.9 80.5
370.7 99.8
333.6 99.1
358.7 106.6
357.4 149.4
276.8 78
287.5 98.1
336.2 164.6
411.2 115.6
361.2 91.6
331.4 134.3
294.7 106.3
294.8 130.4
358.1 123.4
327.4 135.5
315.2 127.4
237.3 92.3
348.9 101.2
297.5 95.4
326.8 117
311.7 131.8
333.4 116.9

Residual Plot

Residual Plot

Residuals 344.1 301 302 277.10000000000002 284.89999999999998 293.2 348 351.3 365.7 346.3 322.89999999999998 370.7 333.6 358.7 357.4 276.8 287.5 336.2 411.2 361.2 331.4 294.7 294.8 358.1 327.39999999999998 315.2 237.3 348.9 297.5 326.8 311.7 333.4 -23.448897935981819 -12.65909318042722 4.5065726025065516 8.0514946074557372 8.5036877143391223 -23.511286287310611 -16.672801382540129 3.9838957011413072 -7.2505170246124351 8.5555667864724541 -30.101012534177698 -17.222188109943602 -12.938388656786401 -8.8101775051488147 34.164456977037304 -26.408205127424395 -7.7455812500330978 52.212342378841413 -6.8627239011260031 -24.146013047814392 22.55714662075934 -0.51278761290996044 23.573778965383426 8.0704230250909319 24.294483489024259 17.8333609372323 -6.8020035533082392 -12.893702177899726 -11.788923420695397 5.8750840192639942 22.703530696964108 4.8884781866268696

X

Residuals

PlotData

Yards/Game Residuals
344.1 -23.448897936
301 -12.6590931804
302 4.5065726025
277.1 8.0514946075
284.9 8.5036877143
293.2 -23.5112862873
348 -16.6728013825
351.3 3.9838957011
365.7 -7.2505170246
346.3 8.5555667865
322.9 -30.1010125342
370.7 -17.2221881099
333.6 -12.9383886568
358.7 -8.8101775051
357.4 34.164456977
276.8 -26.4082051274
287.5 -7.74558125
336.2 52.2123423788
411.2 -6.8627239011
361.2 -24.1460130478
331.4 22.5571466208
294.7 -0.5127876129
294.8 23.5737789654
358.1 8.0704230251
327.4 24.294483489
315.2 17.8333609372
237.3 -6.8020035533
348.9 -12.8937021779
297.5 -11.7889234207
326.8 5.8750840193
311.7 22.703530697
333.4 4.8884781866

Residuals

Observation Yards/Game Predicted Y Rushing Yards/ Game Residuals
1 344.1 113.448897936 90 -23.448897936
2 301 107.6590931804 95 -12.6590931804
3 302 107.7934273975 112.3 4.5065726025
4 277.1 104.4485053925 112.5 8.0514946075
5 284.9 105.4963122857 114 8.5036877143
6 293.2 106.6112862873 83.1 -23.5112862873
7 348 113.9728013825 97.3 -16.6728013825
8 351.3 114.4161042989 118.4 3.9838957011
9 365.7 116.3505170246 109.1 -7.2505170246
10 346.3 113.7444332135 122.3 8.5555667865
11 322.9 110.6010125342 80.5 -30.1010125342
12 370.7 117.0221881099 99.8 -17.2221881099
13 333.6 112.0383886568 99.1 -12.9383886568
14 358.7 115.4101775051 106.6 -8.8101775051
15 357.4 115.235543023 149.4 34.164456977
16 276.8 104.4082051274 78 -26.4082051274
17 287.5 105.84558125 98.1 -7.74558125
18 336.2 112.3876576212 164.6 52.2123423788
19 411.2 122.4627239011 115.6 -6.8627239011
20 361.2 115.7460130478 91.6 -24.1460130478
21 331.4 111.7428533792 134.3 22.5571466208
22 294.7 106.8127876129 106.3 -0.5127876129
23 294.8 106.8262210346 130.4 23.5737789654
24 358.1 115.3295769749 123.4 8.0704230251
25 327.4 111.205516511 135.5 24.294483489
26 315.2 109.5666390628 127.4 17.8333609372
27 237.3 99.1020035533 92.3 -6.8020035533
28 348.9 114.0937021779 101.2 -12.8937021779
29 297.5 107.1889234207 95.4 -11.7889234207
30 326.8 111.1249159807 117 5.8750840193
31 311.7 109.096469303 131.8 22.703530697
32 333.4 112.0115218134 116.9 4.8884781866

SLRData

Yards/Game Rushing Yards/ Game Passing Yards/ Game
344.1 90 254.1
301 95 206
302 112.3 189.7
277.1 112.5 164.6
284.9 114 170.9
293.2 83.1 210.1
348 97.3 250.8
351.3 118.4 232.9
365.7 109.1 256.6
346.3 122.3 224
322.9 80.5 242.4
370.7 99.8 270.9
333.6 99.1 234.4
358.7 106.6 252.1
357.4 149.4 208
276.8 78 198.8
287.5 98.1 189.4
336.2 164.6 171.6
411.2 115.6 295.7
361.2 91.6 269.6
331.4 134.3 197.1
294.7 106.3 188.4
294.8 130.4 164.4
358.1 123.4 234.7
327.4 135.5 191.9
315.2 127.4 187.8
237.3 92.3 145
348.9 101.2 247.8
297.5 95.4 202.1
326.8 117 209.8
311.7 131.8 179.9
333.4 116.9 216.4

COMPUTE

Home Teams Yards Calculations
b1, b0 Coefficients 0.1343 67.2245
Regression Statistics b1, b0 Standard Error 0.0993 32.4736
Multiple R 0.2398 R Square, Standard Error 0.0575 19.6062
R Square 0.0575 F, Residual df 1.8308 30.0000
Adjusted R Square 0.0261 Regression SS, Residual SS 703.7612 11532.0538
Standard Error 19.6062
Observations 32 Confidence level 95%
t Critical Value 2.0423
ANOVA Half Width b0 66.3199
df SS MS F Significance F Half Width b1 0.2028
Regression 1 703.7612 703.7612 1.8308 0.1861
Residual 30 11532.0538 384.4018
Total 31 12235.8150
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95% Upper 95%
Intercept 67.2245 32.4736 2.0701 0.0471 0.9046 133.5444 0.9046 133.54438
Yards/Game 0.1343 0.0993 1.3531 0.1861 -0.0684 0.3371 -0.0684 0.33709

Sheet4

Yards/Game Opponent Yards/ Game
Yards/Game 1
Opponent Yards/ Game -0.3488688905 1

Correlation

Points/Game Yards/Game Opponent Yards/ Game Passing Yards/ Game Opponent Passing Yards/ Game Rushing Yards/ Game Opponent Rushing Yards/ Game
Points/Game 1
Yards/Game 0.8943996558 1
Opponent Yards/ Game -0.3799062838 -0.3488688905 1
Passing Yards/ Game 0.7563284474 0.8468125326 -0.118489489 1
Opponent Passing Yards/ Game -0.0914214169 -0.0647498121 0.725998747 0.0147723529 1
Rushing Yards/ Game 0.2165766205 0.2398259659 -0.4066061168 -0.3132800407 -0.142700225 1
Opponent Rushing Yards/ Game -0.4326556239 -0.4206669587 0.5500000378 -0.1875274545 -0.1750372904 -0.4086247466 1

NFL Data

National Football League Data 2007 Season
Team Points/Game Yards/Game Opponent Yards/ Game Passing Yards/ Game Opponent Passing Yards/ Game Rushing Yards/ Game Opponent Rushing Yards/ Game Penalties Penalty Yards Interceptions Fumbles Passes Intercepted Fumbles Recovered
Arizona Cardinals 25.2 344.1 330.2 254.1 232.3 90 97.9 137 1,128 18 11 24 12
Atlanta Falcons 16.2 301 355.5 206 228.4 95 127.1 105 891 16 12 15 9
Baltimore Ravens 17.2 302 301.6 189.7 222.3 112.3 79.3 107 873 17 6 14 26
Buffalo Bills 15.8 277.1 362.9 164.6 238.4 112.5 124.6 78 633 18 12 14 7
Carolina Panthers 16.7 284.9 324.8 170.9 214.1 114 110.7 95 801 14 16 17 12
Chicago Bears 20.9 293.2 354.7 210.1 231.8 83.1 122.9 111 839 16 17 21 13
Cincinnati Bengals 23.8 348 348.8 250.8 230.4 97.3 118.3 90 670 19 16 20 10
Cleveland Browns 25.1 351.3 359.6 232.9 230.1 118.4 129.5 114 868 17 10 20 9
Dallas Cowboys 28.4 365.7 307.6 256.6 213.1 109.1 94.6 104 815 19 10 19 5
Denver Broncos 20 346.3 336 224 193.4 122.3 142.6 90 610 14 16 15 14
Detroit Lions 21.6 322.9 377.6 242.4 258.2 80.5 119.4 100 676 17 18 22 14
Green Bay Packers 27.2 370.7 313.3 270.9 210.4 99.8 102.9 113 1,006 19 9 15 9
Houston Texans 23.7 333.6 344.2 234.4 230.1 99.1 114.1 82 636 11 14 21 17
Indianapolis Colts 28.1 358.7 279.7 252.1 172.8 106.6 106.9 67 515 22 15 14 5
Jacksonville Jaguars 25.7 357.4 313.8 208 213.5 149.4 100.3 76 594 20 10 8 13
Kansas City Chiefs 14.1 276.8 319.4 198.8 188.9 78 130.6 101 697 14 8 20 13
Miami Dolphins 16.7 287.5 342.2 189.4 188.7 98.1 153.5 91 732 14 8 16 13
Minnesota Vikings 22.8 336.2 338.1 171.6 264.1 164.6 74.1 86 662 15 16 14 16
New England Patriots 36.8 411.2 288.3 295.7 190.1 115.6 98.3 78 690 19 12 9 6
New Orleans Saints 23.7 361.2 348.1 269.6 245.3 91.6 102.9 68 581 13 10 18 12
New York Giants 23.3 331.4 305 197.1 207.3 134.3 97.7 77 652 15 10 20 14
New York Jets 16.8 294.7 331.9 188.4 197.1 106.3 134.8 63 486 15 6 19 6
Oakland Raiders 17.7 294.8 341.6 164.4 195.8 130.4 145.9 120 864 18 8 20 17
Philadelphia Eagles 21 358.1 311.4 234.7 215.6 123.4 95.8 83 649 11 8 15 12
Pittsburgh Steelers 24.6 327.4 266.4 191.9 176.5 135.5 89.9 80 651 11 14 14 8
San Diego Chargers 25.8 315.2 320.3 187.8 213.3 127.4 107 94 761 30 18 16 8
San Francisco 49ers 13.7 237.3 346.2 145 227.7 92.3 118.5 97 702 12 10 17 17
Seattle Seahawks 24.6 348.9 321.8 247.8 219.1 101.2 102.8 59 428 20 14 13 11
St. Louis Rams 16.4 297.5 341.1 202.1 225.8 95.4 115.3 94 794 18 9 28 9
Tampa Bay Buccaneers 20.9 326.8 278.4 209.8 170.5 117 107.9 81 614 16 19 8 12
Tennessee Titans 18.8 311.7 291.6 179.9 199.2 131.8 92.4 101 773 22 12 17 17
Washington Redskins 20.9 333.4 305.3 216.4 214 116.9 91.3 90 751 14 10 11 18

Sheet1

Points/Game
Mean 21.69375
Standard Error 0.88252453
Median 21.3
Mode 20.9
Standard Deviation 4.992312639
Sample Variance 24.92318548
Kurtosis 1.136544836
Skewness 0.679111389
Range 23.1
Minimum 13.7
Maximum 36.8
Sum 694.2
Count 32
Confidence Level(95.0%) 1.799920646

CompleteStatistics

Descriptive Summary
Points/Game Yards/ Game Rushing Yards/ Game Passing Yards/ Game Opponent Yards/ Game Opponent Rushing Yards/ Game Opponent Passing Yards/ Game Penalties Penalty Yards Interceptions Fumbles Passes Intercepted Fumbles Recovered
Mean 21.69375 325.21875 110.9125 214.309375 325.23125 110.93125 214.321875 91.625 720.0625 16.6875 12 16.6875 12
Median 21.3 329.4 110.7 208.9 327.5 107.45 214.05 90.5 693.5 16.5 11.5 16.5 12
Mode 20.9 ERROR:#N/A ERROR:#N/A ERROR:#N/A ERROR:#N/A 102.9 230.1 90 ERROR:#N/A 14 10 14 12
Minimum 13.7 237.3 78 145 266.4 74.1 170.5 59 428 11 6 8 5
Maximum 36.8 411.2 164.6 295.7 377.6 153.5 264.1 137 1128 30 19 28 26
Range 23.1 173.9 86.6 150.7 111.2 79.4 93.6 78 700 19 13 20 21
Variance 24.9232 1258.0280 394.7037 1315.5712 728.9177 355.5003 524.6179 303.0806 21404.8347 14.9315 13.3548 19.9637 20.3871
Standard Deviation 4.9923 35.4687 19.8672 36.2708 26.9985 18.8547 22.9045 17.4092 146.3039 3.8641 3.6544 4.4681 4.5152
Coeff. of Variation 23.01% 10.91% 17.91% 16.92% 8.30% 17.00% 10.69% 19.00% 20.32% 23.16% 30.45% 26.77% 37.63%
Skewness 0.6791 -0.1187 0.6153 0.2484 -0.3166 0.3449 0.0006 0.3397 0.5877 1.1766 0.2877 0.0930 0.7715
Kurtosis 1.1365 0.3355 0.4381 -0.5733 -0.4600 -0.1997 -0.1929 0.2345 0.9761 3.2651 -0.9731 0.3994 1.5276
Count 32 32 32 32 32 32 32 32 32 32 32 32 32
Standard Error 0.8825 6.2700 3.5120 6.4118 4.7727 3.3331 4.0490 3.0775 25.8631 0.6831 0.6460 0.7899 0.7982

DataCopy

Points/Game Yards/Game Rushing Yards/ Game Passing Yards/ Game Opponent Yards/ Game Opponent Rushing Yards/ Game Opponent Passing Yards/ Game Penalties Penalty Yards Interceptions Fumbles Passes Intercepted Fumbles Recovered
25.2 344.1 90 254.1 330.2 97.9 232.3 137 1,128 18 11 24 12
16.2 301 95 206 355.5 127.1 228.4 105 891 16 12 15 9
17.2 302 112.3 189.7 301.6 79.3 222.3 107 873 17 6 14 26
15.8 277.1 112.5 164.6 362.9 124.6 238.4 78 633 18 12 14 7
16.7 284.9 114 170.9 324.8 110.7 214.1 95 801 14 16 17 12
20.9 293.2 83.1 210.1 354.7 122.9 231.8 111 839 16 17 21 13
23.8 348 97.3 250.8 348.8 118.3 230.4 90 670 19 16 20 10
25.1 351.3 118.4 232.9 359.6 129.5 230.1 114 868 17 10 20 9
28.4 365.7 109.1 256.6 307.6 94.6 213.1 104 815 19 10 19 5
20 346.3 122.3 224 336 142.6 193.4 90 610 14 16 15 14
21.6 322.9 80.5 242.4 377.6 119.4 258.2 100 676 17 18 22 14
27.2 370.7 99.8 270.9 313.3 102.9 210.4 113 1,006 19 9 15 9
23.7 333.6 99.1 234.4 344.2 114.1 230.1 82 636 11 14 21 17
28.1 358.7 106.6 252.1 279.7 106.9 172.8 67 515 22 15 14 5
25.7 357.4 149.4 208 313.8 100.3 213.5 76 594 20 10 8 13
14.1 276.8 78 198.8 319.4 130.6 188.9 101 697 14 8 20 13
16.7 287.5 98.1 189.4 342.2 153.5 188.7 91 732 14 8 16 13
22.8 336.2 164.6 171.6 338.1 74.1 264.1 86 662 15 16 14 16
36.8 411.2 115.6 295.7 288.3 98.3 190.1 78 690 19 12 9 6
23.7 361.2 91.6 269.6 348.1 102.9 245.3 68 581 13 10 18 12
23.3 331.4 134.3 197.1 305 97.7 207.3 77 652 15 10 20 14
16.8 294.7 106.3 188.4 331.9 134.8 197.1 63 486 15 6 19 6
17.7 294.8 130.4 164.4 341.6 145.9 195.8 120 864 18 8 20 17
21 358.1 123.4 234.7 311.4 95.8 215.6 83 649 11 8 15 12
24.6 327.4 135.5 191.9 266.4 89.9 176.5 80 651 11 14 14 8
25.8 315.2 127.4 187.8 320.3 107 213.3 94 761 30 18 16 8
13.7 237.3 92.3 145 346.2 118.5 227.7 97 702 12 10 17 17
24.6 348.9 101.2 247.8 321.8 102.8 219.1 59 428 20 14 13 11
16.4 297.5 95.4 202.1 341.1 115.3 225.8 94 794 18 9 28 9
20.9 326.8 117 209.8 278.4 107.9 170.5 81 614 16 19 8 12
18.8 311.7 131.8 179.9 291.6 92.4 199.2 101 773 22 12 17 17
20.9 333.4 116.9 216.4 305.3 91.3 214 90 751 14 10 11 18