I have a dilemma regarding the best way to verify the reliability of a calibration checking method on a Hofmann Balance Tester.
For those who dont know, the instrument is used to verify if a shaft or armature is balanced by placing it on rollers and spinning it at several thousand rpm, then recording how far out of balance it is, in the same way as car wheels are balanced.
In order to verify if the instrument is reading correctly, a calibrated shaft is used.
This shaft can have different known weights inserted at either end of the shaft and the readings can then be recorded.
Ideally, by using different weights,a straight line graph should be seen when plotting weight against reading.

HOWEVER, due to the inconvenient law of physics, unless the dimensions of each weight is identical, the readings will vary. (distance of the weight from the axis of spin.), Unfortunatly the shaft has been designed to use different length screws as the weight. Therefore i need to verify the reliability of the weights/readings.

Tests have already been carried out using 6 weights between 0.01g and 1.0g.
Each weight was used 10 times, giving a total of 60 readings:

The allowed tolerance for each weight is +/-10%.

I have recently been introduced to Minitab, and see that is capable of G R&R, but i caanot figure it out. I admit G R&R is a very weak area for me.

I am however quite knowledgable on excel.

Am i trying to use the wrong method or am i just not getting minitab?
Does anyone know how a can validate this calibration check method (preferably with excel)?

Please attach your data set and we can better help you. There may be several ways to evaluate this, but I need to see the data. Did you use multiple operators to load/unload the balancers?

I have worked with Hoffman balancers myself, so I am familiar with them.