Question: A real estate developer wishes to study the relationship between the size of home a client will purchase (in square feet) and other variables. Possible
A real estate developer wishes to study the relationship between the size of home a client will purchase (in square feet) and other variables. Possible independent variables include the family income, family size, whether there is a senior adult parent living with the family (1 for yes, 0 for no), and the total years of education beyond high school for the husband and wife. The sample information is reported below.




A real estate developer wishes to study the relationship between the size of home a client will purchase (in square feet] and other variables. Possible independent variables include the family income, famin size, whether there is a senior adult parent living with the family (1 for yes, 0 for no], and the total years of education beyond high school for the husband and wife. The sample information is reported below. Square Income Fami 13! Senior Family Feet (0003] Size Parent Education 1 2,240 60.3 2 0 4 2 2,330 63.4 2 1 E 3 3,640 104.5 3 0 7 4 3,360 39.3 4 1 0 5 3,030 72.2 4 0 2 6 2,940 114 3 1 10 7 4,430 125.4 6 0 E 3 2,520 33.6 3 0 3 9 4,200 133 5 0 2 10 2,300 95 3 0 6 E Click here for the Excel Data File a. Develop an appropriate multiple regression equation using stepwise regression. {Use Excel data analysis and enter number of family members rst, then their income and delete any insignicant variables. Leave no cells blank - be certain to enter \"0" wherever required. Rand R2 adj are in percent values. Round your answers to 3 decimal places.) Family.r Size tStatistic b. Select all independent variables that should be in the final model. [You may select more than one answer. Single-click the box with the question mark to produce a check mark for a correct answer and double-click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) E Senior parent a Square feet a Family size E Income a Education c. Write out the regression equation. W d. Report and interpret the adjusted R2. R2 %
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
