Excel Differentiates Z-Scores and Z-Values by Identifying One Sample Test

question 9

Multiple Choice

Excel differentiates z-scores and z-values by identifying one sample test by using what function?

• A) FTEST
• B) CHITEST
• C) TTEST
• D) ZTEST

---

Definitions:

Common Stock

A type of security that represents ownership in a corporation, granting holders voting rights and a share in the company's profits through dividends.

Earnings Per Share

A financial ratio calculated by dividing a company's net profit by the number of its outstanding shares, indicating the profitability on a per-share basis.

Bonds Payable

A long-term debt instrument issued by corporations or governments that promises to pay the holder a specified sum of money at a future date plus periodic interest payments.

Lease Liability

An obligation representing the present value of future lease payments that a lessee is committed to pay over the lease term.