Question: The following sample information was obtained by taking four doughnuts per hour for 12 hours from Fawcett Bakerys doughnut process and weighing them: HOUR WEIGHT(GRAMS)

The following sample information was obtained by taking four doughnuts per hour for 12 hours from Fawcett Bakerys doughnut process and weighing them:

HOUR	WEIGHT(GRAMS)	HOUR	WEIGHT(GRAMS)
1		75,102,103,109	7	93,80,106,91
2		95,110,92,93	8	90,86,109,106
3		85,84,79,92	9	108,100,108,88
4		107,90,109,100	10	96,108,109,110
5		89,88,89,77	11	104,98,105,109
6		75,95,106,85	12	102,108,88,96

Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

Questions

Find the and R for each sample. Round your answers to two decimal places.
Find the and for the 12 samples. Do not round intermediate calculations. Round your answers to two decimal places.

Overall Mean: fill in the blank 26

Average Range: fill in the blank 27

Find the 3-sigma UCL and LCL for the mean and range charts. Do not round intermediate calculations. If your answer is zero, enter "0". Round your answers to two decimal places.

UCL: fill in the blank 28

LCL: fill in the blank 29

UCL_R: fill in the blank 30

LCL_R: fill in the blank 31

The following sample information was obtained by taking four doughnuts per hour

for 12 hours from Fawcett Bakerys doughnut process and weighing them: HOUR

WEIGHT(GRAMS) HOUR WEIGHT(GRAMS) 1 75,102,103,109 7 93,80,106,91 2 95,110,92,93 8 90,86,109,106 3

85,84,79,92 9 108,100,108,88 4 107,90,109,100 10 96,108,109,110 5 89,88,89,77 11 104,98,105,109 6

Excel Online Structured Activity: Statistical Control - Fawcet Bakery The following sample information was obtained by taking four doughnuts per hour for 12 hours from Fawcett Bakery's doughnut process and weighing them: a. Find the x and R for each sample. Round your answers to two decimal places. R for the 12 samples. Do not round intermediate calculations. Round your answers to two decimal places. Overall Mean: Average Range: c. Find the 3-sigma UCL and LCL for the mean and range charts. Do not round intermediate calculations. If your answer is zero, enter "0". Round your answers to two decimal places. UCLx : LCLx : UULR : LCLR

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!

1. Consider the following statement: Economists always put things into monetary terms; as a result, economics can most appropriately be called the study of money. Is this true or false? Briefly...

6. The following sample information was obtained by taking four doughnuts per hour for 12 hours from the Fawcett Bakery's doughnut process and weighing them: Hour Weights (grams) Hour Weight (grams)...

Show all work. You may create an excel spreadsheet but it is not necessary for this homework. If your answer is wrong an there is no work you will not get partial credit. Ulricks Automotive Parts...

6. The following sample information was obtained by taking four doughnuts per hour for 12 hours from the Carter's Bakery's doughnut process and weighing them: Chapter 8 pp 309-311 Hour Weights...

The following sample information was obtained by taking four doughnuts per hour for twelve hours from Fawcett Bakerys doughnut process and weighing them: For the data shown above a. Find the x and R...

The following sample information was obtained by taking four doughnuts per hour for twelve hours from Fawcett Bakerys doughnut process and weighing them: Hour grms grms grms grms 1 110 105 98 100 2...

please answer this question and not just repost another one with different numbers!! Thank you! Excel Online Structured Activity: Statistical Control Fawcet Bakery The following sample information...

The following sample information was obtained by taking four doughnuts per hour for twelve hours from Fawcett Bakerys doughnut process and weighing them: HOUR WEIGHT(GRAMS) HOUR WEIGHT(GRAMS) 1...

Week 3 Assignment -- PART ONE You are the company's Supply Chain Manager -- solve the below questions to ensure an optimal ordering policy. Annual requirements (R) = Order cost (S) = Holding rate (k)...

Week 3 Assignment -- PART ONE You are the company's Supply Chain Manager -- solve the questions below to ensure an optimal ordering policy. Annual requirements (R) = Order cost (S) = Holding rate (k)...

1,2 Use the following seven samples, taken on seven consecutive days at Nik and Aubrey's Deli, to answer the next two prob- lems. Five random customer wait times were measured each day. MS Day 1 2 3...

The external environment factor that includes: Factors that have a less immediate effect on a business such as the nations rate of inflation or recession, unemployment rate, or standard of living, is...

Solue the semilinear fallawng BUP (Boundry value Proble Tat 20)Ux t yuy 2 xe

he section in the statement of cash flows for reporting the purchase of equipment for cash is: Mumple Choice Investing activities. This is not reported on the statement of cash flows. Operating...

3. True/False: The DV routing algorithm ALWAYS converges to the final link costs VERY quickly. 4. True/False: Two autonomous systems can run completely different intra-AS routing protocols if...

Most countries effectively impose an infinite tax on organ sales.

In the presence of externalities, private and social welfare diverge.

Every antibiotic taken causes a net social loss by contributing to antibiotic resistance.