Question

Suppose you are a rabid football fan and you get into a discussion about the importance of offense (yards made) versus defense (yards allowed) in terms of winning a game. You decide to look at football statistics to provide evidence of which variable is a stronger predictor of wins.

Can use the minitab. Part a) Develop a simple linear regression that compares wins to yards made (please show me the scatter plot) . Perform the following diagnostics on this regression: 1) test of significance on the slope; 2) assess the fit of the line using the appropriate statistics; 3) interpret the slope of the equation if the slope is significant. Part b) Develop a simple linear regression that compares wins against yards allowed. Perform the following diagnostics on this regression: 1) test of significance on the slope; 2) assess the fit of the line using the appropriate statistics; 3) interpret the slope of the equation if the slope is significant. Part c) Which explanatory variable provides a better prediction of the response variable? Support your answer briefly by citing the appropriate diagnostics. Note: Use an alpha of .05 for both tests of significance. Be sure to show ALL steps of the hypothesis testing procedure

EXCEL DATA TO USE.

Team	Win	Rush	Pass	Yds Allowed	Yds Made
Arizona Cardinals	62.50	93.40	251.00	346.40	344.40
Atlanta Falcons	56.30	117.21	223.19	348.90	340.40
Baltimore Ravens	56.30	137.51	213.69	305.00	351.20
Buffalo Bills	37.50	116.71	157.19	340.60	273.90
Carolina Panthers	50.00	156.16	174.94	315.80	331.10
Chicago Bears	43.80	93.24	217.06	337.80	310.30
Cincinnati Bengals	62.50	128.48	180.63	301.40	309.10
Cleveland Browns	31.30	130.45	129.75	389.30	260.20
Dallas Cowboys	68.80	131.46	267.94	315.90	399.40
Denver Broncos	50.00	114.71	226.69	315.00	341.40
Detroit Lions	12.50	101.00	198.00	392.10	299.00
Green Bay Packers	68.80	117.85	261.25	284.40	379.10
Houston Texans	56.30	92.23	290.88	324.90	383.10
Indianapolis Colts	87.50	80.91	282.19	339.20	363.10
Jacksonville Jaguars	53.80	126.85	209.75	352.30	336.60
Kansas City Chiefs	25.00	120.58	182.63	388.20	303.20
Miami Dolphins	43.80	139.48	198.13	349.30	337.60
Minnesota Vikings	75.00	119.85	259.75	305.50	379.60
New England Patriots	62.50	120.05	277.25	320.20	397.30
New Orleans Saints	81.30	131.61	272.19	357.80	403.80
New York Giants	50.00	114.81	251.19	324.90	366.00
New York Jets	56.30	172.25	148.75	252.30	321.00
Oakland Raiders	31.30	106.29	159.81	361.90	266.10
Philadelphia Eagles	68.80	102.34	255.56	321.10	357.90
Pittsburgh Steelers	56.30	112.05	259.25	305.30	371.30
Saint Louis Rams	6.30	111.50	167.88	327.00	279.38
San Diego Chargers	81.30	88.94	271.13	326.40	360.06
San Francisco 49ers	50.00	100.00	190.75	356.40	290.75
Seattle Seahawks	31.30	97.86	218.94	372.80	316.80
Tampa Bay Buccaneers	18.80	101.69	185.81	365.60	287.50
Tennessee Titans	50.00	161.96	189.44	365.60	351.40
Washington Redskins	25.00	94.38	218.13	319.70	312.50

Answer 1

Solulion Suppese thad yeu ae a rabd feotball fan and yoau jet mto a discussin about the importance of offense ersus defens in tesms af wiming a qame Heve, we have to decide to look at foolball stalis.- lis lics to Provide evidene f the variable is a stronger Prediclor of wins Part- OU Regression Analy sis win Versus yds Mode Cniven the Regression equalion is win 190t 03s6 yds Mode The t-test for the oefficienct is given belew; se coefT P Value onstant 1403000 yds Mode 0-38603 0 0838 66 0000

2) R-s9 and R-s^, ladj) «re givn below which explain houw the best eqession tine fHs the daka 53.0% R-sV:59.3.1. (adj) R-5 Here we have Rsy 543 which mply hat bo of variaion n tom (dependenk vania bile) is explained 6 ds Mode lindependenl variable) since the caefficient 3s6os is sanigicant as Calculate icane level Heve we hav Cefpiciente 0 38603 which imply thot a unit charge in yds No de lin dependen Vaia ble ll039 503 im wim (dependent Vasia ble p-Value -o 000 is less than 005 Si egse ssion Analysis win Versus yds Allowed The วิ'egression equ The regse ssion equahon is win- 1S1-0 300 Yds Allowed

arstant 151-0 .05430 o0od ds Mode o 3004 -93 0-0010 how best the vegession lne fils the data av wich implies hat of variab ion in win (dependent variable) is explained the Yds Allooed lindependent vasiable) since the caefpcients 3003 as alculated P-value -o07o is less than 005 signii ance evel we have coefficient 3003 whic ples that unit change m yds Aleved Indepe- ndent variable) wil 7esult-o-3003 ;ท uin(dependent Vatia ble)

Past The explanalovy vasiable (yds Node pocvides a beterpedchn f the esponse variabie om as Rsy nrespondmg to first madel (oin-70 t0-396 yds Mode) is R-ss 5-3h and R-s9 Cosvesponding to second modell win I5-o 300 A loued) is.sqz2งา ./.