answ 7 Irterzept Floor Offices Etrances Aoe Freeway Freeway

7. Irterzept Floor Offices Etrances Aoe Freeway Freeway Entrance Trve Fast

Solution

As you have already the data available in excel you are suppose to just follow follwoing steps .

In excel you have Data --- Data Analysis -- Regression

Input range is Assessed column data only.

Output range there are many parameters so select all the columns

In the new work sheet you will get all the required columns

sample file is given below

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.9

R Square

0.28

Adjusted R Square

0.26

Standard Error

17.26

Observations

100.00

ANOVA

df

SS

MS

F

Significance F

Regression

3.00

11232.80

3744.27

12.57

0.0

Residual

96.00

28595.44

297.87

Total

99.00

39828.24

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

40.49

10.10

4.01

0.00

20.4

60.5

(X1)

0.22

0.12

1.85

0.07

0.0

0.4

(X2)

0.55

0.13

4.27

0.00

0.3

0.8

(x3)

0.12

0.30

0.40

0.69

-0.5

0.7

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.9
R Square	0.28
Adjusted R Square	0.26
Standard Error	17.26
Observations	100.00
ANOVA
	df	SS	MS	F	Significance F
Regression	3.00	11232.80	3744.27	12.57	0.0
Residual	96.00	28595.44	297.87
Total	99.00	39828.24
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	40.49	10.10	4.01	0.00	20.4	60.5
(X1)	0.22	0.12	1.85	0.07	0.0	0.4
(X2)	0.55	0.13	4.27	0.00	0.3	0.8
(x3)	0.12	0.30	0.40	0.69	-0.5	0.7