Use a Standard Spreadsheet Program, Such as Excel, to Find $X _ { \mathrm {10 } } ^ { 2 }$

question 37

Essay

Use a standard spreadsheet program, such as Excel, to find the following probabilities from various distributions analyzed in the current chapter:
a. If Y is distributed , find Pr(Y ? 7.78)
b. If Y is distributed $X _ { \mathrm {10 } } ^ { 2 }$ , find Pr(Y > 18.31)
c. If Y is distributed F_10,?, find Pr(Y > 1.83)
d. If Y is distributed t₁₅, find Pr(Y > 1.75)
e. If Y is distributed t₉₀, find Pr(-1.99 ?Y ? 1.99)
f. If Y is distributed N(0,1), find Pr(-1.99 ?Y ? 1.99)
g. If Y is distributed F_10,4, find Pr(Y > 4.12)
h. If Y is distributed F_7,120, find Pr(Y > 2.79)

---

Definitions:

Promissory Note

A monetary tool that involves a formal pledge from one entity to another to pay a specific amount of cash, either upon request or at an agreed-upon date in the future.

Maturity

The date on which a financial obligation, such as a loan or bond, is due to be repaid in full.

Interest Receivable

An accounting term for interest income that is earned but not yet received in cash.

Accounts Receivable

The money owed to a business by its customers for goods or services that have been delivered but not yet paid for.