Question: Solve using Excel ( please show each step and show all operation used in excel ) -Thank you 3-28. Martha's Wonderful Cookie Company makes a

Solve using Excel ( please show each step and show all operation used in excel ) -Thank you

Solve using Excel ( please show each step and

3-28. Martha's Wonderful Cookie Company makes a special super chocolate-chip peanut butter cookie. The company would like the cookies to average approximately eight chocolate chips apiece. Too few or too many chips distort the desired cookie taste. Twenty samples of five cookies each during a week have been taken and the chocolate chips counted. The sample observations are as follows: LA 5 5 8 8 8 6 9 10 8 8 4 8 9 Samples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 7 7 5 4 8 7 9 7 9 11 5 6 7 6 10 5 6 11 9 8 6 7 5 5 8 6 8 6 10 9 5 8 3 9 8 6 10 4 5 8 Chips per Cookie 9 8 7 9 5 9 10 5 8 9 9 8 7 9 7 9 10 6 5 6 9 10 8 5 10 8 7 8 4 8 5 7 6 8 9 8 8 6 7 3 8 7 3 3 5 8 8 8 9 4 5 8 7 8 7 7 Construct an X-chart in conjunction with an R-chart using 3o limits for this data and comment on the cookie- production process

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 General Management Questions!