A real estate developer wishes to study the relationship betweenthe size of home a client will purchase (in square feet) and othervariables. Possible independent variables include the familyincome, family size, whether there is a senior adult parent livingwith the family (1 for yes, 0 for no), and the total years ofeducation beyond high school for the husband and wife. The sampleinformation is reported below.
| Family | Square Feet | Income (000s) | Family Size | Senior Parent | Education |
| 1 | | 2,200 | | 60.8 | | 2 | | 0 | | 4 | |
| 2 | | 2,300 | | 68.4 | | 2 | | 1 | | 6 | |
| 3 | | 3,400 | | 104.5 | | 3 | | 0 | | 7 | |
| 4 | | 3,360 | | 89.3 | | 4 | | 1 | | 0 | |
| 5 | | 3,000 | | 72.2 | | 4 | | 0 | | 2 | |
| 6 | | 2,900 | | 114 | | 3 | | 1 | | 10 | |
| 7 | | 4,100 | | 125.4 | | 6 | | 0 | | 6 | |
| 8 | | 2,520 | | 83.6 | | 3 | | 0 | | 8 | |
| 9 | | 4,200 | | 133 | | 5 | | 0 | | 2 | |
| 10 | | 2,800 | | 95 | | 3 | | 0 | | 6 | |
|
- Develop an appropriate multiple regression equation usingstepwise regression. (Use Excel data analysis and enternumber of family members first, then their income and delete anyinsignificant variables. Leave no cells blank - be certain to enter\"0\" wherever required. R and R2 adj are in percent values.Round your answers to 3 decimal places.)
|
| | Step | 1 | 2 | | Constant | | | | Family Size | | | | t-statistic | | | | p-value | | | | Income | | | | t-statistic | | | | p-value | | | | S | | | | R-Sq | | | | R-Sq(adj) |
|
