Question

Could you please provide assistance with this question - I need to be able to use...

Could you please provide assistance with this question - I need to be able to use this in excel

The Langley tire company measures their tire strength on a scale from 1 to 10 They do this by randomly selecting three tires for each test period and destroy (ultimately determining their strength). Below is the results of this day's tests.

Hour A B C
4 8 6 7
8 6 8 8
12 7 8 7
16 6 8 7

a.

Find the 3 sigma UCL and LCL for the mean and range charts.

b.

Is this process in statistical control? Why or why not?

Homework Answers

Answer #1

Given data

Hour A B C
4 8 6 7
8 6 8 8
12 7 8 7
16 6 8 7

Total no of sample (n)=12

mean of the sample

varience

Stadard deviation

now from the formula of we have

b)This process is a statistally controlled process because

A statistacally controlled process is a process in which the data we get in obserrvation will not exeed the UCL and lowers the LCL .data flows smoothly without showing any abnormal growth.

in this case we have UCL=8.90 and LCL=4.77

as we can see in all observation no data exceded the limit that means the process is a statistacally controlled process

Know the answer?
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
Similar Questions
The Johnson tire company measures their tire stems for cracks. They produce 300 tires a month...
The Johnson tire company measures their tire stems for cracks. They produce 300 tires a month and record the defective rate for each day's production. Below are the results of this month's tests. Day Fraction Defective 1 0.01 2 0.08 3 0.11 4 0.03 5 0.09 6 0 7 0.07 8 0.02 9 0.05 10 0.02 11 0.04 12 0 13 0.08 14 0.06 15 0 16 0.09 17 0.02 18 0.11 19 0.01 20 0.04 21 0.09 22 0.1...
BridgeRock is a major manufacturer of tires in the U.S.. The company had five manufacturing facilities...
BridgeRock is a major manufacturer of tires in the U.S.. The company had five manufacturing facilities where tires were made and another 20 facilities for various components and materials used in tires. Each manufacturing facility produced 10,000 tires every hour. Quality had always been emphasized at BridgeRock, but lately quality was a bigger issue because of recent fatal accidents involving tires made by other manufacturers due to tread separation. All tire manufacturers were under pressure to ensure problems did not...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT