Question

The production manager at Sunny Soda, Inc. is interested in tracking the quality of the company’s...

The production manager at Sunny Soda, Inc. is interested in tracking the quality of the company’s 12-ounce bottle filling line. The bottles must be filled within the tolerances set for this product because the dietary information on the label shows 12 ounces as the serving size. The design standard for the product calls for a fill level of 12.00 ± 0.10 ounces (11.90 to 12.10 ounces). The manager collected the following sample data (in fluid ounces per bottle) on the production process:

12.00

11.97

12.10

12.08

11.91

11.94

12.10

11.96

11.89

12.02

11.97

11.99

12.10

12.09

12.05

11.95

12.08

11.92

12.12

12.05

11.94

11.98

12.06

12.08

12.09

12.00

12.00

12.03

12.01

12.04

11.99

11.95

12.00

11.96

11.97

12.03

11.92

11.94

12.09

12.00

11.91

11.99

12.05

12.10

12.01

12.00

12.06

11.97

11.98

11.99

12.06

12.03

12.02

12.00

12.05

11.95

12.00

12.05

12.01

11.97

  1. Draw a histogram for the process using the Data Analysis Tool Pak in Excel. Copy and paste in the space below. Tip: Use bins in the interval of 0.02. For example, use 11.88 for the first bin, 11.90 for the second bin, 11.92 for the third bin and so on until 12.12
  1. Based on the histogram, do you think the process is meeting the specification for the weight of the soda (12.00 ± 0.10 ounces? Give reason for your answer.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a.

We will use Excel and input all 60 samples in the first column A as shown below.

Bin is added from cell C3 to C15 starting 11.88 till 12.12.

& Share File Home Insert Page Layout Formulas Data 2 2 Show Oueries Connections A From Table LE Get External New Data Q uery

Click on Data -> Data Analysis and select Histogram.

Review Share A ZA ASSE File Home Insert Page Layout Formulas Data 2 Show Oueries Connections From Table Properties Get Extern

We select input range and bin as shown to create the histogram.

ASS Book 1 - Excel Tell me what you want to do.. View Share Clear Flash Fill M Remove Duplicates Text to Data Validation Adva

Review View & Share ASSE File Home Insert Page Layout Formulas Data 2 2 Show Oueries Connections A From Table LE Get External

b.

Looking at output of histogram, we can see in the table with Bin and Frequency and assess whether the process is meeting the specification or not.

The specification limit of 12.00 +/- 0.10 shows that lower specification are 12.00 - 0.10 = 11.90 and higher specification are 12.00 + 0.10 = 12.10.

We can see that there is one value in bin 11.90 i.e. one value between 11.88 to 11.90. Also there are 4 values between 12.10 to 12.12 and 1 value between 12.12 and above.

So, there are multiple values outside the lower and higher specification limit hence the process is not meeting the specification.

If you like my answer , please give thumbs up. Thank you.

Add a comment
Know the answer?
Add Answer to:
The production manager at Sunny Soda, Inc. is interested in tracking the quality of the company’s...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 3. The production manager at Sunny Soda, Inc, is interested in tracking the quality of the...

    3. The production manager at Sunny Soda, Inc, is interested in tracking the quality of the y's 12 -ounces bottle filling line. The bottles must be filled within the tolerances set compan for the dietary information on the label shows 12 ounces as the serving size. The design standard for the product calls for a fill level of 12.00+ 0.10 ounces. The manage collected the following sample data (in fluid ounces per bottle) on the production process: A2 0.729, D,-0.0,...

  • please answer number 24 part A and for part B answer it in equation form, not...

    please answer number 24 part A and for part B answer it in equation form, not graph. thank you. Process Capability Sample 24. The production manager at Sunny Soda, Inc. is inter- ested in tracking the quality of the company's 12-ounce bottle filling line. The bottles must be filled within the tolerances set for this product because the dietary information on the label shows 12 ounces as the serving size. The design standard for the product calls for a fill...

  • . The production manager at Sunny Soda, Inc., is interested in tracking the quality of the company's 12-ounce bottl...

    . The production manager at Sunny Soda, Inc., is interested in tracking the quality of the company's 12-ounce bottle filling line. The bottles must be filled within the tolerances set for this product because the dietary information on th label shows 12 ounces as the serving size. The design standard for the product calls for a fill level of 12 0.10 ounces. The manager collected the accompanying sample data n fluid ounces per bottle) on the production process. 1 Click...

  • Quality Associates, Inc., a consulting firm, advises its clients about sampling and statistical procedures that can...

    Quality Associates, Inc., a consulting firm, advises its clients about sampling and statistical procedures that can be used to control their manufacturing processes. In one particular application, a client gave Quality Associates a sample of 800 observations taken during a time in which that client’s process was operating satisfactorily. The sample standard deviation for these data was .21; hence, with so much data, the population standard deviation was assumed to be .21. Quality Associates then suggested that random samples of...

  • Case Problem 1: Quality Associates, Inc.

    Quality Associates, Inc., a consulting firm, advises its clients about sampling and statistical procedures that can be used to control their manufacturingprocesses. IN one particular application, a client game quality associates a sample of 800 observations taken during a time in which that client's process wasoperating satisfactorily. The sample standard deviation for there data was .21 ; hence, with so much data, the population standard deviation was assumed to be .21.Quality associates then suggested that random samples of size 30...

  • Given that the customer requirements for the process is (11.9, 12.1), using X bar and R chart, find Cp, Cpk and DPMO for the following samples (there are 16 samples). Assume the process is normally di...

    Given that the customer requirements for the process is (11.9, 12.1), using X bar and R chart, find Cp, Cpk and DPMO for the following samples (there are 16 samples). Assume the process is normally distributed. Given that the customer requirements for the processis (11.9, 12.1), using X bar and R chart, find Cp, Cpk and DPMO for the following samples (there are 16 samples). Assume the process is ormally distributed. 1 Subgroup 111.945 2 12.03 3 12.01 4 11.97...

  • Sample 1|Sample 2 Sample 3 Sample 4 11.91 11.55 11.62 11.62 11.69 11.52 11.59 11.75 11.82 1.90 11...

    Sample 1|Sample 2 Sample 3 Sample 4 11.91 11.55 11.62 11.62 11.69 11.52 11.59 11.75 11.82 1.90 11.97 11.64 11.80 11.87 12.03 11.94 12.01 11.92 11.99 12.13 12.09 12.16 11.93 12.21 12.32 12.39 11.93 11.85 11.92 11.7611.83 11.7012.38 11.77 11 12.00 12.07 12.04 11.98 12.05 12.30 12.37 12.18 12.25 11.97 12.17 12.24 11.85 11.92 12.30 12.37 12.15 12.22 12.02 11.36 12.02 11.75 12.05 11.95 12.18 12.14 11.72 12.07 12.05 11.85 11.64 12.16 12.39 11.65 12.11 11.90 12.22 11.56 11.88 11.95...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT