The standard deviation of the weight of filled salt containers is 0.4 ounce. If 2.5 percent of

Question:

The standard deviation of the weight of filled salt containers is 0.4 ounce. If 2.5 percent of the containers contain less than 16 ounces, what is the mean filling weight of the containers?
















































































































































































































































































































































































































































































































































































































































































































































































































Salt Containers
X-value Calculations Given Probabilities Using the Inverse Normal Distribution - Template
This spreadsheet is designed to calculate the X-value based on probability of values equal to, or less than a desired x value, 
of a normally distributed variable. It requires input of a known mean and standard deviation and uses the inverse of the cumulative normal distribution
Enter the mean of the distribution in cell D10 and the standard deviation in cell D11, below. 
Enter the desired probability in cell D12, and the calculated x-value will be seen in D13.
Mean of distribution16.784
Std Dev of distribution0.4
Probability of X or less0.025
Calculated X-Value16.00
Calculated x-valuesProbability
15.1840.00003
15.2240.00005
15.2640.00007
15.3040.00011
15.3440.00016
15.3840.00023
15.4240.00034
15.4640.00048
15.5040.00069
15.5440.00097
15.5840.00135
15.6240.00187
15.6640.00256
15.7040.00347
15.7440.00466Truncated
15.7840.00621x-valuesProbability
15.8240.0082015.1840.00003
15.8640.0107215.5840.00135
15.9040.0139015.9840.02275
15.9440.0178616.3840.15866
15.9840.0227516.7840.50000
16.0240.0287217.1840.84134
16.0640.0359317.1840.84134
16.1040.0445717.9840.99865
16.1440.0548018.3840.99997
16.1840.06681
16.2240.08076
16.2640.09680
16.3040.11507
16.3440.13567
16.3840.15866
16.4240.18406
16.4640.21186
16.5040.24196
16.5440.27425
16.5840.30854
16.6240.34458
16.6640.38209
16.7040.42074
16.7440.46017
16.7840.50000
16.8240.53983
16.8640.57926
16.9040.61791
16.9440.65542
16.984 Transcribed Image Text:

Probability 1.000 0.900 0.800 0.700 0.600 0.500 0.400 0.300 0.200 0.100 0.000 15 15.5 X-values vs. Cumulative Probability 16 16.5 17 X-values 17.5 18 18.5 19 -Series1

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

Step by Step Answer:

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