Fundamentals of Statistics

profileZatan_07
Week5HW4.docx
Home>Mathematics homework help>Statistics homework help>Fundamentals of Statistics

HW#4: Fundamentals of Statistics

1.Given the data below for readings by 3 appraisers on 6 parts with 2 trials, determine if the measurement system is acceptable (how much variation is attributed to part, Gage R&R, equipment, and operator, respectively) and where should improvement efforts should be focused on. The readings were randomized. Use Excel calculation to finish this question.

1

2

3

4

5

6

Appraiser A

Trial 1

.65

1.00

.85

.85

.55

1.00

Trial 2

.60

1.00

.80

.95

.45

1.00

Appraiser B

Trial 1

.55

1.05

.80

.80

.40

1.00

Trial 2

.55

.95

.75

.75

.40

1.05

Appraiser C

Trial 1

.50

1.05

.80

0.80

.45

1.00

Trial 2

.55

1.00

.80

0.80

.50

1.05

2.Given the data below for readings by 2 appraisers on 4 parts with 3 trail trials, determine if the measurement system is acceptable (how much variation is attributed to part, Gage R&R, equipment, and operator, respectively) and where should improvement efforts should be focused on. The readings were randomized. Use Excel calculation to finish this question

1

2

3

4

Appraiser A

Trial 1

.55

.45

.60

.20

Trial 2

.55

.40

.60

.30

Trail 3

.50

.35

.55

.25

Appraiser B

Trial 1

.55

.35

.60

.15

Trial 2

.50

.30

.55

.20

Trial 3

.45

.25

.50

.15

Special Notes:

The best approach to accomplish this homework is to manually compute GageR&R in first question and to use Microsoft Excel in the second question. You may use Excel in both questions, but be sure you understand the process.