estimate the magnitude of effect are high or low from the fo

estimate the magnitude of effect are high or low from the following table and explain effects of which variables are posive and negative.

Descriptive table

variable

Mean

Standard Deviaton

Minimum

Maximum

rooms

6.2841

0.7026

3.56

8.78

dist

3.7958

2.1061

1.13

12.13

radial

9.5494

8.7073

1

24

proptax

40.8237

16.8537

18.7

71.1

stratio

18.4593

2.1658

12.6

22

lowstat

12.7015

7.2381

1.73

39.07

houseprice

22511.5099

9208.8562

5000

50001

crime

3.6115

8.5902

0.006

88.976

nox

5.5498

1.1584

3.85

8.71

Regression Results

Coefficients

Standard Error

t Stat

P-value

Intercept

8.4610

0.5230

16.1794

0.0000

rooms

0.0210

0.0545

0.3857

0.6999

dist

-0.3061

0.0161

-18.9965

0.0000

radial

0.0204

0.0080

2.5553

0.0109

proptax

0.0165

0.0041

4.0373

0.0001

stratio

-0.1238

0.0152

-8.1355

0.0000

lowstat

0.0132

0.0063

2.0903

0.0371

houseprice

0.0000

0.0000

-5.0729

0.0000

crime

-0.0102

0.0041

-2.5054

0.0126

variable	Mean	Standard Deviaton	Minimum	Maximum
rooms	6.2841	0.7026	3.56	8.78
dist	3.7958	2.1061	1.13	12.13
radial	9.5494	8.7073	1	24
proptax	40.8237	16.8537	18.7	71.1
stratio	18.4593	2.1658	12.6	22
lowstat	12.7015	7.2381	1.73	39.07
houseprice	22511.5099	9208.8562	5000	50001
crime	3.6115	8.5902	0.006	88.976
nox	5.5498	1.1584	3.85	8.71

Solution

Sol)

The Regression mdoel is

y=8.4610 + 0.0210 (X1) - -0.3061(X2) + 0.0204(X3) + 0.0165(X4) - 0.1238 (X5) +0.0132 (X6) +0.000 (X7) -0.0102 (X8)

From above model there is Positive correlation between Y and rooms, radial, proptax,lowstat

And Negetive correlation between Y and dist, stratio,crime.