SCENARIO 13-4
a Real Estate Builder Wishes to Determine How

question 204

Short Answer

SCENARIO 13-4
A real estate builder wishes to determine how house size (House) is influenced by family income (Income) and family size (Size).House size is measured in hundreds of square feet and income is measured in thousands of dollars.The builder randomly selected 50 families and ran the multiple regression.Partial Microsoft Excel output is provided below: $\begin{array}{lr}\hline{\text { Regression Statistics }} \\\hline \text { Multiple R } & 0.8479 \\\text { R Square } & 0.7189 \\\text { Adjusted R Square } & 0.7069 \\\text { Standard Error } & 17.5571 \\\text { Observations } & 50\\\hline \end{array}$

$\text { ANOVA }$
$\begin{array}{lrrrrr} & d f & \text { SS } & {M S} & F & \text { Significance } F \\\hline \text { Regression } & & & 37043.3236 & 18521.6618 & 0.0000 \\\text { Residual } & & 14487.7627 & 308.2503 & \\\text { Total } & & 49 & 51531.0863 & &\end{array}$

$\begin{array}{lrrrr}\hline & \text { Coefficients } & \text { Standard Error } &{t \text { Stat }} & \text { P-value } \\\hline \text { Intercept } & -5.5146 & 7.2273 & -0.7630 & 0.4493 \\\text { Income } & 0.4262 & 0.0392 & 10.8668 & 0.0000 \\\text { Size } & 5.5437 & 1.6949 & 3.2708 & 0.0020\\\hline \end{array}$

$\text { Also } \operatorname{SSR}\left(X_{1} \mid X_{2}\right)=36400.6326 \text { and } \operatorname{SSR}\left(X_{2} \mid X_{1}\right)=3297.7917$


-Referring to SCENARIO 13-4, what is the value of the calculated F test statistic that is missing from the output for testing whether the whole regression model is significant?

---

Definitions:

American Civil Rights Legislation

Legislation aimed at ending discrimination based on race, color, religion, sex, or national origin in the United States, and promoting equal rights for all citizens.

Third-Country Nationals

Employees who are working in a country that is neither their home country nor the country of the company they are working for.

Multinational Companies

Corporations that own or control production or service facilities outside the country in which they are based, operating in several countries around the world.

Expatriates

Individuals residing and working in a country other than their native country, usually for professional or employment reasons.