Question

After reading these instructions delete all text in this shaded area. B C D E F G HI J Conf Yds Atin At Win% Part a. 66 0043 501 After reading these instructens delete all text in this shaded area. K XLMiner Analysis ToolPak * Team 2 Arona Cardinals NFC Anova: Single Factor Carolina Panthers NFC Anova: Two-Factor With Replication 73 60 0.033 0.027 374 56.4 AFC Use the XL Miner Analysis ToolPak to conduct Your Linear regression and After deleting text in this shaded set the output range in the Toolpa Anova: Two-Factor Without Replication Your Linear Regression analysis outout should fit into this shaded area Correlation AFC Covariance Green Bay Packer 8 Houstan Texans 9 Indianapolis Colts 10 Jacksonville Jaguars 11 Minnesota Vikings 12 New England Patriots 13 New Orleans Saints 14 Oakland Raiders 15 San Francisco 49ers 16 Tennessee Titans 17 Washington Redskins AFC 82 0021 Descriptive Statistics AFC Exponential Smoothing 0.044 0.012 NFC 64 AFC F.Test Two-Sample for Variances NFC 64 0042 Fourier Analysis Histogram Linear Regression After reading these instructions delete all text in this shaded area Logistic Regression Use the XL Miner Analysis ToolPak to conduct Your Linear Regression After deleting text in this shaded set the output range in the Toolpa Moving Average

Answer 1

a)

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.75936039
R Square	0.576628203
Adjusted R Square	0.54638736
Standard Error	15.86459535
Observations	16
ANOVA
	df	SS	MS	F	Significance F
Regression	1	4799.1021	4799.1021	19.0678616	0.000644911
Residual	14	3523.5954	251.6853857
Total	15	8322.6975
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-61.58557523	26.81919763	-2.2963243	0.037611447	-119.1070331	-4.06411735	-119.1070331	-4.06411735
Yds/Att	16.9548875	3.88279013	4.366676264	0.000644911	8.627130943	25.28264406	8.627130943	25.28264406

Win% =  -61.6 + 17.1 * Yds/Att

b₀ = -61.6

b₁ = 17.1

b)

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.661574968
R Square	0.437681438
Adjusted R Square	0.397515827
Standard Error	18.28349624
Observations	16
ANOVA
	df	SS	MS	F	Significance F
Regression	1	3642.690213	3642.690213	10.89691957	0.005251321
Residual	14	4680.007287	334.2862348
Total	15	8322.6975
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	98.90772185	14.28325928	6.924730548	7.041E-06	68.27317759	129.5422661	68.27318	129.5423
Int/Att	-1613.371444	488.7451865	-3.301048253	0.005251321	-2661.62561	-565.1172774	-2661.63	-565.117

Win% = 99.0 - 1613.4 * Int/Att

b₀ = 99.0

b₁ = -1613.4

c)

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.866058155
R Square	0.750056729
Adjusted R Square	0.711603918
Standard Error	12.64972557
Observations	16
ANOVA
	df	SS	MS	F	Significance F
Regression	2	6242.495261	3121.24763	19.50590112	0.00012189
Residual	13	2080.202239	160.0155569
Total	15	8322.6975
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-6.983913381	28.06791485	-0.248821953	0.807386275	-67.62095676	53.65313	-67.62095676	53.65313
Yds/Att	13.37303061	3.317726265	4.030781788	0.001426991	6.205518788	20.54054243	6.205518788	20.54054
Int/Att	-1088.328739	362.3671995	-3.003386455	0.010172434	-1871.175477	-305.4820005	-1871.175477	-305.482

Win% = -7.1 + 13.4 * Yds/Att - 1088.3 * Int/Att

b₀ = -7.1

d)

Given  Yds/Att = 6.2 and Int/Att = 0.036

Win% = -7.1 + 13.4 * Yds/Att - 1088.3 * Int/Att

Win% = -7.1 + 13.4 * 6.2 - 1088.3 * 0.036

Win% = -7.1 + 83.08 - 39.1788 = 36.8012 = 37% nearly

Actual % = Win / (Win + Loss) = 7/(7+9) = 43.75%

Predicted % < Actual %