# MSA ed3 page 93 re: Question about Linearity formulas

M

Hi everyone,
just would like to ask for help regarding the formula for slope a, intercept b and the upper and lower confidence bands...all formulas use the variable gm

1. does gm means g (# of parts) * m(# of trials) ?
if so, i got different results when I try to calculate the example on pages 94-95

...but when i use g only instead of gm i got the correct result

...attached is my sample worksheet, BTW, in the worksheet I created a simple vba function that calculates the significant t value, actually its just sort of an interpolator of XL's TINV function because TINV only worked with integers

#### Attachments

• 40.5 KB Views: 883

#### Marc

##### Hunkered Down for the Duration
Staff member
I rasn across this oldie with no response. i know it's long over due, but anyone want to take a shot at it anyway?

#### Hershal

##### Metrologist-Auditor
Staff member
Super Moderator
I would love to try it, but don't have the book. Graeme might be the best to address this.

S

#### shard923

I am unsure after looking at your spreadsheet, what are you trying to accomplish here? I looks like you are trying to perform linear regression. IE Trying to interpolate or predict a linear value for non-linear data. Is this the case or am I way off the mark?

A

#### Alexandre Bonatto

I believe that "g" is the number of samples (number of subgroups, clusters, ...) and "m" is the sample size. In bias study (p.85) - item 5 - it says that g=1 and m=n (number of measurements). If data is collected through any kind of chart (Xbar & R, ...), "m" will be a constant (the size of each sample collected) and "g" will be the number of samples registered in the chart.

Do you agree?

Updated MSA with the Annual PPAP validations APQP and PPAP 8
MSA for Push and Pull test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
MSA for Calculated Clearance Dimension Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA on automated measurement system - Multiple Step Vision System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA check list to audit IATF 16949 - Automotive Quality Systems Standard 8
MSA for ATE (Automatic Test Equipment Embedded Software) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
MSA Tools Misc. Quality Assurance and Business Systems Related Topics 3
MSA studies for Heat Treatment Equipment Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Industrial scales and MSA (IATF 16949 requirement 7.1.5.1.1) IATF 16949 - Automotive Quality Systems Standard 30
Difference between MSA and MSE? General Measurement Device and Calibration Topics 1
Test method validation - Is MSA (MSA1, MSA2, MSA3 and linearity) a good solution? Medical Device and FDA Regulations and Standards News 1
MSA results differences - Supplier results vs. My results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Preliminary MSA and Sockets' correlation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
MSA requirement for 5 Micrometers + CP changes need customer approval? IATF 16949 - Automotive Quality Systems Standard 2
Correct MSA study for an automated camera system which makes attribute inspection Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA Misc. Quality Assurance and Business Systems Related Topics 46
Measurement system analysis - Can you help me about implementation MSA for CMM device Manufacturing and Related Processes 2
MSA Study for a Leak Testing Device Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
Justifications for not performing MSA (Measurement System Analysis) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
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
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
Compression Spring Force MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
MSA Study on MTS dynamic rate measurements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
The FILE recommended by AIAG MSA 4ed for LINEARITY Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
IATF 16949 Audit MSA IATF 16949 - Automotive Quality Systems Standard 10
Do Calibration Reference Standards require an MSA study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
MSA When an Instrument Measures More than One Parameter Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
MSA Type 1 - Cg and Cgk ranges Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA Study for a steel ruler Manufacturing and Related Processes 6
IATF 16949 MSA Studies for CMM machines IATF 16949 - Automotive Quality Systems Standard 3
7.1.5.1.1 MSA for inline dimension vision inspection equipment IATF 16949 - Automotive Quality Systems Standard 5
MSA on a Counting System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
AIAG's IATF 16949 section 7.1.5.1.1 - Torque MSA Requirement Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
IATF 16949 7.1.5.1.1 Measurement System Analysis (MSA - Die casting) IATF 16949 - Automotive Quality Systems Standard 5
MSA on Part Specific Attribute Fixtures Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
Test Method Validation or MSA for Batch Manufacturing Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA on a process using different fixtures Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
B Camera Vision System Measurement System Analysis (MSA) Reliability Analysis - Predictions, Testing and Standards 3
D Cp/Cpk on Gages for MSA (vs. Cg/Cgk) Capability, Accuracy and Stability - Processes, Machines, etc. 21
Number of Distinct Categories" or NDC Calculation in MSA Studies Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
Q Doing an MSA on a Climatic Chamber Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
IATF 16949 7.1.5.1.1 Measurement System Analysis (MSA) - Visual Inspection IATF 16949 - Automotive Quality Systems Standard 14
C MSA for Non Manufacturing - Design Validation, Characterization and Qualification Lab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
C PPAP Rejection for "MSA-GR&R are not using the latest AIAG format" APQP and PPAP 9
C MSA (Measurement System Analysis) - Instrument Selection Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
C MSA (Measurement System Analysis) - Dimension Selection Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
P Frequency and Sample Size Requirements for an MSA Studies Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
A Automated Measurement Machine MSA - Small Parts Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA for a part Automated and part Manual Inspection Machine IATF 16949 - Automotive Quality Systems Standard 7