ZuoTi.Pro
Question

NEED THE EXCEL FORMULAS!!! According to the 2001 Canadian census, university-educated Canadians earned a mean income...

NEED THE EXCEL FORMULAS!!! According to the 2001 Canadian census, university-educated Canadians earned a mean income of $61,823. The standard deviation is $17,301.

a.If incomes are normally distributed, what is the probability that a randomly selected university educated Canadian earns more than $70,000?

b.If incomes are normally distributed, what is the probability that a randomly selected university educated Canadian earns less than $55,000?

c. What is the cutoff for salaries for the top 10% of university-educated Canadians?

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer:

NEED THE EXCEL FORMULAS!!! According to the 2001 Canadian census, university-educated Canadians earned a mean income of $61,823. The standard deviation is $17,301.

a.If incomes are normally distributed, what is the probability that a randomly selected university educated Canadian earns more than $70,000?

P( x >70000) =0.318238

Excel formula =1-NORM.DIST(70000,61823,17301,TRUE)

b.If incomes are normally distributed, what is the probability that a randomly selected university educated Canadian earns less than $55,000?

P( x <55000) =0.346654

Excel formula: =NORM.DIST(55000,61823,17301,TRUE)

c. What is the cutoff for salaries for the top 10% of university-educated Canadians?

cutoff for Salaries of top 10% = $83995.12

Excel formula: =NORM.INV(0.9,61823,17301)

0 0
Add a comment
Know the answer?
Add Answer to:
NEED THE EXCEL FORMULAS!!! According to the 2001 Canadian census, university-educated Canadians earned a mean income...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 2. A study of Pennsylvania hospitals showed that the mean patient length of stay in 2001...

    2. A study of Pennsylvania hospitals showed that the mean patient length of stay in 2001 was 4.87 days with a standard deviation of 0.97 days. Assume that the distribution of patient length of stay is normally distributed. Sketch an appropriate GRAPH for EACH PART and shade appropriately region. Round to 4 decimal places. (3 points each) a) Find the probability that a randomly selected patient has a length of stay of greater than 7days. b) What is the probability...

  • please answer it all not using excel 8. The lengths of pregnancies are normally distributed with...

    please answer it all not using excel 8. The lengths of pregnancies are normally distributed with a mean of 267 days and a standard deviation of 15 days. (a) Find the probability that an individual woman has a pregnancy shorter than 259 days. (b) If 36 women are randomly selected, find the probability that they have a mean preg- nancy shorter than 259 days. (c) There should be a difference in your method for the previous two questions. Explain what...

  • 4. According to the Bureau of Labor Statistics, the average weekly pay for a U.S. production...

    4. According to the Bureau of Labor Statistics, the average weekly pay for a U.S. production worker was $441.84. Assume that available data indicate that production worker wages were normally distributed with a standard deviation of $90. What is the probability that a worker earned between $400 and $500? (Round to four decimal places) How much did a production worker have to earn to be in the top 20% of wage earners? (Round to two decimal places) For a randomly...

  • Find the indicated z score. The graph depicts the standard normal distribution with mean 0 and...

    Find the indicated z score. The graph depicts the standard normal distribution with mean 0 and standard deviation 1. 13) Shaded area is 0.9599. A) - 1.38 B) 1.03 1.82 D) 1.75 14) Shaded area is 0.0694. A) 1.45 B) 1.26 1.48 D) 1.39Find the indicated value. 15) z0.005 A) 2.535 D) 2.015 92.835 B) 2.575 16) z0.36  A) 1.76 B) 0.45 1.60 D) 0.36 Provide an appropriate response. 17) Find the area of the shaded region. The graph depicts IQ scores of adults, and those scores are normally distributed...

  • 8. The lengths of pregnancies are normally distributed with a mean of 267 days and a...

    8. The lengths of pregnancies are normally distributed with a mean of 267 days and a standard deviation of 15 days. (a) Find the probability that an individual woman has a pregnancy shorter than 259 days. (b) If 36 women are randomly selected, find the probability that they have a mean preg- nancy shorter than 259 days. (c) There should be a difference in your method for the previous two questions. Explain what you did differently for each problem and...

  • SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the...

    SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the company's new line of single-serve coffee pods or to await results from the product's launch in the United States. Key strategic decisions include choosing the target market to focus on and determining the value proposition to emphasize. Important questions are also raised in regard to how the new product should be branded, the flavors to offer, whether Kraft should use traditional distribution channels or...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT