Question

Question 1 4.5 pts Given are five observations for two variables, x and y. 3 2 7

Answer 1

Sol:

Perform regression in excel

In excel go to

Data>Data analysis regression

select X and Y

File Home Insert Page Layout Formulas Data Colectica Review View H elp Tell me what you w 1 x for x A B C D E F G H I J K L X Y vw Regression ? X Input Input Y Range: Ток $B$1:$B$6 1 14 Cancel Input X Range: $A$1:$A$6 Help Labels Confidence Level: Constant is Zero 95 % Output options O Output Range: New Worksheet Ply: O New Workbook Residuals Residuals Standardized Residuals Residual Plots Line Fit Plots

click ok

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.919239
R Square	0.845
Adjusted R Square	0.793333
Standard Error	2.03306
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	1	67.6	67.6	16.35484	0.027215
Residual	3	12.4	4.133333
Total	4	80
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	0.2	2.132291	0.093796	0.931185	-6.5859	6.985903
X	2.6	0.64291	4.044112	0.027215	0.553973	4.646027

ANSWERS;

Solution-h:

	df	SS	MS
Regression	1	67.6	67.6
Residual	3	12.4	4.133333
Total	4	80

MSE=4.133

Solution-i:

Standard Error

2.03306

Se=2.03306

Solution-j:

	Coefficients	Standard Error
Intercept	0.2	2.132291
X	2.6	0.64291

Standard error of slope=0.643

ANSWER:

0,643

Solution-k:

	Coefficients	Standard Error	t Stat	P-value
X	2.6	0.64291	4.044112	0.027215

t=4.04,p-0.0272

ANSWER:

MARK OPTION C

t=4.044,p value is between 0.02 and 0.05 ,Reject Ho.

Solution-l:

F=16.354,p=.0272

p<0.05

F=16.36,p value is between 0.025 and 0.05,Reject Ho

Reject Ho

OPTION B

Solution-m:

Ho:Beta1<=0

Ha:beta1>0

t=

t Stat	P-value
4.044112	0.027215

p value is between  0.02 AND 0.05

Reject Ho

OPTION D