8/4/2019 Eco No Metric Assignment 3

1/11

DATASET CLOSE DataSet0.

REGRESSION

/MISSING LISTWISE

/STATISTICS COEFF OUTS R ANOVA

/CRITERIA=PIN(.05) POUT(.10)

/NOORIGIN

/DEPENDENT Price

/METHOD=ENTER County Size Elevation Sewer Date Flood Distance

/PARTIALPLOT ALL

/RESIDUALS HISTOGRAM(ZRESID) NORMPROB(ZRESID)

/SAVE PRED ZPRED.

Regression

[DataSet2] C:\Users\Prashant\Downloads\Econometrics_Assignment1.sav

MethodVariablesRemoved

VariablesEntered

1 Enter .Distance,

Date, Sewer,

Flood,

Elevation,

Size, Countya

ModelModel

Variables Entered/Removedb

a. All requested variables entered.

b. Dependent Variable: Price

Std. Error ofthe Estimate

Adjusted RSquareR SquareR

1 4.43148.670.747.864a

ModelModel

Model Summaryb

a. Predictors: (Constant), Distance, Date, Sewer, Flood,Elevation, Size, County

b. Dependent Variable: Price

Sig.FMean Squaredf

Sum of

SquaresRegression

Residual

Total

1

301785.497

19.63823451.675

.000a

9.703190.54671333.822

ModelModel

ANOVAb

a. Predictors: (Constant), Distance, Date, Sewer, Flood, Elevation, Size, County

b. Dependent Variable: Price

Page 1

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

2/11

Std. ErrorB Beta Sig.t

StandardizedCoefficientsUnstandardized Coefficients

(Constant)

County

Size

Elevation

Sewer

Date

Flood

Distance

1

.589.547.109.340.186

.001-4.020-.5822.989-12.015

.0941.749.270.049.085

.031-2.296-.308.000-.001

.0402.177.293.239.519

.098-1.726-.256.004-.006

.025-2.407-.5643.652-8.789

.0006.1743.82923.643

ModelModel

Coefficientsa

a. Dependent Variable: Price

NStd. DeviationMeanMaximumMinimum

Predicted Value

Residual

Std. Predicted Value

Std. Residual 31.876.0002.941-1.166

311.000.0001.854-1.948

313.88019.0000013.03151-5.16915

316.6678911.951624.3153-1.0397

Residuals Statistics

a

a. Dependent Variable: Price

Charts

Page 2

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

3/11

Regression Standardized Residual

3210-1-2

Frequency

8

6

4

2

0

Histogram

Dependent Variable: Price

Mean = 5.20E-16

Std. Dev. = 0.876N = 31

Page 3

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

4/11

Observed Cum Prob

1.00.80.60.40.20.0

Ex

pectedCumProb

1.0

0.8

0.6

0.4

0.2

0.0

Normal P-P Plot of Regression Standardized Residual

Dependent Variable: Price

Page 4

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

5/11

County

0.400.200.00-0.20-0.40-0.60

Price

20.00

15.00

10.00

5.00

0.00

-5.00

-10.00

Partial Regression Plot

Dependent Variable: Price

Page 5

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

6/11

Size

1000.00800.00600.00400.00200.000.00-200.00-400.00

Price

15.00

10.00

5.00

0.00

-5.00

-10.00

Partial Regression Plot

Dependent Variable: Price

Page 6

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

7/11

Elevation

15.0010.005.000.00-5.00

Price

15.00

10.00

5.00

0.00

-5.00

-10.00

Partial Regression Plot

Dependent Variable: Price

Page 7

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

8/11

Sewer

6000.004000.002000.000.00-2000.00-4000.00

Price

20.00

15.00

10.00

5.00

0.00

-5.00

-10.00

Partial Regression Plot

Dependent Variable: Price

Page 8

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

9/11

Date

40.0020.000.00-20.00-40.00-60.00

Price

10.00

5.00

0.00

-5.00

Partial Regression Plot

Dependent Variable: Price

Page 9

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

10/11

Flood

0.750.500.250.00-0.25-0.50

Price

20.00

15.00

10.00

5.00

0.00

-5.00

-10.00

Partial Regression Plot

Dependent Variable: Price

Page 10

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.

8/4/2019 Eco No Metric Assignment 3

11/11

Distance

7.505.002.500.00-2.50

Price

15.00

10.00

5.00

0.00

-5.00

-10.00

Partial Regression Plot

Dependent Variable: Price

Page 11

Generated by Foxit PDF Creator Foxit Softwarehttp://www.foxitsoftware.com For evaluation only.