Given below are four observations collected in a regression

Given below are four observations collected in a regression study on two variables x (independent variable) and y (dependent variable) (Please use excel).

fill in the table above

Summary Output
Regression Statics (2 decimals)
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
	df	SS	MS	F	Significance F=0.02
Regression
Residual
Total
	Coefficients	Standard Error	t Stat	P-value
Intercept				0.05
x				0.02

Given below are four observations collected in a regression study on two variables x (independent variable) and y (dependent variable) (Please use excel). fill in the table above Develop the least squares estimated regression equation. At 95% confidence, perform a t test and determine whether or not the slope is significantly different from zero. What is your conclusion? - Select your answer -Conclude that slope is significantly different from zero Do not conclude that slope is significantly different from zero Perform an F test to determine whether or not the model is significant. Let = 0.05. - Select your answer -Conclude that model is significant Do not conclude that model Compute the coefficient of determination.

Solution

Regression Statistics Multiple R 0.977008 R Square 0.954545 Adjusted R Square 0.931818 Standard Error 0.564076 Observations 4 ANOVA df SS MS F Significance F Regression 1 13.36364 13.36364 42 0.022992 Residual 2 0.636364 0.318182 Total 3 14 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2.863636 0.697793 4.10385 0.0546 -0.13872 5.866 -0.13872 5.865996 x 0.636364 0.098193 6.480741 0.023 0.213873 1.05885 0.213873 1.058854