A natural mineral water distributor bottles mineral water at the source.
The volume of water in a one-litre bottle is normally distributed with a
mean of 1,005 ml and a standard deviation of 15 ml.
a )What is the probability that the volume of the content of a randomly
selected one-litre bottle will be exactly 1,005 ml?
b) What is the probability that the volume of the content of a randomly
selected one-litre bottle will be between 990 ml and 1,002 ml?
c )Find the value of V that makes the following statement correct:
‘5% of the volume of the content of the one-litre bottles is less than V ml.’
d) Repeat part (c) by using Excel. You are required to submit a
computer printout of the relevant Excel spreadsheet that contains the
corresponding input function (with specified values for each of the
parameters) together with the output figure.
請附詳細答案&公式!!!thzzzzzzzzz