hexagon logo

Identify Variation

Good Morning,

I don't have a lot of experience is statistics. Can someone guide me on how to identify variation in my measured data? I need to know how much variation is present so engineering can adjust tolerances accordingly and also to make sure the CMM is trustworthy.

I placed a part in a fixture and ran my measurement routine. I did a do/unitl which gave me 6 reports and 6 rows in excel for each part serial number. Data was written directly into excel. Part remained in the fixture for the duration of the inspection.

Here is 1 part with its 6 runs.
































































Serial Run # ID OD TP X Axis Z axis
1 0 3.0768 2.679 0.005 -0.0024 0.0006
1 1 3.0769 2.679 0.0051 -0.0025 0.0005
1 2 3.0768 2.6789 0.0051 -0.0025 0.0006
1 3 3.0769 2.6789 0.005 -0.0024 0.0006
1 4 3.0768 2.6789 0.005 -0.0024 0.0006
1 5 3.0771 2.6789 0.0051 -0.0025 0.0007

Parents
  • max(group of cells)-min(group of cells) in Excel
    Or, just take the highest reading minus the lowest reading, that is the variation (aka RANGE). I see "machine" variation, max of 0.0003 for ID, max of 0.0002 for all the others. If that is MM, then it is nothing, but 0.0002" is expected machine variation for 99.9999% of the CMM's out there.
Reply
  • max(group of cells)-min(group of cells) in Excel
    Or, just take the highest reading minus the lowest reading, that is the variation (aka RANGE). I see "machine" variation, max of 0.0003 for ID, max of 0.0002 for all the others. If that is MM, then it is nothing, but 0.0002" is expected machine variation for 99.9999% of the CMM's out there.
Children
No Data