Explore BrainMass
Share

Probability of a Value in Normal Distribution with Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

A normal distribution has a mean of 50 and a standard deviation of 4. Please use Excel Spreadsheets. Show all work and formulas

a) Compute the probability of a value between 44.0 and 55.0

b) Compute the probability of a value greater than 55.0

c) Compute the probability of a value between 52.0 and 55.0

© BrainMass Inc. brainmass.com October 24, 2018, 7:14 pm ad1c9bdddf
https://brainmass.com/economics/finance/probability-of-a-value-in-normal-distribution-with-excel-61598

Solution Summary

Computes the probability of values in given ranges with a normal distribution.

$2.19
See Also This Related BrainMass Solution

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?

View Full Posting Details