Kiwi Oil is sold in 950-milliliter (ml) cans. The mean volume of oil placed in a can

Question:

Kiwi Oil is sold in 950-milliliter (ml) cans. The mean volume of oil placed in a can is 920 ml with a standard deviation of 12 ml. Assuming a normal distribution, what is the probability that the filling machine will cause an overflow of a can, that is, the probability that more than 950 ml will be placed in the can?























































































































































































































































































































































































































































































































































































































































































































































Kiwi Oil
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 D12 and the standard deviation in shaded cell D13. below. 
Enter the desired X-value in shaded cell D14, below. The calculated z-value and probability will be seen in D15 and D16. 
Mean of distribution920
Std deviation of distribution12
Desired x-value950
Calculated z-value2.50
Probability of x, or less0.99379
(X-axis)Probability Using
Desired x-valuesEquivalent - Z ValuesNORMS.DIST
880-3.330.00043
881-3.250.00058
882-3.170.00077
883-3.080.00102
884-3.000.00135
885-2.920.00177
886-2.830.00230
887-2.750.00298
888-2.670.00383
889-2.580.00489
890-2.500.00621
891-2.420.00783
892-2.330.00982
893-2.250.01222
894-2.170.01513
895-2.080.01861
896-2.000.02275
897-1.920.02764
898-1.830.03338
899-1.750.04006
900-1.670.04779
901-1.580.05667
902-1.500.06681
903-1.420.07829
904-1.330.09121
905-1.250.10565
906-1.170.12167
907-1.080.13933
908-1.000.15866
909-0.920.17966
910-0.830.20233
911-0.750.22663
912-0.670.25249
913-0.580.27983
914-0.500.30854
915-0.420.33846
916-0.330.36944
917-0.250.40129
918-0.170.43382
919-0.080.46679
9200.000.50000
9210.080.53321
9220.170.56618
9230.250.59871
9240.330.63056
9250.420.66154
9260.500.69146
9270.580.72017
9280.670.74751
9290.750.77337
9300.830.79767
9310.920.82034
9321.000.84134
9331.080.86067
9341.170.87833
9351.250.89435
9361.330.90879
9371.420.92171
938 Transcribed Image Text:

Cumulative Probability Cumulative Probability Function 1.00 0.90 0.80 0.70 0.60 0.50 040 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.8 4.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: