Question

In: Economics

Appraised Value Property Size Age 467.8 0.2249 44 363.9 0.2169 56 429.9 0.1631 27 540.5 0.4672...

Appraised Value Property Size Age
467.8 0.2249 44
363.9 0.2169 56
429.9 0.1631 27
540.5 0.4672 18
405.8 0.2523 47
375.2 0.2214 86
318.2 0.1864 46
748.4 0.5062 7
212.8 0.2274 59
632.4 0.1385 13
349.4 0.1749 58
356.5 0.4216 49
359.6 0.2518 43
273.9 0.1158 17
303.8 0.1685 62
280.9 0.1746 58
390.4 0.3873 46
617.5 0.6578 47
313.9 0.1718 58
361.8 0.1425 75

1. Construct a​ 95% confidence interval estimate for the the mean appraised value for houses that have a land area of 0.15 acres and is 35 years old.

2. Construct a​ 95% prediction interval estimate for the the mean appraised value for houses that have a land area of 0.15 acres and is 35 years old.

Need process.

Solutions

Expert Solution

It shall be noted that regression of Appraisal Value on Property Size and Age is given as follows, as estimated using Excel - Data Analysis Tool Pack based Regression

1)

Using the data analysis tool pack - Descriptive statistics, compute the descriptive summary of the variable - Appraisal value

Appraised Value
Mean 405.13
Standard Error 30.15225147
Median 362.85
Mode #N/A
Standard Deviation 134.8449679
Sample Variance 18183.16537
Kurtosis 1.071007329
Skewness 1.197199183
Range 535.6
Minimum 212.8
Maximum 748.4
Sum 8102.6
Count 20
Confidence Level(95.0%) 63.10938761

The mean value is 405.13 and the confidence level (95%) is 63.10938761

Hence, the 95% confidence interval estimate for the mean of the appraised value for house is given as:

Lower Limit = 405.13 - 63.10938761 = 342.0206124

Upper Limit = 405.13 + 63.10938761 = 468.2393876

Thus, 95% confidence interval estimate is [342.0206124 , 468.2393876]

2)

Estimate the regression of Appraised value on Property Size and Age of the House.

The result is:

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.761188758
R Square 0.579408326
Adjusted R Square 0.529926952
Standard Error 92.45223613
Observations 20
ANOVA
df SS MS F Significance F
Regression 2 200174.0706 100087.0353 11.70962496 0.000635061
Residual 17 145306.0714 8547.415965
Total 19 345480.142
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 428.6181491 73.52043378 5.829918664 2.00871E-05 273.5035926 583.7327055 273.5035926 583.7327055
Property Size 449.8693026 150.5123253 2.988920021 0.008247175 132.3160539 767.4225512 132.3160539 767.4225512
Age -3.101505555 1.06908272 -2.901090342 0.009939578 -5.357072932 -0.845938177 -5.357072932 -0.845938177

The Predicted value of Appraised value at 0.15 land size and 35 years as age of house is:

428.6181491 + 449.8693026*0.15 + (-3.101505555*35) = 492.9970389

Using the 95% coefficient of Intercept, Property Size and Age , compute the Lower Prediction Limit as given below:

273.5035926 + 132.3160539*0.15 + (-5.357072932*35) = 105.8534481

Using the 95% coefficient of Intercept, Property Size and Age , compute the Upper Prediction Limit as given below:

583.7327055 + 767.4225512*0.15 + (-0.845938177*35) = 669.238252

Thus, 95% prediction interval estimate is [105.8534481 , 669.238252]


Related Solutions

A problem of interest is the relationship between the appraised value of a property and its...
A problem of interest is the relationship between the appraised value of a property and its sale price. The sale price for any given property will vary depending on the price set by the seller, the strength of appeal of the property to a specific buyer, and the state of the money and real estate markets. We want to examine the relationship between the mean sale price E(y) of a property and the variables: appraised land value of the property,...
A property has a maturing loan and needs to be refinanced. It is appraised at $25...
A property has a maturing loan and needs to be refinanced. It is appraised at $25 million based on a cap rate of 6%. Your lender has put two constraints on your next loan. It must have debt service coverage of 1.5x and LTV of 50%.  Interest rates are 5% and the lender offers you a 10-year loan with a 20- year amortization schedule. Which constraint limits your loan? How much can you borrow?
1. On July 6, Zonker Company acquired the plant assets of Doonesbury Company, which had discontinued operations. The appraised value of the property is:
Presented below is information related to Zonker Company.1. On July 6, Zonker Company acquired the plant assets of Doonesbury Company, which had discontinued operations. The appraised value of the property is: Zonker Company gave 12,500 shares of its $100 par value common stock in exchange. The stock had a market price of $168 per share on the date of the purchase of the property.2. Zonker Company expended the following amounts in cash between July 6 and December 15, the date...
The size of the workforce in Germany is 44 million. If 62.5 % of the labor...
The size of the workforce in Germany is 44 million. If 62.5 % of the labor is male, find (a) yhe percent of the labor that is female and (b) the number of workers who are female
The data set  Roslyn in the accompanying workbook gives appraised values (In $1000’s) and size (in square...
The data set  Roslyn in the accompanying workbook gives appraised values (In $1000’s) and size (in square feet)  for thirty houses in the Roslyn neighborhood. a)     Use Excel’s Data Analysis ToolPak to produce output for the simple linear regression, with Valueas the response (y) variable and Size as the predictor (x) variable. b)     Write out the equation of the regression of Value (y) on Size (x) c)      State the numerical value of the slope of the regression line. What does it tell you in this...
Marcia, age 56, is starting to think about retirement. She plans to retire at age 65...
Marcia, age 56, is starting to think about retirement. She plans to retire at age 65 and she expects to liver to age 90. She estimates that she will need $50,000 per year, before tax in retirement to give her the lifestyle she wants. She will receive a non-indexed pension of $25,000 a year plus a combined $12,000 per year in CPP and OAS retirement income. She currently has $70,000 in her RRSP. For planning purposes, Marcia is using a...
A forester measured 27 of the trees in a large forest on property that is for...
A forester measured 27 of the trees in a large forest on property that is for sale. He found a mean diameter of 10.4 inches and a standard deviation of 4.7 inches. Suppose that these trees provide an accurate description of the whole forest and that a Normal model applies.Determine:a) the percent of trees that has a diameter between 10.4 and 16.0 inches.b) the percent of trees that has a diameter greater than 16.0 inches. c) the percent of trees...
Sparta Company exchanged machinery with an appraised value of $4,680,000 a recorded cost of $7,200,000 and...
Sparta Company exchanged machinery with an appraised value of $4,680,000 a recorded cost of $7,200,000 and accumulated depreciation of $3,600,000 with Delphi Corporation for machinery Delphi owns. The machinery has an appraised value of $4,520,000  a recorded cost of $8,640,000 and accumulated depreciation of $4,752,000. Delphi also gave Sparta $160,000 in the exchange. A. Prepare the entries on both companies' books assuming that the exchange had commercial substance. (Round all computations to the nearest dollar.) B. Prepare the entries on both...
Eurelia Sample size = 11, Mean Rent = $453, Standard Deviation = $56 Begonia Sample size...
Eurelia Sample size = 11, Mean Rent = $453, Standard Deviation = $56 Begonia Sample size = 8, Meant Rent = $380, Standard Deviation = $84 a) Using the F tables, test whether the variances are too different to use the pooled variance method rather than Satterthwaite's method b) Test the 5% level whether the mean rent in Eurelia is significantly higher than the mean rent in Begonia c) Estimate the standard error of the difference in mean rents
Eurelia Sample size = 11, Mean Rent = $453, Standard Deviation = $56 Begonia Sample size...
Eurelia Sample size = 11, Mean Rent = $453, Standard Deviation = $56 Begonia Sample size = 8, Meant Rent = $380, Standard Deviation = $84 a) Using the F tables, test whether the variances are too different to use the pooled variance method rather than Satterthwaite's method b) Test the 5% level whether the mean rent in Eurelia is significantly higher than the mean rent in Begonia c) Estimate the standard error of the difference in mean rents
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT