out

References

Mailings

Review

View

$A^2|Aavv{A}_{}|$

AvvQ$*$

AaBbCcDdEe

AaBbCcDdE,

AaBbCcDdEe

AaBbCcDdEe

Normal

Body Text

List Paragraph

No Spacing

Styles

Pane

$18.x$ is normally distributed with a mean of $32$ and a standard deviation of $8.$ What Excel calculation would give the probability that $x$ is greater than $43?$

a$.=$ NORMSINV $(0\mathrm{.}25)$

b$.=$ NORMSDIST$(1\mathrm{.}375)$

c$.=$ NORMSINV$(5\mathrm{.}375)$

d$.=1-$ NORMSDIST$(1\mathrm{.}375)$

e$.=1-$ NORMSDIST$(5\mathrm{.}375)$

$19.$ Consider this question: "What interval $($centered on $100)$ will contain $80\%$ of all observations in a normally distributed population with a mean of $100$ and a standard deviation of $10?"$ Which of the following calculations would provide the upper cutoff for this range?

a$.=$NORMSINV$(0\mathrm{.}8)**10$

b$.=$ NORMSINV $(0\mathrm{.}9)*\frac{*}{S}QRT(10)$

c$.=$TINV$(0\mathrm{.}8,99)**100$

d$.=100+$NORMSINV$(0\mathrm{.}8{)}_{*}\frac{*}{S}QRT(10)$

e$.=()0\mathrm{.}9$

$20.$ Consider this question: "According to government data, $25\%$ of employed women have never been married. If $5$ employed women are selected at random, what is the probability that exactly $2$ have never been married?" Which of the following calculations would provide the answer to this question? $($You may assume that the population of employed women is essentially infinite.$)$

a$.=$NORMSINV$(0\mathrm{.}25)*\frac{*}{S}QRT(\frac{0\mathrm{.}4**0\mathrm{.}6}{5})$

b$.=$ NORMSINV $(0\mathrm{.}4)*\frac{*}{S}QRT(\frac{0\mathrm{.}25**0\mathrm{.}75}{5})$

c$.,$ TRUE$)$

d$.=$ BINOMDIST $,$ FALSE$)$

e$.=$ BINOMDIST $,$ TRUE$)$

$21.$ Consider this question: "Suppose that, on average, three customers arrive per minute at a bank during the noon hour. What is the probability that two customers will arrive in a given minute?" An Excel computation giving the answer is

a$.,$ FALSE$)$

b$.=$ BINOMDIST$(2,3,2,$ TRUE$)$

c$.=$ POISSON $,$ FALSE