I'm working on a statistics question and need guidance to help me learn.

Minitab Application:

We are going to perform a gauge R&R on any measuring device. I am going to suggest the assignment below. If you do not have a digital scale, you can find any measuring device (find a ruler, measuring tape etc and construct and experiment).

Note: If you want to use another experiment at your job or another device, it will also be fine (but you need to send the experiment to me for approval by Thursday (6/3).

Material needed:

1.5 or 10 bottles of water

2.Digital measuring scale

3.Marker

4.People (about 2-3 operators excluding yourself)

5.Slide from Week 4 on how to conduct an MSA

Instructions:

1.Get 10 bottles of the water (they have to be same size) – 10 small bottle or 10 larger bottles

2.Using a marker numbers the bottles (1, 2, ….10) so that only you will know the number for each bottle (You could put it a tape over the number so the operators do not know which bottle that they are measuring.

3.Select at least 3 operators for the study. Open a Minitab worksheet and enter the following information:

a.Bottle number (at random order)

b.Operator name (at random order) … so the same operator is not measuring all the parts at the same time

c.Weight

Experiment:If you use at least 10 parts and at least 3 operators, having each operator measure each part at least 2 times, in random order (not that the same time).

1.Have each operator measure each part twice using the following instructions:

a.Take out a few drops of water from some of the bottles, so they LOOK the same but they are not really the same on a digital scale.

b.Number each bottle so only you know which bottle is related to the random number on the spreadsheet in Minitab.

c.Arrange the bottles in a random order (you need to know the number on the bottle to enter the result in the correct place on the spreadsheet)

d.Have Operator 1 weigh each bottle and give you the weight of the bottle. Enter this information into your spreadsheet. (it is better to bring in Operator 2 next but if you only have operator 1 then do the following)

e.Again, Arrange the bottles in a random order and have Operator 1 weigh each bottle and give you the weight of the bottle. Enter this information into your spreadsheet.

f.Arrange the bottles in a random order and have Operator 2 weigh each bottle and give you the weight of the bottle. Enter this information into your spreadsheet.

g.Again, Arrange the bottles in a random order and have Operator 2 weigh each bottle and give you the weight of the bottle. Enter this information into your spreadsheet.

4. Use Minitab to calculate %R&R.Conduct a MSA analysis and comment on the results

a.What are the major sources of measurement error?

b.How much measurement error exists in comparison to the process variation? In comparison to the customer requirements?

c.Is the measurement system acceptable for the process improvement efforts?

d.If not, what actions do you suggest?

e.How were the samples chosen?

f.Was the team sensitive to sub-grouping for sample selection?

Addition to that question: solve this one using word And excel. 2 separate files with same answers but different programs.

Thank you