Question

A city mayor in Michigan is planning the number of new snow plows he must purchase...

A city mayor in Michigan is planning the number of new snow plows he must purchase to remove the snow next winter. The average snowfall in the past 10 years has been normally distributed with a mean of 112 inches and a standard deviation of 14 inches.

Use Excel to find the amount, in inches, that separates the lowest 20% of the means of yearly snowfall in the past 10 years from the highest 80%.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

X ~ N ( µ = 112 , σ = 14 )

Excel formula

NORM.INV(0.2,112,14) = 100.2173 inches.

Add a comment
Know the answer?
Add Answer to:
A city mayor in Michigan is planning the number of new snow plows he must purchase...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • A company is offering 401k matching retirement plan for its employees who stay with the company...

    A company is offering 401k matching retirement plan for its employees who stay with the company for more than 10 years. The company's CFO finds that the average retirement account holds $490,000, with a standard deviation of $55,000, distributed normally. Use Excel to calculate the amount of money that separates the lowest 20% of the means of retirement accounts from the highest 80% in a sampling of 80 employees.

  • Question 12 pts The length of time a person takes to decide which shoes to purchase...

    Question 12 pts The length of time a person takes to decide which shoes to purchase is normally distributed with a mean of 8.21 minutes and a standard deviation of 1.90. Find the probability that a randomly selected individual will take less than 6 minutes to select a shoe purchase. Is this outcome unusual? Group of answer choices Probability is 0.88, which is usual as it is greater than 5% Probability is 0.12, which is usual as it is not...

  • 1) Come up with a single (one) question or problem 2) Think of an example with 30 data points a. ...

    1) Come up with a single (one) question or problem 2) Think of an example with 30 data points a. This data needs to be of a quantitative variable (numbers). 3) Then proceed to follow the below steps. example of 30 quantitative data points Purpose State how, when, and where data was collected List of raw data pairs Frequency distribution (table) Histogram Relative percentage polygon Sample mean Sample median Sample mode(s) Sample range Sample variance Sample standard deviation Coefficient of...

  • 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...

  • My question is about the case study “ Comparing Apples and Oranges: which group yuelds the...

    My question is about the case study “ Comparing Apples and Oranges: which group yuelds the best profit?” 1) Using the Excel apreadsheet attached to complete the rooms sold and revenue projections based on the above case study. Case Study: "Comparing Apples and Oranges: Which Group Yields the Best Profit?" ​The Diamond Peak Hotel, one of 45 hotels in the Host Marriott management company, was bustling with business this Thursday afternoon as the hour of the daily revenue meeting drew...

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