Consider the Following Data and Excel Output for a Simple

question 47

Multiple Choice

Consider the following data and Excel output for a simple linear regression model.How much of the total variation in the dependent variable (Y) is explained by the independent variable (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)2.267
• B)0.843
• C)1.810
• D)0.890
• E)0.791

---

Definitions:

Expected Cash Flows

Projections of cash revenues and expenditures that a company anticipates receiving or paying out, crucial for budgeting and financial planning.

Secondary Market Transaction

A secondary market transaction occurs when financial assets, such as stocks or bonds, are bought and sold among investors after the original issuance.

Broker

An individual or entity that acts as an intermediary between buyers and sellers in financial transactions.

TSX

Toronto Stock Exchange, the largest stock exchange in Canada, where stocks, bonds, and other securities are bought and sold.