Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Floor Area (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 AssessedValue ($'000) y= 0.3067x+162.66 R =
Floor Area (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 AssessedValue ($'000) y= 0.3067x+162.66 R = 0.9377 5940 4 2 2 2094 25.00 5720 4 2 34 1968 3660 3 2 38 1567 2000 5000 4 2 31 1878 2990 2 1 19 949 1500 2610 2 1 48 910 5650 4 2 42 1774 1000 3570 2 1 4 1187 2930 3 2 15 1113 500 1280 2 1 31 671 4880 3 2 42 1678 0 1620 1 2 35 710 0 1000 2000 3000 40:00 5000 6000 7000 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 SUMMARY OUTPUT Regression Statistics Multiple R 0.96835821 R Square 0.93771762 Adjusted R Square 0.93564154 Standard Error 115.599304 Observations 32 ANOVA SS Regression 1 6E+06 NS 6E+06 F 451.6771673 Residual 30 400896 13363 Total 31 6E+06 Intercepti FloorArea (Sq. Ft.) Coefficients andard Er 162.662767 54.479 0.30673208 0.0144 21.253 Stat 2.9858 Flualue 0.005585612 1.23E-19 0.00000000000000000012 gnificance F 1E-19 orer 95%pper 95%wer 95. Doper 95.0% 51.403 273.92 51.403 273.92 0.2773 0.3362 0.2773 0.3362 SUMMARY OUTPUT Regression Statistics Multiple R R Square 0.97623608 0.95303688 Adjusted R Square 0.94607938 Standard Error Observations ANOVA Regression Residual Total 105.810762 32 ** SS NS F 4 6E+06 2E+06 27 302290 11196 31 6E+06 gnificance F 136.9797998 2E-17 Intercept Floor Area (Sq.Ft.) Offices Entrances Age Coefficients andard En 38.7834484 77.095 0.24404082 0.0255 9.573 80.9459182 35.654 2.2703 86.5975602 45.205 1.9157 -0.2079889 1.4064 -0.148 Stat 0.5031 Flualue 0.618998774 -119.4 196.97 0.00000000036 0.1917 0.2963 7.79 154.1 7.79 154.1 orer 95pper 95% 95. Ooper 95.0% -119.4 196.97 0.1917 0.2963 0.031382197 0.0660515 -6.154 179.35 -6.154 179.35 0.883528357 -3.094 2.6777 -3.094 2.6777
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started