Home / Statistical Tools / MSA / MSA Extended Options
MSA Extended Options¶
From Excel click...
QXL Stat Tools Tab > MSA (Gage R&R) > ANOVA Extended Options
The extended options provide additional control over how the calculations are performed. For information about the non-extended options see this help file:
Options for calculating standard deviation¶
-
Calculate: The standard deviation will be calculated as normal.
-
Use Historical Value: If a process is in statistical control, you may substitute the calculated part-to-part standard deviation with the historical value. SigmaMeasure is calculated per typical calculations and then SigmaTotal is calculated as the square root of the squared sums of both SigmaPart (user supplied) and SigmaMeasure(calculated). This technique is in practice very useful when the parts selected for the MSA are not necessarily representative of the historical value. For more information, see AIAG Rev 4, Chapter III Section B Page 121.
-
Representative SigmaPart Not Possible: Many MSAs are performed where a representative SigmaPart isn’t possible. For example, a caliper used in the R&D process may be used to measure many different parts, none of which are from a manufacturing line. When this is the case, this option will eliminate SigmaPart and all ratios based on SigmaPart to prevent you from interpreting ratios that aren’t applicable