SOLUTION: Q: The time spent by customers in a supermarket follows a normal distribution with mean 23 minutes and standard deviation 6 minutes. If six customers go to the supermarket what

Algebra ->  Probability-and-statistics -> SOLUTION: Q: The time spent by customers in a supermarket follows a normal distribution with mean 23 minutes and standard deviation 6 minutes. If six customers go to the supermarket what      Log On


   



Question 434560: Q: The time spent by customers in a supermarket follows a normal distribution with mean 23 minutes and standard deviation 6 minutes.
If six customers go to the supermarket what is the probability that the total time spent in the supermarket by all six customers is at least two hours and fifteen minutes?
How would i solve this question in MICROSOFT EXCEL 2010??

Answer by stanbon(75887) About Me  (Show Source):
You can put this solution on YOUR website!
The time spent by customers in a supermarket follows a normal distribution with mean 23 minutes and standard deviation 6 minutes.
If six customers go to the supermarket what is the probability that the total time spent in the supermarket by all six customers is at least two hours and fifteen minutes?
How would i solve this question in MICROSOFT EXCEL 2010??
--------------------
Can't help you with the software; can with the problem.
-----
x-bar = (2*60+15)/6 = 22.5 minutes
-----
t(22.5) = (22.5-23)/[6/sqrt(6)] = -0.0340
---
P(x-bar >= 22.5) = P(t >= -0.0340 with df = 5) = 0.5129
======================
Cheers,
Stan H.
==============