y x1 x2 x3 x4 x5 109000 0.19 133 7300 85.44003745 66.595 155000 0.41 13 18700 136.7479433
Fantastic news! We've Found the answer you've been seeking!
Question:
y | x1 | x2 | x3 | x4 | x5 |
109000 | 0.19 | 133 | 7300 | 85.44003745 | 66.595 |
155000 | 0.41 | 13 | 18700 | 136.7479433 | 6.705 |
86060 | 0.11 | 0 | 15000 | 122.4744871 | 0.055 |
120000 | 0.68 | 31 | 14000 | 118.3215957 | 15.84 |
153000 | 0.4 | 33 | 23300 | 152.6433752 | 16.7 |
170000 | 1.21 | 23 | 14600 | 120.8304597 | 12.105 |
90000 | 0.83 | 36 | 22200 | 148.9966443 | 18.415 |
122900 | 1.94 | 4 | 21200 | 145.6021978 | 2.97 |
325000 | 2.29 | 123 | 12600 | 112.2497216 | 62.645 |
120000 | 0.92 | 1 | 22300 | 149.3318452 | 0.96 |
85860 | 8.97 | 13 | 4800 | 69.2820323 | 10.985 |
97000 | 0.11 | 153 | 3100 | 55.67764363 | 76.555 |
127000 | 0.14 | 9 | 300 | 17.32050808 | 4.57 |
89900 | 0 | 88 | 2500 | 50 | 44 |
155000 | 0.13 | 9 | 300 | 17.32050808 | 4.565 |
253750 | 2 | 0 | 49800 | 223.159136 | 1 |
60000 | 0.21 | 82 | 8500 | 92.19544457 | 41.105 |
87500 | 0.88 | 17 | 19400 | 139.2838828 | 8.94 |
112000 | 1 | 12 | 8600 | 92.73618495 | 6.5 |
104900 | 0.43 | 21 | 5600 | 74.83314774 | 10.715 |
148635 | 0.32 | 1 | 6200 | 78.74007874 | 0.66 |
150000 | 0.03 | 24 | 5100 | 71.41428429 | 12.015 |
90400 | 0.36 | 16 | 5200 | 72.11102551 | 8.18 |
248800 | 4 | 28 | 5500 | 74.16198487 | 16 |
135000 | 1.83 | 126 | 6000 | 77.45966692 | 63.915 |
145000 | 3 | 26 | 4500 | 67.08203932 | 14.5 |
457000 | 0.43 | 53 | 2700 | 51.96152423 | 26.715 |
140000 | 0.44 | 56 | 19400 | 139.2838828 | 28.22 |
130000 | 1.24 | 51 | 24800 | 157.4801575 | 26.12 |
187000 | 0.46 | 3 | 15200 | 123.2882801 | 1.73 |
229000 | 0.87 | 9 | 41100 | 202.7313493 | 4.935 |
227000 | 1.8 | 201 | 25500 | 159.6871942 | 101.4 |
179900 | 0.46 | 1 | 15200 | 123.2882801 | 0.73 |
169900 | 0.91 | 19 | 20200 | 142.126704 | 9.955 |
209900 | 0.46 | 1 | 15200 | 123.2882801 | 0.73 |
169900 | 0.59 | 0 | 17300 | 131.5294644 | 0.295 |
293000 | 7.24 | 43 | 36600 | 191.3112647 | 25.12 |
245900 | 0.19 | 0 | 20700 | 143.8749457 | 0.095 |
157000 | 0.46 | 45 | 20200 | 142.126704 | 22.73 |
195000 | 0.41 | 32 | 27100 | 164.6207763 | 16.205 |
150000 | 0.78 | 54 | 24500 | 156.5247584 | 27.39 |
234900 | 0.89 | 9 | 41600 | 203.9607805 | 4.945 |
279550 | 1.34 | 0 | 44400 | 210.7130751 | 0.67 |
246500 | 1 | 0 | 17100 | 130.7669683 | 0.5 |
124000 | 1 | 98 | 15500 | 124.498996 | 49.5 |
138000 | 0.27 | 54 | 8900 | 94.33981132 | 27.135 |
290000 | 0.71 | 73 | 61000 | 246.9817807 | 36.855 |
108000 | 0.9 | 48 | 19000 | 137.8404875 | 24.45 |
134900 | 0.24 | 10 | 8000 | 89.4427191 | 5.12 |
64500 | 0.06 | 16 | 1600 | 40 | 8.03 |
142000 | 0.55 | 20 | 13800 | 117.4734012 | 10.275 |
125000 | 0.34 | 32 | 11100 | 105.3565375 | 16.17 |
88000 | 0.19 | 15 | 3400 | 58.30951895 | 7.595 |
135000 | 0.23 | 135 | 8100 | 90 | 67.615 |
90000 | 0.07 | 14 | 1800 | 42.42640687 | 7.035 |
90100 | 0.09 | 15 | 2400 | 48.98979486 | 7.545 |
126900 | 0.25 | 10 | 8400 | 91.6515139 | 5.125 |
175000 | 0.47 | 15 | 27200 | 164.924225 | 7.735 |
158000 | 0.36 | 10 | 12100 | 110 | 5.18 |
92000 | 0.07 | 14 | 1800 | 42.42640687 | 7.035 |
82800 | 0.11 | 225 | 3900 | 62.44997998 | 112.555 |
140000 | 0.23 | 25 | 8300 | 91.10433579 | 12.615 |
171000 | 3.16 | 15 | 24100 | 155.241747 | 9.08 |
200640 | 0.08 | 0 | 32000 | 178.8854382 | 0.04 |
139000 | 0.57 | 30 | 7500 | 86.60254038 | 15.285 |
225000 | 0.5 | 12 | 15300 | 123.6931688 | 6.25 |
182000 | 1 | 16 | 26600 | 163.0950643 | 8.5 |
208767 | 0.5 | 0 | 32000 | 178.8854382 | 0.25 |
186000 | 0.55 | 0 | 4400 | 66.33249581 | 0.275 |
93000 | 0.1 | 14 | 2600 | 50.99019514 | 7.05 |
257386 | 0.5 | 0 | 32000 | 178.8854382 | 0.25 |
161000 | 0.31 | 10 | 10400 | 101.9803903 | 5.155 |
92000 | 0.28 | 18 | 6300 | 79.37253933 | 9.14 |
211002 | 0.06 | 0 | 32000 | 178.8854382 | 0.03 |
115000 | 0.06 | 14 | 1600 | 4 | 7.03 |
1. What is the Sample Regression Equation?
3. Test the overall significance of the model by conduction an F test.
4. What is the value of adjusted r-square? Verify its value, using the formula for adjusted r-square and using the values in your Excel Printout.
5. Comment on the Normality assumption for the residuals for this model. In other word, has the normality assumption been satisfied? Explain your answer (Hint: you need to run Excel?s Histogram feature for Column of the Residuals)
Related Book For
Posted Date: