Regression Model:Assessed value of medical office Building
Not what you're looking for?
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
Purchase this Solution
Solution Summary
The solution provides step by step method for the calculation of regression analysis in excel.
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.