Share
Explore BrainMass

Normal Distribution using Excel

I would like the response to sample problems below in excel format.

6.48
An orange juice producer buys all his oranges from a large orange grove. The amount of juice squeezed from each of these oranges is approximately normally distributed, with a mean of 4.70 ounces and a standard deviation of 0.40 ounce.

A. What is the probability that a randomly selected orange will contain between 4.70 and 5.00 ounces of juice?
B. What is the probability that a randomly selected orange will contain between 5.00 and 5.50 ounces of juice?
C. 77% of the oranges will contain at least how many ounces of juice?
D. 80% of the oranges contain between what two values (in ounces of juice), symmetrically distributed around the population mean?

6.53
The same article mentioned in Problem 6.52 also reported that the mean download time for H&R Block Web site, www.hrblock.com, is 2.5 seconds. Suppose that the download time is normally distributed, with a standard deviation of 0.5 second. What is the probability that a download time is

a. less than 1 second?
b. between 0.5 and 1.5 seconds?
c. above 0.5 second?
d. Above how many seconds are 99% of the download times?

Solution Summary

The solution provides step by step method for the calculation of probability using the Z score. Formula for the calculation and Interpretations of the results are also included.

$2.19