Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

TABLE 15-3 In Hawail, condemnation proceedings are under way to enable private citizens to own the property that the ir homes are built on. Until

image text in transcribed
image text in transcribed
TABLE 15-3 In Hawail, condemnation proceedings are under way to enable private citizens to own the property that the ir homes are built on. Until recently, only estates were permitted to own land, and homeowners leased the land from the estate. In order to comply with the new law, a large Hawaiian estate wants to use regression analysis to estimate the fair market value of the land. The follo wing model was fit to data collected for n= 20 properties, 10 of which are located near a cove. where Y Sale price of property in thousands of dollars X1= Size of property in thousands of square feet X2 1 if property located near cove, 0 if not Using the data collected for the 20 properties, the following partial output obtained from Microsoft Excel is shown: SUMMARY OUTPUT Regression Statistics Multiple R R Square 0.987 0..974 Standard Error 9.5 Observations 20 ANOVA df SS MS F Signif F df SS MS Sign if F Regression 5 28324 5664 62.2 0.0001 3 Residual 14 1279 91 Total 19 29063 Coeff StdError t Stat P-value 6 Intercept 32.1 35.7 -0.90 0.3834 Size 12.2 5.9 2.05 0.0594 Cove 104.3 53.5 1.95 0.0715 Size Cove 17.0 8.5 1.99 0.0661 SizeSq 0.3 0.2 - 1.28 0.2204 SizeSq*Cove -0.3 0.3 1.13 0.2749 12 What is the correlation between Yand the predicted-Y? 92 15 974 18 8464 9.5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

School Finance Elections

Authors: Don E. Lifto, Bradford J. Senden, Daniel A. Domenech

2nd Edition

ISBN: 1607091488, 978-1607091486

More Books

Students also viewed these Finance questions

Question

What is continental drift? Where is it occurring?

Answered: 1 week ago