Question: USE the data sets (a) Make a scatter plot. (b) Let Excel estimate the regression line, with fitted equation and R2. ( c) Describe the
USE the data sets
(a) Make a scatter plot.
(b) Let Excel estimate the regression line, with fitted equation and R2. (
c) Describe the fit of the regression.
(d) Write the fitted regression equation and interpret the slope.
(e) Do you think that the estimated intercept is meaningful? Explain.
Definitions
Assessed = assessed value in thousands of dollars
Size = usable floor space in square feet
All properties are retail spaces in small shopping malls.
| Commercial Property Assessed Value and Floor Space (n = 15 buildings) |
| Assessed | Size | |
| 1,796 | 4,790 | |
| 1,544 | 4,720 | |
| 2,094 | 5,940 | |
| 1,968 | 5,720 | |
| 1,567 | 3,660 | |
| 1,878 | 5,000 | |
| 949 | 2,990 | |
| 910 | 2,610 | |
| 1,774 | 5,650 | |
| 1,187 | 3,570 | |
| 1,113 | 2,930 | |
| 671 | 1,280 | |
| 1,678 | 4,880 | |
| 710 | 1,620 | |
| 678 | 1,820 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
