Business statistics lab assignment 4

profileMahdi.q
lab_3.xlsx
Home>Mathematics homework help>Statistics homework help>Business statistics lab assignment 4

Data

Home Price Home Size
Christopher J. Zappe: In square feet.		 Lot Size
Christopher J. Zappe: In acres.		 Rooms Bathrooms
1 $102,000 600 0.50 3 1.0
2 $146,300 1050 0.43 5 1.5
3 $182,000 1800 0.68 7 1.5
4 $110,500 922 0.30 5 1.0
5 $171,900 1950 0.75 8 2.5
6 $154,000 1783 0.22 8 1.5
7 $147,000 1008 0.50 6 1.0
8 $195,900 1840 1.16 8 2.0
9 $183,500 3700 1.10 10 3.0
10 $156,500 1092 0.26 6 1.0
11 $152,000 1950 0.50 7 1.5
12 $170,000 1403 0.50 6 2.0
13 $253,000 1680 14.37 8 2.0
14 $129,500 1000 0.49 4 1.0
15 $241,900 2310 0.46 8 2.5
16 $151,900 1300 0.78 6 1.0
17 $199,000 1930 3.00 9 3.0
18 $186,000 3000 0.50 11 2.5
19 $153,500 1362 0.40 7 2.0
20 $166,000 1750 0.50 7 2.0
21 $224,900 2080 1.00 8 2.5
22 $158,500 1344 0.94 6 2.0
23 $332,000 2130 11.91 8 1.5
24 $172,000 1500 0.41 7 1.0
25 $176,000 2400 0.40 7 2.5
26 $210,000 2272 0.41 9 2.5
27 $156,500 1050 1.00 5 1.0
28 $169,500 1610 0.45 8 1.5
29 $154,900 1248 0.22 7 1.0
30 $163,000 2000 0.50 8 2.0
31 $140,000 1450 0.30 6 2.0
32 $148,500 1248 0.25 7 1.0
33 $224,500 2544 0.28 9 2.5
34 $299,900 2500 0.92 8 3.0
35 $199,900 2858 0.79 9 3.0
36 $220,000 1745 0.58 7 2.5
37 $233,000 2653 1.80 9 3.0
38 $174,900 1450 0.30 7 1.0
39 $124,000 850 0.11 4 1.0
40 $169,900 1839 2.60 7 1.5
41 $213,000 2016 0.78 8 2.5
42 $165,000 1625 0.36 7 1.5
43 $162,000 2000 0.11 8 2.0
44 $211,500 2250 0.33 9 2.5
45 $166,000 1300 0.30 7 1.0
46 $194,000 1956 0.50 8 2.5
47 $192,000 2496 0.75 9 2.5
48 $171,000 1575 0.25 7 1.5
49 $226,800 1960 1.33 8 2.5
50 $155,000 1200 0.33 5 1.0
51 $157,500 1296 0.50 9 1.0
52 $297,000 1950 18.70 7 2.5
53 $315,000 2516 8.10 7 2.5
54 $161,000 1066 0.33 5 1.0
55 $193,500 2276 1.00 8 2.5
56 $163,000 1908 0.46 7 2.0
57 $180,000 1122 3.09 5 2.0
58 $171,000 3500 1.00 10 2.5
59 $163,000 1100 0.33 6 1.0
60 $220,000 2300 5.63 7 2.5
61 $155,900 1118 0.56 7 1.5
62 $219,900 2464 0.43 8 2.5
63 $185,000 2100 0.58 8 1.5
64 $172,500 1552 0.46 6 1.5
65 $167,900 1856 0.33 7 1.5
66 $160,000 1800 0.30 7 1.5
67 $147,000 1248 0.30 6 1.0
68 $210,500 2000 0.60 9 2.5
69 $192,500 1848 0.50 7 2.5
70 $138,000 1036 0.95 6 1.0
71 $200,000 2277 0.80 8 3.0
72 $186,000 2300 0.65 7 3.0
73 $217,000 2080 1.23 8 2.5
74 $180,000 1600 1.84 7 2.0
75 $195,000 2680 0.50 9 3.0
76 $149,000 1200 0.25 7 1.0
77 $165,500 1526 0.30 7 1.5
78 $175,900 1680 0.50 6 1.5
79 $156,000 1232 0.31 6 2.0
80 $235,406 2465 1.55 8 2.5
81 $215,500 2800 1.68 9 1.5
82 $225,000 2265 0.85 8 2.5
83 $155,000 1300 0.65 5 1.0
84 $190,000 1900 1.00 8 2.5
85 $126,000 864 0.32 4 1.0
86 $172,000 2000 0.75 9 1.5
87 $175,000 1800 0.66 8 2.5
88 $181,500 1900 0.75 7 2.0
89 $180,000 1564 0.33 6 2.0
90 $295,000 2400 2.00 7 2.0
91 $146,000 1100 1.10 6 1.0
92 $165,000 1800 1.00 8 2.5
93 $159,000 1200 0.33 6 1.0
94 $138,500 1540 0.18 7 2.0
95 $194,900 1980 0.70 8 2.5
96 $140,000 1289 0.25 6 1.0
97 $184,000 1800 0.68 7 2.0
98 $164,000 1502 0.35 7 1.5
99 $190,000 2025 1.10 7 2.0
100 $250,000 3000 1.15 10 3.5
101 $156,500 1500 0.50 7 1.5
102 $156,500 1600 0.26 8 1.5
103 $188,000 1500 0.54 5 2.5
104 $202,000 2100 1.00 8 2.5
105 $245,000 2100 0.50 8 2.5
106 $171,900 1632 3.00 6 3.0
107 $119,900 1660 0.21 7 1.0
108 $159,900 1070 1.69 5 1.0
109 $165,000 1400 0.35 6 2.0
110 $165,000 1800 0.50 7 2.0
111 $152,500 1100 0.37 7 1.0
112 $265,000 3150 0.30 11 4.0
113 $164,500 2000 0.70 8 1.0
114 $156,500 1700 0.30 8 2.0
115 $210,000 1800 1.52 8 2.5
116 $157,500 1850 0.26 9 2.0
117 $195,000 2320 0.40 8 2.5
118 $127,000 1300 0.37 5 1.0
119 $130,000 1338 0.12 6 1.0
120 $238,000 2288 1.20 8 2.5
121 $212,000 2400 0.50 8 2.5
122 $205,000 2400 0.70 8 3.0
123 $174,900 1900 0.44 6 2.0
124 $207,000 2010 0.68 8 1.5
125 $261,750 2981 1.30 10 3.5
126 $195,000 1725 1.53 8 2.5
127 $108,000 821 2.30 4 1.0
128 $209,000 3060 0.75 8 2.0
129 $115,000 875 0.26 5 1.0
130 $190,000 1760 0.05 7 2.0
131 $171,000 2000 0.65 7 1.0
132 $215,000 2600 0.75 8 2.0
133 $143,500 1624 1.80 7 1.5
134 $220,000 2473 1.25 9 2.5
135 $137,000 1100 0.17 5 1.0
136 $247,000 3100 0.54 10 3.5
137 $224,500 2300 0.91 8 2.5
138 $182,000 1450 0.30 6 1.5
139 $240,000 2100 0.50 8 2.5
140 $170,000 1650 0.50 8 2.5
141 $150,500 1600 0.40 6 2.0
142 $209,900 2790 0.75 13 2.5
143 $182,500 1786 0.30 8 2.0
144 $189,000 1728 0.50 8 1.5
145 $198,500 1900 1.06 7 2.5
146 $128,000 1165 0.12 6 1.0
147 $147,500 1300 0.29 6 1.0
148 $145,000 1080 0.31 5 1.0
149 $305,000 2820 1.00 9 2.5
150 $220,000 2100 1.30 8 1.5

This is fictitious data.