mth130 h8
katherinabe
CaseStudy4.docxCase Study #4
Berenson, M., Levine, D., & T. Krehbiel. (2006). Basic Business Statistics (10th ed.). NJ: Prentice Hall. ISBN: 0-13-153686-9
The following problems are from the above textbook Chapter 13 for this course as part of the Case Study #4 assignment for week eight: You can use any source.
Regression using excel
1. Conduct a multiple regression analysis for the following data. Use Assessed Value as the dependent variable and all others as independent variables.
2. Which of the following independent variables are satistically significant? Use p < 0.05
|
FloorArea (Sq.Ft.) |
Offices |
Entrances |
Age |
AssessedValue ($'000) |
|
4790 |
4 |
2 |
8 |
1796 |
|
4720 |
3 |
2 |
12 |
1544 |
|
5940 |
4 |
2 |
2 |
2094 |
|
5720 |
4 |
2 |
34 |
1968 |
|
3660 |
3 |
2 |
38 |
1567 |
|
5000 |
4 |
2 |
31 |
1878 |
|
2990 |
2 |
1 |
19 |
949 |
|
2610 |
2 |
1 |
48 |
910 |
|
5650 |
4 |
2 |
42 |
1774 |
|
3570 |
2 |
1 |
4 |
1187 |
|
2930 |
3 |
2 |
15 |
1113 |
|
1280 |
2 |
1 |
31 |
671 |
|
4880 |
3 |
2 |
42 |
1678 |
|
1620 |
1 |
2 |
35 |
710 |
|
1820 |
2 |
1 |
17 |
678 |
|
4530 |
2 |
2 |
5 |
1585 |
|
2570 |
2 |
1 |
13 |
842 |
|
4690 |
2 |
2 |
45 |
1539 |
|
1280 |
1 |
1 |
45 |
433 |
|
4100 |
3 |
1 |
27 |
1268 |
|
3530 |
2 |
2 |
41 |
1251 |
|
3660 |
2 |
2 |
33 |
1094 |
|
1110 |
1 |
2 |
50 |
638 |
|
2670 |
2 |
2 |
39 |
999 |
|
1100 |
1 |
1 |
20 |
653 |
|
5810 |
4 |
3 |
17 |
1914 |
|
2560 |
2 |
2 |
24 |
772 |
|
2340 |
3 |
1 |
5 |
890 |
|
3690 |
2 |
2 |
15 |
1282 |
|
3580 |
3 |
2 |
27 |
1264 |
|
3610 |
2 |
1 |
8 |
1162 |
|
3960 |
3 |
2 |
17 |
1447 |
|
3960 |
3 |
2 |
17 |
1447 |
|
1280 |
1 |
1 |
45 |
433 |
|
5000 |
4 |
2 |
31 |
1878 |
|
1280 |
1 |
1 |
45 |
433 |
|
3660 |
3 |
2 |
38 |
1567 |
|
3960 |
3 |
2 |
17 |
1447 |
|
4880 |
3 |
2 |
42 |
1678 |
3. What is the R square? Interpret its meaning.
4. What is the standard error?
5. What is the resulting model?
