Excel's NORM

question 26

Multiple Choice

Excel's NORM.S.INV function can be used to compute _____.

• A) cumulative probabilities for a standard normal z value
• B) the standard normal z value given a cumulative probability
• C) cumulative probabilities for a normally distributed x value
• D) the normally distributed x value given a cumulative probability

---

Definitions:

P/E Ratio

Price-to-Earnings Ratio, a valuation metric that compares a company's stock price to its per-share earnings, used to evaluate if a stock is over or undervalued.

EPS

Earnings per share, a company's profit divided by its number of outstanding shares.

Intrinsic Value

The actual value of a company or an asset based on underlying perception of its true value including all aspects of the business, in terms of both tangible and intangible factors.

P/E Multiple

Price-to-Earnings ratio, a valuation metric calculated by dividing the current market price of a stock by its earnings per share, indicating how much investors are willing to pay per dollar of earnings.