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

Hunkered Down for the Duration
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
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) 5
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 8
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
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
J MSA on Part Specific Attribute Fixtures Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
G ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
S Test Method Validation or MSA for Batch Manufacturing Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
S 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
L 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
L 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
Crimpshrine13 MSA for a part Automated and part Manual Inspection Machine IATF 16949 - Automotive Quality Systems Standard 7

Similar threads

Top Bottom