Price | Lot size | Trees | Distance |
89.7 | 21.8 | 45 | 62 |
136.1 | 66.3 | 79 | 34 |
44.7 | 28.2 | 53 | 77 |
63.2 | 41.9 | 64 | 65 |
163.4 | 46.7 | 69 | 27 |
64.1 | 32.1 | 12 | 0 |
98.7 | 38.5 | 59 | 77 |
139.9 | 27.6 | 10 | 0 |
92 | 47 | 65 | 37 |
66.6 | 20.7 | 24 | 51 |
16.4 | 34 | 22 | 75 |
131.9 | 31.9 | 56 | 63 |
11 | 28 | 12 | 42 |
27.9 | 40 | 52 | 84 |
103.5 | 46.6 | 36 | 70 |
107 | 23.2 | 11 | 83 |
51.6 | 46.4 | 53 | 44 |
133.4 | 32.1 | 55 | 98 |
101.4 | 35.3 | 38 | 75 |
133.3 | 40.1 | 68 | 0 |
117.7 | 35.6 | 24 | 41 |
49.7 | 20.6 | 16 | 77 |
49.6 | 22.4 | 32 | 86 |
83.2 | 45.8 | 77 | 19 |
81.3 | 29.4 | 40 | 0 |
152.5 | 51.7 | 60 | 34 |
112.2 | 27.2 | 10 | 16 |
37.1 | 37 | 50 | 49 |
130.2 | 38.9 | 48 | 63 |
39.1 | 32.5 | 25 | 45 |
81.9 | 34 | 12 | 0 |
24.6 | 35.8 | 16 | 34 |
101.9 | 32.9 | 44 | 42 |
117.6 | 46.4 | 62 | 48 |
148.8 | 51.9 | 59 | 39 |
60.2 | 28.9 | 10 | 66 |
43.7 | 35.2 | 57 | 77 |
113.1 | 30.4 | 50 | 78 |
38.1 | 38.3 | 24 | 62 |
89.2 | 49.2 | 61 | 0 |
3 | 21.5 | 46 | 83 |
55.8 | 41.9 | 30 | 69 |
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.481805 | |||||
R Square | 0.232136 | |||||
Adjusted R Square | 0.171515 | |||||
Standard Error | 38.83705 | |||||
Observations | 42 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 3 | 17327.45 | 5775.818 | 3.829314 | 0.017213 | |
Residual | 38 | 57316.02 | 1508.316 | |||
Total | 41 | 74643.48 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 57.76602 | 29.71969 | 1.943695 | 0.059365 | -2.39836 | 117.9304 |
Lot size | 0.575668 | 0.857808 | 0.671092 | 0.506221 | -1.16087 | 2.312209 |
Trees | 0.58747 | 0.394442 | 1.489371 | 0.144643 | -0.21104 | 1.385976 |
Distance | -0.38832 | 0.232388 | -1.67102 | 0.102934 | -0.85877 | 0.082119 |
a ) Considering alpha as 0.05 for F-test
the overall F-test significance p-value is 0.017, so it appears the model as a whole is significant , that is slopes are different from zero.
the p-value for the variables
Lot size = 0.506
Trees = 0.145
Distance = 0.103
Based on these measured statistics and alpha as 0.10 there are no independent variables which are significant.
None of the variables are significant.
There exist a contradiction between the F-test and the three t-tests for slopes.
Correlation Matrix
Lot size | Trees | Distance | |
Lot size | 1 | ||
Trees | 0.641909 | 1 | |
Distance | -0.2782 | 0.023252 | 1 |
the largest correlation we find is 0.642 between Lotsize and trees.
As a result of these tests, your conclusion is that there is a reason to suspect multicollinearity in these data.
2. Homework 19, Question 2 A real estate agent is interested in estimating the value of a piece o...
Question 1 A developer who specialises in summer cottage properties is considering purchasing a large tract of land adjoining a lake. The current owner of the tract has already subdivided the land into separate building lots and has prepared the lots by removing some of the trees. The developer wants to forecast the value of each lot. From previous experience, she knows that the most important factors affecting the price of the lot are size, number of mature trees, and...
The following exercise require a computer and software.Calculate the coefficients of correlation for each pair of independent variables in Exercise. What do these statistics tell you about the independent variables and the t-tests of the coefficients?ExerciseThe following exercises require the use of a computer and statistical software. Exercises below can be solved manually.A developer who specializes in summer cottage properties is considering purchasing a large tract of land adjoining a lake. The current owner of the tract has already subdivided...
please help thank you! Selling Information For Real Estate Value Price SqFt Brick (1 if brick, if othewise) $241,255 3,392 0 $184,518 2,038 1 $176,488 1,906 0 $240,068 3,329 0 $169,760 1,828 0 $185,335 2,081 0 $172,735 1, 9260 $224,281 3,4250 $172,589 1,676 1 $214,635 2,735 1 $199,666 2,373 1 $208,348 2,662 1 $218,360 2, 8341 $230,160 3, 2540 $164,812 1,431 0 $191,560 1,839 1 $203,255 2, 4561 $173,325 1,530 $168,073 1.381 1 $179,620 1,4571 TABLE 4 Industrial CEO Salary...
Problem: You are interested in factors that predict the salaries of catwalk models. You collected data from 231 models (attached SPSS data file: supermodel_1.sav). For each model, you asked: salary per day in dollars (on days when working (variable: salary_2), age (variable: age), and how many years they have worked as a model (variable: years). You also got a panel of experts from various modeling agencies to rate the attractiveness of each model as a percentage, with 100% being perfectly...
1. In the Real Estate data example, we predicted Prices using one or more independent variables. If you were conducting Simple Linear Regression, using Distance to the Nearest MRT Station as the independent variable, what would the R squared value be? 2. If the correlation coefficient between House Age and House Price is -0.210567. Without doing a regression analysis, state the R squared value of the simple linear regression between House Age and House Price. 3. Consider the following multiple...
Show your work. Carry out all calculations to at least 3 significant digits. A real estate study was conducted in the school district of Alhambra to determine what variables influenced the market value of a house (denoted by PRICE in $1,000s). Four possibly important variables – HOUSE (the house size in 1,000s of square feet), LOT (the lot size in 1,000s of square feet), BED (the number of bedrooms), BATH (the number of bathrooms), and AGE (the age of the...
4. Testing for significance Aa Aa Consider a multiple regression model of the dependent variable y on independent variables x1, x2, X3, and x4: Using data with n = 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: 0.04 + 0.28X1 + 0.84X2-0.06x3 + 0.14x4 y She would like to conduct significance tests for a multiple regression relationship. She uses the F test to determine whether a significant relationship exists...
Consider a multiple regression model of the dependent variable y on independent variables x1, X2, X3, and x4: Using data with n 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: y0.35 0.58x1 + 0.45x2-0.25x3 - 0.10x4 He would like to conduct significance tests for a multiple regression relationship. He uses the F test to determine whether a significant relationship exists between the dependent variable and He uses the t...
6. Mike Jimenez is president of the teachers' union he would like to investigate the salary structure of classroom teachers in the district. that affect a teacher's salary: the teacher has a master's degree. A random sample of 20 teachers resulted in the following data for Preston School District. In preparing for upcoming negotiations, He believes there are three factors years of experience, a rating of teaching effectiveness given by the principal, and whether Years ofPrincipal's Master's Salary ($ thousands)...
Y = listing priceX1 = interior floor space (square footage of the house)X2 = land size (square footage). This is usually represented by length of the front of the lot (in ft) X the depth of the lot (in ft). sizes range but a common lot size in Vancouver is 33 X 120. You will need to convert this to feet squared (area) before entering it into your spreadsheet (i.e., 3960)X3 = number of bedroomsX4 = number of bathroomsX5 =...