STAT PROJECT 2

profile75aki131
multiple_regression_data.xls
Home>Applied Sciences homework help>STAT PROJECT 2

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8883673992
R Square 0.7891966359
Adjusted R Square 0.7623671168
Standard Error 17.0714292176
Observations 63
ANOVA
df SS MS F Significance F
Regression 7 60008.1365870672 8572.5909410096 29.4152360296 2.01025065290745E-16
Residual 55 16028.8532542026 291.433695531
Total 62 76036.9898412698
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -10.4405928321 34.3297368752 -0.3041267945 0.7621789825 -79.2389229286 58.3577372644 -79.2389229286 58.3577372644
Square feet 0.044426568 0.0093063638 4.7737836987 0.0000137814 0.0257761981 0.063076938 0.0257761981 0.063076938
Rooms 2.1823742431 9.1802879223 0.237723943 0.8129785804 -16.2153338766 20.5800823628 -16.2153338766 20.5800823628
Bedrooms 0.8846115075 6.1121911098 0.1447290328 0.8854538732 -11.3644932005 13.1337162155 -11.3644932005 13.1337162155
Age 0.604949667 0.4964600671 1.2185263368 0.228225069 -0.3899785407 1.5998778746 -0.3899785407 1.5998778746
View 25.2274583946 6.4983954313 3.8821057692 0.0002797429 12.2043829308 38.2505338585 12.2043829308 38.2505338585
SqFt*Age -0.0006472853 0.0003172071 -2.0405762576 0.0461048928 -0.0012829826 -0.000011588 -0.0012829826 -0.000011588
Rooms*Rooms 0.2341878402 0.5884327621 0.3979857263 0.6921813486 -0.945057767 1.4134334473 -0.945057767 1.4134334473

Sheet1

Data on 63 single-family residences
Residence Sales Price (in $1000) Square feet Rooms Bedrooms Age View
1 53.5 1008 5 2 35 0
2 49.0 1290 6 3 36 0
3 50.5 860 8 2 36 0
4 49.9 912 5 3 41 0
5 52.0 1204 6 3 40 0
6 55.0 1204 5 3 10 0
7 80.5 1764 8 4 64 0
8 86.0 1600 7 3 19 0
9 69.0 1255 5 3 16 0
10 149.0 3600 10 5 17 1
11 46.0 864 5 3 37 0
12 38.0 720 4 2 41 0
13 49.5 1008 6 3 35 0
14 105.0 1950 8 3 52 1
15 152.5 2086 7 3 12 1
16 85.0 2011 9 4 76 1
17 60.0 1465 6 3 102 0
18 58.5 1232 5 2 69 0
19 101.0 1736 7 3 67 1
20 79.4 1296 6 3 11 0
21 125.0 1996 7 3 9 1
22 87.9 1874 5 2 14 1
23 80.0 1580 5 3 11 0
24 94.0 1920 5 3 14 0
25 74.0 1430 9 3 16 0
26 69.0 1486 6 3 27 0
27 63.0 1008 5 2 35 0
28 67.5 1282 5 3 20 0
29 35.0 1134 5 2 74 0
30 142.5 2400 9 4 15 0
31 92.2 1701 5 3 15 1
32 56.0 1020 6 3 16 0
33 63.0 1053 5 2 24 0
34 60.0 1728 6 3 26 0
35 34.0 416 3 1 42 0
36 52.0 1040 5 2 9 1
37 75.0 1496 6 3 30 0
38 93.0 1936 8 4 39 1
39 60.0 1904 7 4 32 0
40 73.0 1080 5 2 24 0
41 71.0 1768 8 4 74 0
42 83.0 1503 6 3 14 1
43 90.0 1736 7 3 16 1
44 83.0 1695 6 3 12 0
45 115.0 2186 8 4 12 0
46 50.0 888 5 2 34 0
47 55.2 1120 6 3 29 0
48 61.0 1400 5 3 33 0
49 147.0 2165 7 3 2 1
50 210.0 2353 8 4 15 1
51 60.0 1536 6 3 36 0
52 100.0 1972 8 3 37 1
53 44.5 1120 5 3 27 0
54 55.0 1664 7 3 79 0
55 53.4 925 5 3 20 0
56 65.0 1288 5 3 2 0
57 73.0 1400 5 3 2 0
58 40.0 1376 6 3 103 0
59 141.0 2038 12 4 62 1
60 68.0 1572 6 3 29 0
61 139.0 1545 6 3 9 1
62 140.0 1993 6 3 4 1
63 55.0 1130 5 2 21 0

Sheet2

Sheet3