The dimension of a machined part made by Machinheimer Machinery has a nominal specification of 11.9 cm.

Question:

The dimension of a machined part made by Machinheimer Machinery has a nominal specification of 11.9 cm. The process that produces the part can be controlled to have a mean value equal to this specification, but has a standard deviation of 0.05 cm. What is the probability that a part will have a dimension:a. Exceeding 12 cm?b. Between 11.9 and 11.95 cm?c. Less than 11.83 cm?


 































































































































































































































































































































































































































































































































































































































































































































































































Machinheimer Machinery
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 D10, below. The calculated z-value and probability will be seen in D11 and D12. 
Mean of distribution11.9
Std deviation of distribution0.05
Desired x-value12
Calculated z-value2.000
Probability of x, or less0.97725
(X-axis)Probability Using
Desired x-valuesEquivalent - Z ValuesNORMS.DIST
11.700-4.000.00003
11.705-3.900.00005
11.710-3.800.00007
11.715-3.700.00011
11.720-3.600.00016
11.725-3.500.00023
11.730-3.400.00034
11.735-3.300.00048
11.740-3.200.00069
11.745-3.100.00097
11.750-3.000.00135
11.755-2.900.00187
11.760-2.800.00256
11.765-2.700.00347
11.770-2.600.00466
11.775-2.500.00621
11.780-2.400.00820
11.785-2.300.01072
11.790-2.200.01390
11.795-2.100.01786
11.800-2.000.02275
11.805-1.900.02872
11.810-1.800.03593
11.815-1.700.04457
11.820-1.600.05480
11.825-1.500.06681
11.830-1.400.08076
11.835-1.300.09680
11.840-1.200.11507
11.845-1.100.13567
11.850-1.000.15866
11.855-0.900.18406
11.860-0.800.21186
11.865-0.700.24196
11.870-0.600.27425
11.875-0.500.30854
11.880-0.400.34458
11.885-0.300.38209
11.890-0.200.42074
11.895-0.100.46017
11.9000.000.50000
11.9050.100.53983
11.9100.200.57926
11.9150.300.61791
11.9200.400.65542
11.9250.500.69146
11.9300.600.72575
11.9350.700.75804
11.9400.800.78814
11.9450.900.81594
11.9501.000.84134 Transcribed Image Text:

Cumulative Probability Cumulative Probability Function 1.00 0.90 0.80 0.70 0.60 0.50 9.40 0.30 0.20 0.10 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: