Linearity Analysis - AIAG's MSA Manual 3rd Edition - Question

D

datony

#1
in MSA edition 3,there are some equations for linearity analysis. like "s2=(∑yi2 – b ∑yi – a∑xiyi)/(gm-2)" in page 93, i am confused about how to use these eqations.for example, in the manual,it points out that "xi" is the refence value, does it mean "xi" is "2,4,6,8,10" as given in the example in page 94? as to "yi", does "yi" is the "bias average", like "0.491667,0.125, 0.025,-0.29167, -0.61667"? if "xi" and "yi" present the numbles as i thought,then we can't calculate out the value "ta","tb" as given in page 96. the equations is really confusing, i wonder if anyone can help me to make them clearer.
thank you very much!
 
Last edited by a moderator:
Elsmar Forum Sponsor

Darius

Quite Involved in Discussions
#2
Re: Question on linearity analysis (msa 3 edition)

I don't know about MSA edition 3, but test for lineality in MSA is just test for a relationship between several "reference master" and the measure system.
ie.
Sample - Master - Measurement_Average
1 - 5.0 - 5.03
2 - 5.2 - 5.23
3 - 5.4 - 5.43
4 - 5.6 - 5.63
5 - 5.8 - 5.82
6 - 6.0 - 5.98

Calculate y(i)=A*x(i) + B

in this example y= -0.043*x +0.2553

A=> the slope, is taken as a percentage of lineality (the absolute value), it must be less than 10% to be OK.

Lineality = abs(A)*(process variation or tolerance)

:bigwave:
 
B

bowman

#3
datony,
are you still interested in formula solving of linearity in msa 3rd edition ?

I have an excel worksheet with the complete solution and, of course, the demonstration about the incorrect formulas at page 96, given by an msa author :D

Massimo
 
B

bowman

#5
oh yes, tomorrow I will reply with the spreadsheet (including the e-mail from msa author, it is intresting)

maybe in the next months I will put on the net a free release of my gage managemant software (it works on Oracle DB).
At the moment is in italian but it is not difficult to translate it.

it is a pleasure to join the cove
Massimo
 
B

bowman

#6
Here is the spreadsheet given me from an MSA guy.

here is the content of his letter:
------------------------------------------------------------
Dear Massimo
The questions you are asking with respect to the calculation of the parameters
and analysis of a straight line can be answered by reading a standard statistics
book or a book dealing with linear regression. The linearity analysis uses a
standard calculation of the slope, intercept, and confidence bounds of a linear
regression. The MSA manual is not intended to provide instruction in basic
statistics -- it assumes that the reader will have this basic knowledge.

I do not mean to put off your questions, but we set up the web feedback/question
capability to answer MSA queries not instruct others in statistics and/or debug
their scripting/programming. We are all volunteers; i.e. we do not get paid for
this service. I recommend that you contact a local competent statistician or
take a basic statistics course.

With that said, I have attached is an excel file with the details of the
calculations for the example in the MSA 3rd Manual. It should provide you with
further direction.

Greg
------------------------------------------------------------

And here is my answer:
------------------------------------------------------------
thanks for your effort and your patience.
It ia a pitty you cannot find my first e-mail where I explained what I needed in more detail.

My doubts were from "s" calculation and |ta| results, because all my previous results (a,b etc.) are ok.
amd my problem was the lack of documentation about the intermediate results, and at the end of page 93, in |ta| formula, maybe correcting xj with x0 will be useful for me and could give less confusion: for example I shouldn't write you.
At page 94, |tb| has the same problem: xj becames xi but it is still x0. Please note at page 92 xi is equal to "reference value" and not x0 . please correct formula at page 94 or be more clear.
I'm sure I don't need a statistic course, believe me.
Despite of all, thank you for the clarification (now all of my doubts are clear) and thanks from the automotive community for your volunteer activity.
------------------------------------------------------------

so, please put the attached document into the download directory, thanks.
Massimo
 

Attachments

B

bowman

#9
it's ok,
you can image the days and hours I spent on msa with wrong formulas...

in the next months I will publish my gage software (for free, yes) that use also msa 3rd edition tests, maybe I will need help from all the Cove for a correct english translation, especially about technical terms.

Massimo
 
S

sammer

#10
A very handy excel file indeed!!

Thank you very much Massimo....

sammer

I'll try and return the favour sometime soon.
 
Thread starter Similar threads Forum Replies Date
D Linearity Analysis - Measurement System Analysis - AIAG MSA Manual 3rd Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 14
A Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
I Interpretation of MSA (Measurement Systems Analysis) Linearity and Bias Study Results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
L Gage Linearity and Bias Study Analysis - Minitab help needed Using Minitab Software 4
Rameshwar25 Linearity Problem (MSA - Measurement System Analysis) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Miner Intro to Measurement System Analysis (MSA) of Continuous Data – Part 3: Linearity Imported Legacy Blogs 15
S Stability, Bias and Linearity samples - Measurement Systems Analysis Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
F Linearity Analysis - MSA 3rd edition, March 2002 page 93 formulas Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
L Measurement System Analysis (MSA) - Bias, Linearity and Stability Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 23
M Test method validation - Is MSA (MSA1, MSA2, MSA3 and linearity) a good solution? Medical Device and FDA Regulations and Standards News 1
A The FILE recommended by AIAG MSA 4ed for LINEARITY Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
W Using MPE (Mean Percentage Error) for Linearity and Type-1 study Measurement Uncertainty (MU) 1
B Linearity study on a non-linear gage General Measurement Device and Calibration Topics 7
P Purpose of calculating Ta, Tb & R Square in Linearity Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
M How calculate P value for Linearity and Bias using Excel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
P The correct way to do a Linearity and Stability Study on a Critical Dimension Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
E Company-wide MSA - Measurement Equipment Bias, Linearity & Stability Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
G Bias & Linearity Study and the Uncertainty of Standards Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
M Are Bias, Stability, and Linearity studies required by TS 16949 7.6.1? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
E Gage Linearity and Bias Questions Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
E How to Properly Apply Linearity - How does it "Fit"? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
I Difficulty with calculated t-value for Linearity Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
T Bias & Linearity Study - How to calculate the P value for the Average Bias Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
A Bias Linearity Stability MSA Excel File with Formula Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
M Profilometer Patch - Gain does not match, Linearity and Stylus = Good General Measurement Device and Calibration Topics 4
V Excel Linearity Chart - drawing 95% CI line & set X-axis at the bottom Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 13
C Linearity and Bias Study Compliance Requirements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
Rameshwar25 Linearity Study - Tolerance for which Ref Value Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
Rameshwar25 Trendline-Linearity - Questions related to Linearity study graph Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
T Gage Bias and Linearity - How to interpret the Minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
Rameshwar25 MSA Manual 4th Edition, Page 100 - What is wrong in the Linearity graph? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
C "Destructive" Linearity Study Methodology Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
S MSA 4th Edition formats in Excel wanted - GR&R, Bias, Stability and Linearity Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
F R-sq index in Linearity study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
J Uncertainty Budget for the Optical Microscope - Deriving Linearity Uncertainty Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Linearity Calculation Worksheet (including formula) General Measurement Device and Calibration Topics 1
M Linearity, BIAS & Stability - How many studies do I need to do for a device? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
L Recommend a 3rd Party Certifier for Master Value in Linearity & Bias Study General Measurement Device and Calibration Topics 0
B Can any one help me in Linearity calculations & acceptance criteria Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
B In a Linearity Study covering the operating range is it necessary to do Bias Study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
M When to use Linearity and Bias - appropriate for paper tensile strength? Quality Tools, Improvement and Analysis 6
A Linearity and Eccentricity Point Definitions - Ref: ISO/IEC 17025:2005 ISO 17025 related Discussions 1
S If I do Linearity and Bias Studies, are Stability Studies Required? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
I R-sq Value is Almost Zero - Linearity Study Question Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
B Any Easy Way to determine Linearity Study Acceptability? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
Ron Rompen MSA to perform Linearity and Stability studies on Variable Gauges with Minitab Ver 15 Using Minitab Software 6
V Linearity - R-sq evaluation - Where can we find R-sq evaluation criteria? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
A Linearity and Bias Study - Bias Study fails - Seeking advice Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
P Linearity & Bias Acceptable Percentage Guideline - Digimatic micrometer General Measurement Device and Calibration Topics 2
D MSA - Can Regular Calibration Replace Bias, Linearity and Stability Studies? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3

Similar threads

Top Bottom