Instruction 12 $\text { Regression statistics }$ $\text { ANOVA }$

question 40

Multiple Choice

Instruction 12.23
The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel's Data Analysis tool to analyse the last four years of quarterly data with the following results:
$\text { Regression statistics }$
$\begin{array}{|l|l|}\hline \text { Multiple R } & 0.802 \\\hline \text { R Square } & 0.643 \\\hline \begin{array}{l}\text { Adjusted R } \\\text { Square }\end{array} & 0.618 \\\hline \begin{array}{l}\text { Standard Error } \\\text { SYX }\end{array} & 0.9224 \\\hline \text { Observations } & 16 \\\hline\end{array}$

$\text { ANOVA }$
$\begin{array}{|l|l|l|l|l|l|}\hline & \text { df } & \text { SS } & \text { MS } & \text { F } & \text { Sig.F } \\\hline \text { Regression } & 1 & 21.497 & 21.497 & 25.27 & 0.000 \\\hline \text { Error } & 14 & 11.912 & 0.851 & & \\\hline \text { Total } & 15 & 33.409 & & & \\\hline\end{array}$

$\begin{array}{|l|l|l|l|l|}\hline\text { Predictor } & \text { Coef } & \text { StdError } & \text { t Stat } & \text { p-value } \\\hline \text { Intercept } & 3.962 & 1.440 & 2.75 & 0.016 \\\hline \text { Industry } & 0.040451 & 0.008048 & 5.03 & 0.000\\\hline\end{array}$


$\begin{array}{|l|l|}\hline\text { Durbin-Watson } & 1.59 \\\text { Statistic } &\\\hline\end{array}$

-Referring to Instruction 12.23,if the Durbin-Watson statistic has a value close to 4,which assumption is violated?

• A) Homoscedasticity
• B) Normality of the errors
• C) Independence of errors
• D) None of the above

---

Definitions:

Human Resource Audits

A comprehensive method of objectively and systematically evaluating the effectiveness of an organization's HR policies, procedures, and strategies.

Transitional Probability Matrices

In mathematics and statistics, these matrices are used to describe the probabilities of transitioning from one state to another in a stochastic (random) process.

Markov Analysis

A statistical method used to predict future states based on current data and the probabilities of various outcomes, often applied in decision-making processes.

HR Objectives

The strategic goals set by the Human Resources department to support overall organizational growth, employee development, and operational efficiency.