Question

In: Math

According to the “Bottled Water Trends for 2014” report (bit.ly/1gx5ub8), the U.S. per capita consumption of...

According to the “Bottled Water Trends for 2014” report (bit.ly/1gx5ub8), the U.S. per capita consumption of bottled water in 2013 was 31.8 gallons. Assume that the per capita consumption of bottled water in the United States is approximately normally distributed with a mean of 31.8 gallons and a standard deviation of 10 gallons.

PLEASE USE NORMDIST AND NORMINV IN EXCEL

a. What is the probability that someone in the United States con- sumed more than 32 gallons of bottled water in 2013?

b. What is the probability that someone in the United States consumed between 10 and 20 gallons of bottled water in 2013?

c. What is the probability that someone in the United States consumed less than 10 gallons of bottled water in 2013?

d. Ninety-nine percent of the people in the United States consumed less than how many gallons of bottled water?

e) The amount of water consumed by 92% of US population will be between what two values symmetrically distributed around the mean?

Solutions

Expert Solution

Part a)

X ~ N ( µ = 31.8 , σ = 10 )
P ( X > 32 ) = 1 - P ( X < 32 )
Standardizing the value
Z = ( X - µ ) / σ
Z = ( 32 - 31.8 ) / 10
Z = 0.02
P ( ( X - µ ) / σ ) > ( 32 - 31.8 ) / 10 )
P ( Z > 0.02 )
P ( X > 32 ) = 1 - P ( Z < 0.02 )
P ( X > 32 ) = 1 - 0.508
P ( X > 32 ) = 0.492

1-NORMSDIST( Z = 0.02 )

Part b)

X ~ N ( µ = 31.8 , σ = 10 )
P ( 10 < X < 20 )
Standardizing the value
Z = ( X - µ ) / σ
Z = ( 10 - 31.8 ) / 10
Z = -2.18
Z = ( 20 - 31.8 ) / 10
Z = -1.18
P ( -2.18 < Z < -1.18 )
P ( 10 < X < 20 ) = P ( Z < -1.18 ) - P ( Z < -2.18 )
P ( 10 < X < 20 ) = 0.119 - 0.0146
P ( 10 < X < 20 ) = 0.1044

NORMSDIST( Z = -1.18) - NORMSDIST(Z = -2.18 )

Part c)

X ~ N ( µ = 31.8 , σ = 10 )
P ( X < 10 )
Standardizing the value
Z = ( X - µ ) / σ
Z = ( 10 - 31.8 ) / 10
Z = -2.18
P ( ( X - µ ) / σ ) < ( 10 - 31.8 ) / 10 )
P ( X < 10 ) = P ( Z < -2.18 )
P ( X < 10 ) = 0.0146

NORMSDIST( Z = -2.18 )

Part d)

X ~ N ( µ = 31.8 , σ = 10 )
P ( X < ? ) = 99% = 0.99
Looking for the probability 0.99 in standard normal table to calculate critical value Z = 2.3263
Z = ( X - µ ) / σ
2.3263 = ( X - 31.8 ) / 10
X = 55.063
P ( X < 55.063 ) = 0.99

NORMSINV( 0.99 )

part e)

X ~ N ( µ = 31.8 , σ = 10 )
P ( a < X < b ) = 0.92
Dividing the area 0.92 in two parts we get 0.92/2 = 0.46
since 0.5 area in normal curve is above and below the mean
Area below the mean is a = 0.5 - 0.46
Area above the mean is b = 0.5 + 0.46
Looking for the probability 0.04 in standard normal table to calculate critical value Z = -1.7507
Looking for the probability 0.96 in standard normal table to calculate critical value Z = 1.7507
Z = ( X - µ ) / σ
-1.7507 = ( X - 31.8 ) / 10
a = 14.293
1.7507 = ( X - 31.8 ) / 10
b = 49.307
P ( 14.293 < X < 49.307 ) = 0.92

NORMSINV( 0.04 )

NORMSINV( 0.96 )


Related Solutions

According to a particular marketing​ corporation, the per capita consumption of bottled water is 3.8 gallons...
According to a particular marketing​ corporation, the per capita consumption of bottled water is 3.8 gallons per month. Assume the standard deviation for this population is 0.85 gallons per month. Consider a random sample of 36 people. a. What is the probability that the sample mean will be less than 3.6 gallons per​ month? b. What is the probability that the sample mean will be more than 4.1 gallons per​ month? c. Identify the symmetrical interval that includes 83​% of...
The annual per capita consumption of bottled water was 32.6 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 32.6 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 32.6 and a standard deviation of 10 gallons. a. What is the probability that someone consumed more than 43 gallons of bottled water? b. What is the probability that someone consumed between 30 and 40 gallons of bottled water? c. What is the probability that someone consumed less than 30 gallons of bottled water? d. 90%...
The annual per capita consumption of bottled water was 32.8 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 32.8 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 32.8 and a standard deviation of 10 gallons. a. What is the probability that someone consumed more than 43 gallons of bottled​ water? b. What is the probability that someone consumed between 30 and 40 gallons of bottled​ water? c. What is the probability that someone consumed less than 30 gallons of...
The annual per capita consumption of bottled water was 30.5 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 30.5 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 30.5 and a standard deviation of 10 gallons. a. What is the probability that someone consumed more than 31 gallons of bottled​ water? b. What is the probability that someone consumed between 20 and 30 gallons of bottled​ water? c. What is the probability that someone consumed less than 20 gallons of...
The annual per capita consumption of bottled water was 31.2 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 31.2 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 31.2 and a standard deviation of 12 gallons. a. What is the probability that someone consumed more than 36 gallons of bottled​ water? b. What is the probability that someone consumed between 25 and 35 gallons of bottled​ water? c. What is the probability that someone consumed less than 25 gallons of...
The annual per capita consumption of bottled water was 34.334.3 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 34.334.3 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 34.334.3 and a standard deviation of 1212 gallons. a. What is the probability that someone consumed more than 4444 gallons of bottled​ water? b. What is the probability that someone consumed between 3030 and 4040 gallons of bottled​ water? c. What is the probability that someone consumed less than 3030 gallons of...
The annual per capita consumption of bottled water was 32.7 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 32.7 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 32.7 and a standard deviation of 10 gallons. a. What is the probability that someone consumed more than 33 gallons of bottled​ water? b. What is the probability that someone consumed between 20 and 30 gallons of bottled​ water? c. What is the probability that someone consumed less than 20 gallons of...
The annual per capita consumption of bottled water was 32.8 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 32.8 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 32.8 and a standard deviation of 11 gallons. A. What is the probability that someone consumed more than 43 gallons of bottled​water? B. What is the probability that someone consumed between 20 and 30 gallons of bottled​ water? C. What is the probability that someone consumed less than 20 gallons of bottled​water?...
The annual per capita consumption of bottled water was 34.7 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 34.7 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 34.7 and a standard deviation of 10 gallons. a. What is the probability that someone consumed more than 45 gallons of bottled​ water? b. What is the probability that someone consumed between 25 and 35 gallons of bottled​ water? c. What is the probability that someone consumed less than 25 gallons of...
The annual per capita consumption of bottled water was 32.7 gallons. Assume that the per capita...
The annual per capita consumption of bottled water was 32.7 gallons. Assume that the per capita consumption of bottled water is approximately normally distributed with a mean of 32.7 and a standard deviation of 13 gallons. a. What is the probability that someone consumed more than 43 gallons of bottled​ water? b. What is the probability that someone consumed between 25 and 35 gallons of bottled​ water? c. What is the probability that someone consumed less than 25 gallons of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT