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?

please show the excel formula how to get the answer. or ifuse of goal seek also show how. thanks The amount of a

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!