Wayback Cleaning Co. has found that standard size offices have a standard deviation of 5 minutes for

Question:

Wayback Cleaning Co. has found that standard size offices have a standard deviation of 5 minutes for their cleaning time. The operations manager knows that 95 percent of the offices require more than 120 person-minutes to clean. However, she wishes to find out the average cleaning time for the offices. Can you calculate that for her?


 































































































































































































































































































































































































































































































































































































































































































































































































Wayback Cleaning Co.
Probability Calculations Using the Normal Distribution - Template
Enter data only in the shaded cells
This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, 
given the mean and standard deviation of a normally distributed variable. It uses the cumulative normal distribution
Enter the mean of the distribution in shaded cell D11 and the standard deviation in shaded cell D12. below. 
Enter the desired X-value in shaded cell D13, below. The calculated z-value and probability will be seen in D14 and D15. 
Mean of distribution128.225
Std deviation of distribution5
Desired x-value120
Calculated z-value-1.645
Probability of x, or less0.04998
(X-axis)Probability Using
Desired x-valuesEquivalent - Z ValuesNORMS.DIST
108.225-4.000.00003
108.725-3.900.00005
109.225-3.800.00007
109.725-3.700.00011
110.225-3.600.00016
110.725-3.500.00023
111.225-3.400.00034
111.725-3.300.00048
112.225-3.200.00069
112.725-3.100.00097
113.225-3.000.00135
113.725-2.900.00187
114.225-2.800.00256
114.725-2.700.00347
115.225-2.600.00466
115.725-2.500.00621
116.225-2.400.00820
116.725-2.300.01072
117.225-2.200.01390
117.725-2.100.01786
118.225-2.000.02275
118.725-1.900.02872
119.225-1.800.03593
119.725-1.700.04457
120.225-1.600.05480
120.725-1.500.06681
121.225-1.400.08076
121.725-1.300.09680
122.225-1.200.11507
122.725-1.100.13567
123.225-1.000.15866
123.725-0.900.18406
124.225-0.800.21186
124.725-0.700.24196
125.225-0.600.27425
125.725-0.500.30854
126.225-0.400.34458
126.725-0.300.38209
127.225-0.200.42074
127.725-0.100.46017
128.2250.000.50000
128.7250.100.53983
129.2250.200.57926
129.7250.300.61791
130.2250.400.65542
130.7250.500.69146
131.2250.600.72575
131.7250.700.75804
132.2250.800.78814
132.7250.900.81594
133.2251.000.84134 Transcribed Image Text:

Cumulative Probability Cumulative Probability Function 1.00 0.90 0.80 0.70 0.60 0.50 0.40 0.30 0.20 0.00 4.0-3.8-3.6-3.4-3.2-3.0-2.8-2.6-2.4-2.2-2.0-1.8-1.6-1.4-1.2-1.0-0.8-0.6-0.4-0.20.0 0.2 0.4 0.6 0.8 1.0 1.2 1.4 1.6 1.8 2.0 2.2 2.4 2.6 2.8 3.0 3.2 3.4 3.6 3.84.0 z-values -NORMS. DIST

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: