SCENARIO 14-8 A Financial Analyst Wanted to Examine the Relationship Between Salary

question 144

Short Answer

SCENARIO 14-8
A financial analyst wanted to examine the relationship between salary (in $1,000) and 2 variables: age (X₁ = Age) and experience in the field (X₂ = Exper). He took a sample of 20 employees and obtained the following Microsoft Excel output:


Also, the sum of squares due to the regression for the model that includes only Age is 5022.0654 while the sum of squares due to the regression for the model that includes only Exper is 125.9848.
-Referring to Scenario 14-8,the value of the partial F test statistic is _____ for
H₀ : Variable X₂ does not significantly improve the model after variable X₁ has been included
H₁ : Variable X₂ significantly improves the model after variable X₁ has been included

---

Definitions:

Discounted Payback

A capital budgeting method used to determine the profitability of an investment by calculating the time it takes for the present value of cash flows to cover the initial investment cost.

Annual Cash Flows

The total amount of money being transferred in and out of a business, considered on a yearly basis.

Required Rate

The minimum return an investor expects to achieve on an investment, considering its risk, also known as the hurdle rate or the required rate of return.

Internal Rate Return

A financial metric used to estimate the profitability of potential investments, calculated as the discount rate that makes the net present value (NPV) of all cash flows from the investment equal to zero.