A Simple Linear Regression (SLR) was performed where the monthly Revenue ("Rev", the y-variable) was regressed on the monthly Advertising Expenditures ("Expend", the x-variable). The Excel-generated Regression output is provided below: ANOVA df SS MS F Significance F Regression 1 492.528125 492.528125 10.65525634 0.046980871 Residual 3 138.671875 46.22395833 Total 4 631.2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 23.1328125 5.324310936 4.344752359 0.022510469 6.188478833 40.07714617 Expend 3.1015625 0.950164031 3.264239014 0.046980871 0.077716489 6.125408511 a. From the Excel-generated Regression output above, give the value of b0, the estimated y-intercept. Round off your answer to the fourth decimal place. b0 =____.b. From the Excel-generated Regression output above, give the value of b1 , the estimated slope. Round off your answer to the fourth decimal place. b1 = _________

A Simple Linear Regression (SLR) was performed where the monthly Revenue ("Rev", the y-variable) was regressed on the monthly Advertising Expenditures ("Expend", the x-variable). The Excel-generated...

A Simple Linear Regression (SLR) was performed where the monthly Revenue ("Rev", the y-variable) was regressed on the monthly Advertising Expenditures ("Expend", the x-variable). The Excel-generated Regression output is provided below:

ANOVA
	df	SS	MS	F	Significance F
Regression	1	492.528125	492.528125	10.65525634	0.046980871
Residual	3	138.671875	46.22395833
Total	4	631.2

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	23.1328125	5.324310936	4.344752359	0.022510469	6.188478833	40.07714617
Expend	3.1015625	0.950164031	3.264239014	0.046980871	0.077716489	6.125408511

a. From the Excel-generated Regression output above, give the value of b0, the estimated y-intercept. Round off your answer to the fourth decimal place. b0 =____.

b. From the Excel-generated Regression output above, give the value of b1 , the estimated slope. Round off your answer to the fourth decimal place. b1 = _________

Jun 06, 2022

SOLUTION.PDF

A Simple Linear Regression (SLR) was performed where the monthly Revenue ("Rev", the y-variable) was regressed on the monthly Advertising Expenditures ("Expend", the x-variable). The Excel-generated...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment