Consider the Following Data and Its Associated Excel Output for a Simple

question 18

Multiple Choice

Consider the following data and its associated Excel output for a simple linear regression model.How would you describe the linear relationship between Y and X?
$$\begin{array} { | c | c | c | } \hline \text { Period } & \text { Y } & \text { X } \\\hline \text { Period 1 } & 10 & 1 \\\hline \text { Period 2 } & 11 & 2 \\\hline \text { Period 3 } & 9 & 3 \\\hline \text { Period 4 } & 12 & 4 \\\hline \text { Period 5 } & 13 & 5 \\\hline \text { Period 6 } & 12 & 6 \\\hline \text { Period 7 } & 15 & 7 \\\hline\end{array}$$
$$\begin{array} { | l | l | } \hline \text { Intercept } & 2.267 \\\hline \text { Slope } & 0.843 \\\hline \text { SE } & 1.810 \\\hline \text { Correlation } & 0.890 \\\hline \text { r-squared } & 0.791 \\\hline\end{array}$$

• A)no relationship
• B)positive relationship
• C)negative relationship
• D)inverse relationship
• E)not enough information is provided

---

Definitions:

Direct Labour Hours

The total hours worked by employees that are directly involved in the manufacturing or production process.

Standard Cost

Standard cost refers to the predetermined cost of manufacturing a single unit or a number of units of product under current or anticipated operating conditions.

Standard Quantity

The predetermined amount of materials, labor, or overhead that should be used in the production process, serving as a benchmark for measuring efficiency.

Variable Overhead Spending Variance

The difference between the actual variable overheads incurred and the expected costs based on standard overhead rates.