Question: please show the excel formula how to get the answer. or if use of goal seek also show how. thanks The amount of a soft
please show the excel formula how to get the answer. or if use of goal seek also show how. thanks
The amount of a soft drink that goes into a typical 12- ounce can varies from can to can. It is normally distributed with an adjustable mean ? and a fixed standard deviation of 0.05 ounce. (The adjustment is made to the filing machine)
a. (7 pts) If regulations require that cans have at least 11.9 ounces, what is the smallest mean ? that can be used so that at least 99.5% of all cans meet the regulation?
b. (3 pts) If the mean setting from part a is used, what is the probability that a typical can has at least 12 ounces?


Notes: There are two ways to show your formulas in Excel: 1. Copy and paste the entire work on a new worksheet, and click 'Show Formula' under 'Formulas' tab (or CTRL+') Formulas Data Review View Help Acrobat StatTools Share Lookup & Reference Define Name E Trace Precedents Math & Trig Name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
