q xdata.xls
Regression Paper Using numerical data from one of the data sets available through the “Data Sets” link on your page, develop one research question and formulate a hypothesis which can be tested with linear regression analysis. Prepare a paper describing the results of the linear regression analysis on your collected data. Be sure to include the following in your paper: The research question is “Are the higher priced homes in the real estate data set priced fairly higher amongst the other homes listed due to the location of the home?” e. Formulate a hypothesis statement regarding your research issue. f. Perform a regression hypothesis test on the data. g. Interpret the results of your regression hypothesis test. Be sure to include your raw data tables and the results of your computations in your paper, using both graphical and tabular methods of displaying data and results.
Regression Paper
Using numerical data from one of the data sets available through the “Data Sets” link on your page, develop one research question and formulate a hypothesis which can be tested with linear regression analysis.
Prepare a paper describing the results of the linear regression analysis on your collected data. Be sure to include the following in your paper:
The research question is “Are the higher priced homes in the real estate data set priced fairly higher amongst the other homes listed due to the location of the home?”
e. Formulate a hypothesis statement regarding your research issue.
f. Perform a regression hypothesis test on the data.
g. Interpret the results of your regression hypothesis test.
Be sure to include your raw data tables and the results of your computations in your paper, using both graphical and tabular methods of displaying data and results.
>Sheet .1
0
1 1 2 2.4
4 00
0 4 0 2 2.1
3 0 3 0 2 .6
2 0
0 2 0 2 2 0 0 1 0 2 1 12 1 1 2 6 0 3 1 2 2 2100 0 9 2 1 2.5 3 2300 1 1 0 1.5 6.6
4 0
0 13 4 1 2 4 2100 0 3 1 2 2 00
0 8 4 1 1.5 6 2500 0 7 4 1 2 .1
4 2100 0 18 3 1 2 4.4
2 2300 0 3 0 2 3 2100 0 16 2 1 2 4 1 16 3 0 2 5 2300 1 21 4 0 2.5 3 2200 1 10 4 1 2 6 1 15 4 1 2 4 0 8 4 1 2 4 1900 1 14 2 1 2.5 8 2600 0 9 4 1 2 6 2100 0 11 5 1 3 2 2200 1 21 5 1 1.5 2 1900 0 26 4 0 2 2 2100 0 9 4 1 2 3 2200 0 14 3 1 1.5 2 0 11 5 0 2 2 0 19 3 1 2 2 2000 0 11 5 1 2 5 0 16 2 1 2 3 2000 1 16 2 1 2 2 1900 0 10 5 1 2 4 2000 1 14 4 0 2.5 4 2300 0 19 2 0 2 6 2600 0 7 5 1 2.5 .8
3 2100 0 19 3 1 2 5 2200 0 16 2 1 3 3 2100 1 9 3 0 1.5 3 1900 1 16 1 1 1.5 4 2100 1 19 1 1 1.5 3 2000 1 20 4 0 2 .6
4 2300 1 24 4 1 2 3 2400 1 21 2 1 3 5 2200 0 8 5 1 3 .8
3 2200 0 17 1 1 2.5 3 2000 1 16 4 0 2 3 2200 0 15 1 1 2 6 2200 1 14 1 0 2 5 2200 0 20 3 1 2 3 2200 0 23 3 0 2 3 1900 0 12 2 1 2 6 1700 1 12 1 0 2 4 2200 0 15 1 1 2 3 2300 0 17 5 1 1.5 3 1 19 3 0 2.5 4 2200 0 24 1 1 2 6 2000 0 21 3 1 3 5 2200 1 11 4 1 2.5 2 2000 0 13 2 0 2 2 2100 0 9 5 1 2 5 2200 1 13 2 1 2 3 2200 1 18 3 1 2 4 2500 1 15 3 1 2 2 2100 0 13 2 1 2.5 2 2000 1 17 3 0 2 7 2400 0 8 4 1 2 2 1900 0 18 4 0 1.5 4 2600 1 17 5 1 2 4 2300 0 19 4 0 2 3 2500 0 12 3 0 2 2 2400 0 16 2 0 2.5 2 2400 0 28 1 0 1.5 2 2300 1 12 1 1 2 6 0 15 3 1 2 2 2300 0 9 2 1 2.5 4 2300 0 14 3 1 2 2 1900 0 8 4 1 1.5 6 2700 0 7 4 1 2 4 2300 0 18 3 1 2 3 2300 0 16 2 1 2 4 2400 1 16 3 0 2 5 2500 1 21 4 0 2.5 3 2400 1 10 4 1 2 6 2100 1 15 4 1 2 4 0 8 4 1 2 4 2100 1 14 2 1 2.5 8 2900 0 9 4 1 2 6 2400 0 11 5 1 3
2
1
Price
Bedrooms
Size
Pool
Distance
Twnship
Garage
Baths
2
6
3
4
23
0
1
7
5
1
8
21
1
9
24
2300
12
2
13
2
20
16
2.5
139.9
10
28
1.5
245.4
2100
327.2
2500
15
271.8
221.1
18
26
240
292.4
14
209
17
270.8
246
19
11
281.3
172.7
2200
207.5
198.9
209.3
1900
252.3
2600
192.9
209.3 5 2100 0 20 5 0 1.5
345.3
326.3
173.1
187
257.2
233
180.4
2000
234
1700
207.1
247.7
2400
166.2
177.1
182.7
216
312.1
199
273.2
206
232.2
198.3
205.1
175
307.8
269.2
224
171.6
216.8
192.6
236.4
172.4
251.4
246 6 2300 0 7 3 1 3
147.4
176
228.4
166.5
1600
189.4
312.1 7 2400 0 13 3 1 3
289.8
269.9
154.3
222.1
209.7
190.9
254.3
207.5 3 2100 1 10 2 0 2
209.7 4 2200 1 19 2 1 2
294
176.3
294.3
224 3 1900 1 6 1 1 2
125
236.8
164.1
217.8
192.2
125.9
220.9
294.5
2700
244.6
199 3 2500 1 18 1 0 1.5
240 4 2600 0 13 4 1 2
263.2
188.1
243.7
221.5
175 2 2500 0 11 3 0 2
253.2
155.4
186.7
179
188.3
227.1
2900
173.6
188.3 5 2300 0 20 5 0 1.5
310.8
293.7
179 3 2400 0 8 4 1 2
188.3 6 2100 1 14 2 1 2.5
227.1 4 2900 0 20 5 0 1.5
173.6 4 2100 0 9 4 1 2
188.3 5 2300 0 11 5 1 3