According to the “Bottled Water Trends for 2014” report(bit.ly/1gx5ub8), the U.S. per capita consumption of bottled waterin 2013 was 31.8 gallons. Assume that the per capita consumption ofbottled water in the United States is approximately normallydistributed with a mean of 31.8 gallons and a standard deviation of10 gallons.
PLEASE USE NORMDIST AND NORMINV IN EXCEL
a. What is the probability that someone in the United Statescon- sumed more than 32 gallons of bottled water in 2013?
b. What is the probability that someone in the United Statesconsumed between 10 and 20 gallons of bottled water in 2013?
c. What is the probability that someone in the United Statesconsumed less than 10 gallons of bottled water in 2013?
d. Ninety-nine percent of the people in the United Statesconsumed less than how many gallons of bottled water?
e) The amount of water consumed by 92% of US population will bebetween what two values symmetrically distributed around themean?
