MSA ed3 page 93 re: Question about Linearity formulas

M

mcada

#1
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

Elsmar Forum Sponsor

Marc

Fully vaccinated are you?
Staff member
Admin
#2
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
#3
I would love to try it, but don't have the book. Graeme might be the best to address this.
 
S

shard923

#4
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

#5
About "m" and "g"

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?
 
Thread starter Similar threads Forum Replies Date
A IATF MSA study Type 1 General Measurement Device and Calibration Topics 5
Nihls MSA after the device move Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M MSA angle issue - Nylon parts using Aberlink 3D Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
Ashland78 MSA clause or wording needed. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
S MSA clause 7.1.5.1.1 - Statistical studies on counting weight scale Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
Nihls MSA Study Type 2 (special conditions ) IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
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) 3
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 2
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
C Do Calibration Reference Standards require an MSA study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
A MSA When an Instrument Measures More than One Parameter Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
G MSA Type 1 - Cg and Cgk ranges Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
O MSA Study for a steel ruler Manufacturing and Related Processes 6
P IATF 16949 MSA Studies for CMM machines IATF 16949 - Automotive Quality Systems Standard 3
B 7.1.5.1.1 MSA for inline dimension vision inspection equipment IATF 16949 - Automotive Quality Systems Standard 5
G MSA on a Counting System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
C AIAG's IATF 16949 section 7.1.5.1.1 - Torque MSA Requirement Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
S IATF 16949 7.1.5.1.1 Measurement System Analysis (MSA - Die casting) IATF 16949 - Automotive Quality Systems Standard 5

Similar threads

Top Bottom