Use the normdist function of Excel to calculate the probability that a water sample has a concentration of cadmium greater than 100 mg L-1, given the mean and standard deviation.
Added by Katherine L.
Step 1
To calculate the probability that a water sample has a concentration of cadmium greater than 100 mg L-1 using the NORMDIST function in Excel, follow these steps: ** Show more…
Show all steps
Close
Your feedback will help us improve your experience
Ivan Kochetkov and 56 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Ivan K.
Government regulations dictate that for any production process involving a certain toxic chemical, the water in the output of the process must not exceed 7770 parts per million (ppm) of the chemical. For a particular process of concern, the water sample was collected by a manufacturer 16 times randomly and the sample average X was 7842 ppm. It is known from historical data that the standard deviation σ is 120 ppm. Complete parts (a) and (b) below: (a) What is the probability that the sample average in this experiment would exceed the government limit if the population mean is equal to the limit? Use the Central Limit Theorem. The probability is (Round to four decimal places as needed:)
Ahmet Y.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD