Question 1408 Given below are five observations collected in

{Question 14.08}

Given below are five observations collected in a regression study on two variables, x (independent variable) and y (dependent variable) (3 Decimals) Please use Excel: Regression .

Develop the least squares estimated regression equation.

At 95% confidence,

Summary Output
*Regression Statics*
Multiple R	$\"This$
R Square	$\"This$
Adjusted R Square	$\"This$
Standard Error	$\"This$
Observations	$\"This$
ANOVA
	df	SS	MS	F	*Significance F*
Regression	$\"This$	$\"This$	$\"This$	$\"This$	$\"This$
Residual	$\"This$	$\"This$	$\"This$
Total	$\"This$	$\"This$
	*Coefficients*	*Standard Error*	*t Stat*	*P-value*
Intercept	$\"This$	$\"This$	$\"This$	$\"This$
x	$\"This$	$\"This$	$\"This$	$\"This$

{Question 14.08} Given below are five observations collected in a regression study on two variables, x (independent variable) and y (dependent variable) (3 Decimals) Please use Excel: Regression . Compute the coefficient of correlation. = 0.05. Compute the coefficient of determination. x At 95% confidence, Let - = Develop the least squares estimated regression equation. x Coefficients Standard Error t Stat P-value Intercept Total Residual ANOVA df SS MS F Significance F Regression Observations Standard Error Adjusted R Square R Square Summary Output Regression Statics Multiple R

the least squares estimated regression equation is

Y=6-0.8X

the coefficient of determination that is

R Squared =0.9411

coefficient of correlation is -0.97014

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.970143
R Square	0.941176
Adjusted R Square	0.921569
Standard Error	0.365148
Observations	5

ANOVA
	df	SS	MS	F	Significance F
Regression	1	6.4	6.4	48	0.006165
Residual	3	0.4	0.133333
Total	4	6.8

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	6	0.489898	12.24745	0.001172	4.440926	7.559074
X Variable 1	-0.8	0.11547	-6.9282	0.006165	-1.16748	-0.43252

{Question 14.08} Given below are five observations collected in a regression study on two variables, x (independent variable) and y (dependent variable) (3 Deci

Question 1408 Given below are five observations collected in

Solution

Get Help Now

Submit a Take Down Notice