1. Selling price in millions of shilling and size of homes
Table
Price
Size
Price
Size
Price
Size
(‘000) (sq.
ft.)
(‘000) (sq.
ft.)
(‘000)
(sq. ft.)
268
1897
142
1329
83
1378
131
1157
107
1040
125
1668
112
1024
110
951
60
1248
112
935
187
1628
85
1229
122
1236
94
816
117
1308
128
1248
99
1060
57
892
158
1620
78
800
110
1981
135
1124
56
492
127
1098
146
1248
70
792
119
1858
126
1139
54
980
172
2010
(a) Plot the selling price versus the number of square feet.
Describe the pattern. Does r 2
suggest that size is quite helpful for predicting selling
price?
(b) Do a linear regression analysis. Give the least-squares line
and the results of the
significance test for the slope. What does your test tell you about
the relationship between size
and selling price?
1.b Do larger houses have higher prices? We expect that there is
a positive correlation
between the sizes of houses in the same market and their selling
prices. DATADATA
1.c DATA FILE HOUSESIZE
(a) Use the data in the Selling price and size of homes Table to
test this hypothesis. (State
hypotheses, find the sample correlation r and the t statistic based
on it, and give an approximate
P-value and your conclusion.)
(b) To what extent do you think that these results would apply to
other cities in the United
States?
1.d Influence? Your scatterplot in Exercise shows one house
whose selling price is quite high
for its size. Rerun the analysis without this outlier. Does this
one house influence r 2, the
location of the least-squares line, or the t statistic for the
slope in a way that would change your
conclusions?
The scatter plot is:
The least-squares line is:
y = 0.077 x + 21.398
For every additional sq. ft., price will increase by 0.077.
The hypothesis being tested is:
H0: β1 = 0
H1: β1 ≠ 0
The p-value from the output is 0.0001.
Since the p-value (0.0001) is less than the significance level (0.05), we can reject the null hypothesis.
Therefore, we can conclude that the model is significant.
r² | 0.431 | |||||
r | 0.656 | |||||
Std. Error | 33.845 | |||||
n | 30 | |||||
k | 1 | |||||
Dep. Var. | Price | |||||
ANOVA table | ||||||
Source | SS | df | MS | F | p-value | |
Regression | 24,250.8032 | 1 | 24,250.8032 | 21.17 | .0001 | |
Residual | 32,073.8635 | 28 | 1,145.4951 | |||
Total | 56,324.6667 | 29 | ||||
Regression output | confidence interval | |||||
variables | coefficients | std. error | t (df=28) | p-value | 95% lower | 95% upper |
Intercept | 21.3984 | |||||
Size | 0.0766 | 0.0166 | 4.601 | .0001 | 0.0425 | 0.1107 |
1. Selling price in millions of shilling and size of homes Table Price Size Price Size &
A local realtor wishes to study the relationship between selling price (in $) and house size (in square feet). A sample of 10 homes is selected at random. The data is given below: PRICE HOUSESIZE 100000 1600 107000 1750 121000 1900 124000 2150 132000 2400 140000 2300 144000 2400 158000 2700 170000 3000 182000 2900 a) Find the regression equation relating Price to Square Footage. b) Calculate the correlation coefficient, accurate to three decimal places c) Test the significance of...
House Selling Price Data for 100 homes relating y = selling price (in dollars) to x = size of the house (in square feet) results in the regression line that is shown below. y= 9161 + 77.008x the slope estimate has standard error 6.262 Show all steps of a two-sided significance test of independence. Could the sample association between these two variables by explained by random variation? a) Assumptions b) Hypotheses: c) Test Statistics: d) p-value: e) Conclusion:
Question 1 Suppose we wanted to predict the selling price of a house using its size in a certain area of a city. A random sample of six houses were selected from the area. The data is presented in the following table with size given in hundreds of square feet, and sale price in thousands of dollars. Size (Xi) 12 15 18 21 24 27 Price (Yi) 60 85 75 105 120 110 a) Find the least squares estimate for the...
13.76 You want to develop a model to predict the selling price of homes based on assessed value. A sample of 30 recently sold single-family houses in a small city is selected to study the relationship between selling price (in thousands of dollars) and assessed value (in thousands of dollars). The houses in the city were reassessed at full value one year prior to the study. The results are in House 1. (Hint: First, determine which are the independent and...
5. 1 Data were collected for a random sample of 220 home sales from a U.S. community in 2003 Let Price denote the selling price (in $1000), BDR the number of bedrooms, Bath the number of bathrooms, Hsize the size of the house (in sq. ft.), Lsize the lot size (in sq. ft.), Age the age of the house (in years), and Poor a binary variable that is equal to 1 if the condition of the house is reported as...
options C and D for the mutiple choice questions are C: The selling price of this particular house is less than the predicted value by the amount of the residual. D: The residual is the predicted selling orice for house with zero square feet. For the response variable y, the selling price in thousands of dollars, and the expanatory variable x, the size of the house in thousands of square feet. ý = 9.5 +77 2x. a. How much do...
Question 1 (The following data is from Q1 of HW2) Suppose we wanted to predict the selling price of a house using its size in a certain area of a city. A random sample of six houses were selected from the area. The data is presented in the following table with size given in hundreds of square feet, and sale price in thousands of dollars: Size (X121518 21 24 27 Price (Y)6085 75 105 120 110 We are interested in...
Question 9 1 pts An analysis was done to predict log(price) of homes in Gainesville during Spring 2019 based on number of beds and baths along with an indicator variable for NorthWest. The indicator variable was 1 if in the Northwest of Gainesville and 0 otherwise. 4 Summary of Fit RSquare 0.625955 RSquare Adj 0.618242 Root Mean Square Enor 162.6966 Mean of Response 415.5921 Observations (or Sum Wgts) 100 4 Analysis of Variance Sum of Source DF Squares Mean Square...
1. One Price Realty Company wants to develop a model to estimate the value of houses in its inventory The office manager has decided to develop a multiple regression model to help explain the variation in house values. (25 points) The office manager has chosen the following variables to develop the model: X1 square feet X2- age in years x3- dummy variable for house style (1 if ranch, 0 if not) X4-2d dummy variable for house style (I if split...
Selling Price ($000) House Size (sq. ft) Number of Bedrooms Number of Bathrooms 220 880 2 1.5 135 590 1 1 225 880 2 2 225 840 2 1 280 1510 3 2 215 915 2 2 205 900 2 2 170 590 1 1 225 1040 2 2 320 1070 2 2 149 590 1 1 240 980 3 1 700 1580 3 2 300 1450 2 2.5 235 950 2 2 395 1130 2 2 320 1170 2...