SCENARIO 17-1
a Real Estate Builder Wishes to Determine How

question 308

Multiple Choice

SCENARIO 17-1
A real estate builder wishes to determine how house size (House) is influenced by family income
(Income) , family size (Size) , and education of the head of household (School) . House size is
measured in hundreds of square feet, income is measured in thousands of dollars, and education is in
years. The builder randomly selected 50 families and ran the multiple regression. Microsoft Excel
output is provided below: SUMMARY OUTPUT
Regression Statistics
$\begin{array} { l l } \text { Multiple R } & 0.865 \\ \text { R Square } & 0.748 \\ \text { Adjusted R Square } & 0.726 \\ \text { Standard Error } & 5.195 \\ \text { Observations } & 50 \end{array}$
ANOVA
$\begin{array} { l c c c c c } & d f & \text { SS } & \text { MS } & F & \text { Signif } F \\ \text { Regression } & & 3605.7736 & 1201.9245 & & 0.0000 \\ \text { Residual } & & 1214.2264 & 26.3962 & & \\ \text { Total } & 49 & 4820.0000 & & & \end{array}$

$\begin{array} { l c l c c } & \text { Coeff } & \text { StdError } & t \text { Stat } & P \text {-value } \\ \text { Intercept } & - 1.6335 & 5.8078 & - 0.281 & 0.7798 \\ \text { Income } & 0.4485 & 0.1137 & 3.9545 & 0.0003 \\ \text { Size } & 4.2615 & 0.8062 & 5.286 & 0.0001 \\ \text { School } & - 0.6517 & 0.4319 & - 1.509 & 0.1383 \end{array}$
-Referring to Scenario 17-1, 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?

• A) 0.0001
• B) 0.0299
• C) 0.726
• D) 45.5340

---

Definitions:

Numerical Estimate

A quantitative assessment or approximation of a figure related to a specific topic or project.

HR Surplus

The situation where an organization has more employees than needed to effectively accomplish its goals, leading to potential restructuring or downsizing.

Human Capital

The economic value of the skills, knowledge, and experience possessed by an individual or population, viewed in terms of their contribution to the organization.

HR Projection

The activity of predicting the future human resources requirements to achieve the anticipated levels of business operations.