Examlex

Solved

TABLE 14-8
a Financial Analyst Wanted to Examine SUMMARY OUTPUT\text {SUMMARY OUTPUT}

question 96

Short Answer

TABLE 14-8
A financial analyst wanted to examine the relationship between salary (in $1,000) and 4 variables: age (X1 = Age), experience in the field (X2 = Exper), number of degrees (X3 = Degrees), and number of previous jobs in the field (X4 = Prevjobs). He took a sample of 20 employees and obtained the following Microsoft Excel output:
SUMMARY OUTPUT\text {SUMMARY OUTPUT}
 Regression Statistics  Multiple R 0.992 R Square0.984 Adjusted R Square0.979 Standard Error 2.26743 Observations20\begin{array}{ll}\hline \text { Regression Statistics } \\\hline \text { Multiple R }& 0.992 \\ \text { R Square} & 0.984 \\ \text { Adjusted R Square} & 0.979 \\ \text { Standard Error }& 2.26743 \\ \text { Observations} & 20 \\\hline\end{array}

ANOVA
d f  SS  M S  F Significance F  Regression44609.831641152.45791224.1600.0001Residual1577.118365.14122Total194686.95000\begin{array}{lccclc}\hline & \text {d f }& \text { SS }& \text { M S } & \text { F } & \text {Significance F } \\\hline \text { Regression} & 4 & 4609.83164& 1152.45791 & 224.160& 0.0001 \\ \text {Residual} &15& 77.11836 & 5.14122& & \\ \text {Total} & 19 & 4686.95000 & & & \\\hline\end{array}

Coefficients Standard Error t Stat  p -value Intercept 9.6111982.779886383.4570.0035 Age 1.3276950.1149193011.5530.0001 Exper 0.1067050.142655590.7480.4660 Degrees7.3113320.803241879.1020.0001 Prevjobs 0.5041680.447715731.1260.2778\begin{array}{lrrrr}\hline & \text {Coefficients} &\text { Standard Error} & \text { t Stat } & \text { p -value} \\\hline \text { Intercept }& -9.611198 & 2.77988638 & -3.457 & 0.0035 \\\text { Age }& 1.327695 & 0.11491930 & 11.553 & 0.0001 \\\text { Exper }& -0.106705 & 0.14265559 & -0.748 & 0.4660 \\\text { Degrees} & 7.311332 & 0.80324187 & 9.102 & 0.0001 \\\text { Prevjobs }& -0.504168 & 0.44771573 & -1.126 & 0.2778 \\\hline\end{array}

-Referring to Table 14-8, the value of the adjusted coefficient of multiple determination, adj
r2, is _____.


Definitions:

Corporate Executives

Senior management officials within a corporation, responsible for making major corporate decisions.

Profit Centers

Segments or areas of a business that are responsible for generating their own revenues and profits.

Incentives

Rewards or penalties designed to encourage or discourage specific behaviors among individuals or groups, often used in economic and business contexts.

Information

is data that is processed, organized, or presented in a manner that makes it meaningful and useful for decision-making, learning, or analysis.

Related Questions