Share
Explore BrainMass

Regression Model:Assessed value of medical office Building

Using Data set C, complete the template provided in the Excel file attached.

Regression analysis: Assessed value of small medical office buildings

obs assessed floor offices entrances age freeway
1 1796 4790 4 2 8 0
2 1544 4720 3 2 12 0
3 2094 5940 4 2 2 0
4 1968 5720 4 2 34 1
5 1567 3660 3 2 38 1
6 1878 5000 4 2 31 1
7 949 2990 2 1 19 0
8 910 2610 2 1 48 0
9 1774 5650 4 2 42 0
10 1187 3570 2 1 4 1
11 1113 2930 3 2 15 1
12 671 1280 2 1 31 1
13 1678 4880 3 2 42 1
14 710 1620 1 2 35 1
15 678 1820 2 1 17 1
16 1585 4530 2 2 5 1
17 842 2570 2 1 13 0
18 1539 4690 2 2 45 0
19 433 1280 1 1 45 1
20 1268 4100 3 1 27 0
21 1251 3530 2 2 41 1
22 1094 3660 2 2 33 0
23 638 1110 1 2 50 1
24 999 2670 2 2 39 1
25 653 1100 1 1 20 1
26 1914 5810 4 3 17 0
27 772 2560 2 2 24 0
28 890 2340 3 1 5 0
29 1282 3690 2 2 15 1
30 1264 3580 3 2 27 0
31 1162 3610 2 1 8 1
32 1447 3960 3 2 17 0

Attachments

Solution Summary

The solution provides step by step method for the calculation of regression analysis in excel.

$2.19