Statistics Calculation Help?

What is the calculation? Can I do this in excel?

Misc. Inc has applied to the country government for permit to construct a toxic waste disposal facility. Trucks carrying toxic waste to the proposed site must go under an overpass on interstate 80, or must exit the freeway and detour through the center of a business district. Managers are worried about possible health effects in case of an accident. The overpass has a clearance of 23 feet. The height of the trucks that carry the toxic waste has a mean of 18 feet and standard deviation of three feet.
a. Find the proportion of trucks carrying toxic wastes that must take the detour through the center of the business district.

b. Find the height of a new overpass structure that would be required to accommodate 99.9% of the trucks.

Answer:
As stated the problem cannot be solved, because the distribution type is not specified. However, if we assume a normal distribution the problem can be easily solved using MS Excel.

Use the following equations.
a. =NORMDIST(23,18,3,1)
b. =NORMINV(0.999,18,3)

The answers post by the user, for information only, FunQA.com does not guarantee the right.



More Questions and Answers:
  • What's the difference between forward and reverse based P-N junctions?
  • My AIEEE 2007 All India Rank is 3185. What must be my college priority list ??
  • I got mettalurgy in NIT jaipur and sure to get aerospace engineering thru IIST.Which institute should i join?
  • Can anyone help me with Engineering Management case Study?
  • What size electricity supply at wembley stadium?
  • How can I wire a snap action roller switch to a 48V DC motor?
  • Any way to convert Schematic to PCB with any software ?
  • Advanced fluid mechanic question?answer this question in 24 hours and get a gift from iran.?
  • How are glass fibers made that are used in clean room filters or hepa filters?