Use the Data Given Below to Answer the Following Questions)

question 5

Essay

Use the data given below to answer the following questions).
Following is an extract from a firm's database detailing the number of hours spent on the job by employees and their corresponding pay. Note: Assume a level of significance of 0.05 wherever necessary.) $$\begin{array} { | c | c | } \hline \text { Hours spent on the job } & \text { Salary } \$ \mathbf { ~ } \\\hline 4 & 340 \\\hline 12 & 850 \\\hline 7 & 570 \\\hline 5 & 470 \\\hline 11 & 820 \\\hline 8 & 610 \\\hline 9 & 630 \\\hline 13 & 900 \\\hline 10 & 800 \\\hline 6 & 480 \\\hline\end{array}$$
-Construct a scatter diagram and use the Excel Trendline tool to find the best-fitting simple linear regression model.

---

Definitions:

Dividends

Payments made by a corporation to its shareholder members, representing a portion of the corporate profits.

Capital Gains Yield

The percentage change in the market price of an asset over a period, excluding dividends.

Shares

Shares represent units of ownership interest in a corporation or financial asset, providing a proportionate claim on its assets and profits.

Geometric Return

The average rate of return per period on an investment, calculated by taking the nth root of the total compounded return, where n is the number of periods.