Doubt on "MSA 3rd Linearity Example.xls" formula

A

Alexandre Bonatto

#1
Dear fellows,

I am trying to make all linearity calculations and I am using the "MSA 3rd Linearity Example.xls" as my guide.

Could anyone that already did the same help with the following doubt in the confidence level limits formula?

The formula has (inside a square root) a ratio:

(x0-xbar)^2 / sum[(xi-xbar)^2]

but in the excel file it is used the following ratio:

(x0-xbar)^2 / {sum[(xi-xbar)^2]*m}

where the quantity "{sum[(xi-xbar)^2]*m}" is called "sumsq-all" (at C32 cell)

What is the reason of this difference? From where comes the "*m"? Is MSA formula wrong (again!)?

Thanks in advance!

Alexandre Bonatto
 
Elsmar Forum Sponsor
Thread starter Similar threads Forum Replies Date
P Doubt about MSA for Attributes Gaging - Reference Value Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
M Attribute Gage MSA - What is the width of the gray area of ​​doubt? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
V MSA (Measurement System Analysis) Doubt on Analytic Method (Attribute Study) IATF 16949 - Automotive Quality Systems Standard 8
K Doubt on insulation class of a device IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
T ISO 14971-2019 doubt - Evaluate if estimated risks are acceptable ISO 14971 - Medical Device Risk Management 9
A Doubt on multiple inspection carrying out for same balloon number during Stage Inspection and Final Inspection? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
M Doubt about Customer Changes to Product Design Features AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
N Doubt on Bias study for EOLT (End Of Line Tester) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
K Standard Deviation - Doubt and Clarification of my Understanding Statistical Analysis Tools, Techniques and SPC 28
S Is TS16949 a standard by itself? A basic doubt IATF 16949 - Automotive Quality Systems Standard 5
V Mandatory to send to the Customers FMEA in a PPAP level 3 - Doubt IATF 16949 - Automotive Quality Systems Standard 36
Z Doubt about the Location of Car GPS Navigators Funny Stuff - Jokes and Humour 13
S Doubt on Thread Measurement - Measuring Fluted (Odd) Taps for its pitch diameter Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
Marc Future of APQP and PPAP in Doubt? 2005 Update APQP and PPAP 26
M Doubt about the element 15.3 (VDA) - Periodic cross-check and repeated inspections VDA Standards - Germany's Automotive Standards 3
Nihls When the MSA results show no operator influence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S MSA for attribute relation gage Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Nihls MSA Study Type 1 (CMM) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
M MSA Study Type 1 not capable. We are at the limit. And manufacturing wants to continue producing. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
I Overwhelmed with attribute MSA requirement for visual inspection IATF 16949 - Automotive Quality Systems Standard 8
H Need MSA 4th ed. compliant attribute MSA template General Measurement Device and Calibration Topics 4
P MSA for titration Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
P MSA - what exactly mean "system" and master sample Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
P MSA study for visual system with artifical inteligence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
D MSA strategy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
K Updated MSA with the Annual PPAP validations APQP and PPAP 8
E MSA for Push and Pull test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
6 MSA for Calculated Clearance Dimension Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Ron Rompen MSA on automated measurement system - Multiple Step Vision System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
G MSA check list to audit IATF 16949 - Automotive Quality Systems Standard 10
R MSA for ATE (Automatic Test Equipment Embedded Software) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
Bev D MSA Tools Misc. Quality Assurance and Business Systems Related Topics 3
R MSA studies for Heat Treatment Equipment Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C Industrial scales and MSA (IATF 16949 requirement 7.1.5.1.1) IATF 16949 - Automotive Quality Systems Standard 30
M Difference between MSA and MSE? General Measurement Device and Calibration Topics 1
M Test method validation - Is MSA (MSA1, MSA2, MSA3 and linearity) a good solution? Medical Device and FDA Regulations and Standards News 1
A MSA results differences - Supplier results vs. My results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
R Preliminary MSA and Sockets' correlation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
I MSA requirement for 5 Micrometers + CP changes need customer approval? IATF 16949 - Automotive Quality Systems Standard 2
T Correct MSA study for an automated camera system which makes attribute inspection Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Bev D MSA Misc. Quality Assurance and Business Systems Related Topics 46
Emran.mi Measurement system analysis - Can you help me about implementation MSA for CMM device Manufacturing and Related Processes 2
N MSA Study for a Leak Testing Device Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
N Justifications for not performing MSA (Measurement System Analysis) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
D Do I need part variation while doing Destructive Variable Gage R&R MSA study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
Prashant G MSA Study - AS 9100 and and our customer want us to do MSA study for their parts dimension Reliability Analysis - Predictions, Testing and Standards 4
D Compression Spring Force MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
E MSA Study on MTS dynamic rate measurements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
A The FILE recommended by AIAG MSA 4ed for LINEARITY Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
S IATF 16949 Audit MSA IATF 16949 - Automotive Quality Systems Standard 10

Similar threads

Top Bottom