Question

According to The Wedding Report, Inc., the mean cost for a wedding in the United States is $28732 (as of November 2008). Suppose the cost for a wedding is normally distributed with a standard deviation of $1500, and that a wedding is selected at random. Use the appropriate Excel function to calculate each of the following. (Note - Part (e) can be done by hand.)
(a) Find the probability that the wedding costs less than $22000.
(b) Find the probability that the wedding costs more than $32000.
(c) Find the probability that the wedding costs between $25000 and $30000.
(d) Find Q1 (the 25th percentile) and Q3 (the 75th percentile).
(e) Find the IQR for the wedding costs.
(f) The top 10% of weddings cost more than how much?

Answer 1

Answer:

Following are the solution to the given points:

Step-by-step explanation:

$X = \text{cost of wedding}\sim \text{Normal}\ (\mu = 28732, \sigma= 1500)$

For point a:

$Probability\ = 0.00000359\\\\ \text{(Using Excel function:} =NORMDIST(22000,28732,1500,1)).$

For point b:

$Probability \ = 0.014678\\\\\text{(Using Excel function:} =1-NORMDIST(32000,28732,1500,1))$

For point c:

$Probability\ = 0.794614436$

$\text{(Using Excel function:} \\=NORMDIST (30000,28732,1500,1)-NORMDIST(25000,28732,1500,1))$

For point d:

$Q_1 = 27720.26537 \\\\\text{(Using Excel function:} =NORMINV(0.25,28732,1500)) \\\\Q_3 = 29743.73463 \\\\\text{(Using Excel function:} =NORMINV(0.75,28732,1500)).$

For point e:

$IQR = Q_3 - Q_1 = 29743.73463 - 27720.26537 = 2023.469251.$

For point f:

$Top\ 10\% = 30654.32735 \\\\\text{(Using Excel function:} =NORMINV(0.9,28732,1500)).$