# T-value used for MSA - t-value used in MSA Bias Example is different from Excel

C

#### clcheng

T-value used for MSA

I noticed that we can get the t-value from Excel. However, the t-value used in MSA for Bias Example is different from the Excel. Instead, it was tabulated based on Student T Distribution Table using proportionate method coz it's not an interger value.

If the degree of freedom is an integer, t-value obtained from Excel and Student T Distribution Table are the same. However if the df is in decimal, the t-value from Excel is different from table (proportionate method).

Which one is the correct t-value to use for Bias study???

Anyone willing to help me?

#### Atul Khandekar

##### Quite Involved in Discussions
clcheng,
I don't think there is a function in Excel that will give you the t-value for 'decimal' DF. You can always use the same math in Excel that you used for calculating t from tables. For DF=10.8, get t for 10 and 11, then interpolate.

Hope this helps... and welcome to the Cove!

#### Atul Khandekar

##### Quite Involved in Discussions
The latest addition to the AIAG MSA FAQ, answers this exact question:

Q: I can't determine how to calculate the significant t value (two-tailed) in Table 3 on page 88 (value shown as 2.206) and Table 4 on page 90 (value shown as 1.993).

Ans:...
For Table 3: Given that the df = 10.8, look in a t-table in a standard statistical reference book. Look for the value in the t-table for df=10 and df=11, in the t-sub-0.975 column (this column represents the two-sided values for 95% confidence). The value at 10 df = 2.2281 and the value for 11 df = 2.2010. You must interpolate between these values to get the answer for this problem.

Take the difference between 2.2281 and 2.2010. This equals 0.0271. Since the df we are after is 10.8, we need to interpolate by either adding 20% of this value to the 2.2010, or by subtracting 80% of this from 2.2281. 20% of .0271 = 0.00542; adding that to the df for 11 = 2.2010 + .00542 = 2.206, rounded off to 3 places as shown in MSA3. Or you may find 80% of .0271 = .02168. Subtracting that from the df for 10 = 2.2281 - .02168 = 2.206, the same value we found using the alternate method.

Z

#### Zunaidy

significant t value (2-tailed)

there is a function in EXCEL namely TINV(x,y)
x = you just input the default value of 0.05
y = it is the degree of freedom. for the value in table page 90, refer to Appendix C d2 table page 195, look at g=20 and m=5. you will have y=72.7

the result of TINV(0.05,72.7) equals to 1.993
i had compared to the table 3 page 88, it has the correct value.

i'm just using excel to compute bias study & linearity study.

#### Atul Khandekar

##### Quite Involved in Discussions
Zunaidy said:
there is a function in EXCEL namely TINV(x,y)
x = you just input the default value of 0.05
y = it is the degree of freedom. for the value in table page 90, refer to Appendix C d2 table page 195, look at g=20 and m=5. you will have y=72.7

the result of TINV(0.05,72.7) equals to 1.993
i had compared to the table 3 page 88, it has the correct value.

i'm just using excel to compute bias study & linearity study.
A word of caution: In TINV, if degrees_freedom is not an integer, it is truncated. So if you use 72.1,72.2...72.9 Excel returns the same value as TINV(0.05,72).

In this case (I think you are refering to Table 4, page 90),
TINV(0.05,72)= 1.99346231966047 and
TINV(0.05,73)= 1.99299847736256,
They are very close, so interpolated value for 72.7 will be correct (1.993) upto 3 decimal places. You may run into trouble with lower value of DF.

Determining the Value of Used Equipment Calibration and Metrology Software and Hardware 5
Methods used to calculate Cpk value - Need help for Cpk Calculation Statistical Analysis Tools, Techniques and SPC 8
E Which standard Cpk value intervals are common or frequently used? Statistical Analysis Tools, Techniques and SPC 5
M What is ISO9004? Is it of value? Should it be used? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
Determining a tolerance value for Measuring devices in-house inspection General Measurement Device and Calibration Topics 12
Improving low p-value Statistical Analysis Tools, Techniques and SPC 13
Registrars with VAR (Value Added Reseller) experience Registrars and Notified Bodies 7
Best approach to get a real value as average? Statistical Analysis Tools, Techniques and SPC 6
Missing value of Uncertainty B Measurement Uncertainty (MU) 8
Calibration certificate content - Average Value and True Value ISO 17025 related Discussions 6
In BAC5300 we have machining mismatch allowed is 3tau, what is the value of tau? Document Control Systems, Procedures, Forms and Templates 1
Change value of target during a batch Capability, Accuracy and Stability - Processes, Machines, etc. 0
Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
Torque Value for Different types of Fasteners (Socket Head, Button Head, CSK) Manufacturing and Related Processes 2
IATF 16949 - 8.5.6.1.1 Providing a list of process controls: Does this requirement add value to QMS? IATF 16949 - Automotive Quality Systems Standard 4
Cycle times, value stream mapping, inventory, average values? Lean in Manufacturing and Service Industries 1
What are the criteria for setting a target KPI value against a quality objective? Benchmarking 7
Adding Value prior to signing EASA Form 1 EASA and JAA Aviation Standards and Requirements 5
Creating a Plant Level Value Stream Map Process Maps, Process Mapping and Turtle Diagrams 1
IMDS - Changing the Locked Weight Value RoHS, REACH, ELV, IMDS and Restricted Substances 1
Value Chain Map for Food Services Industry Service Industry Specific Topics 1
P-Value less than 0.05. but everything else in control Statistical Analysis Tools, Techniques and SPC 19
P x I = Value interpretation for residual risk? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
CPK with a P value less than 0.005 Manufacturing and Related Processes 8
What degrees of freedom means in uncertainty budget and how do I set the value Measurement Uncertainty (MU) 2
Q Really do they add value (Vision, Mission, Values)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
What is the exact Temperature Coefficient Value to be set on a Conductivity Meter? General Measurement Device and Calibration Topics 2
Value Stream Mapping Calculations Process Maps, Process Mapping and Turtle Diagrams 5
L How to interpret the average R bar Value shown in the R Chart Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Non Value Added Corrective Actions IATF 16949 - Automotive Quality Systems Standard 15
R How To Calculate & Print CDF and Lower Bound CDF value for some t(time) with Minitab? Using Minitab Software 1
P Purpose of calculating Uncertainty value in calibration study Measurement Uncertainty (MU) 5
J Agenda of Value Stream Mapping workshop required Quality Tools, Improvement and Analysis 1
What is the value of documenting in-process rework for easily-detectable issues? Quality Manager and Management Related Issues 4
VSM - Value Stream Mapping (catheter manufacturing unit) Customer Complaints 10
W Quality for value adding or certification? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 23
T Cpk for 0 as Ideal Value Statistical Analysis Tools, Techniques and SPC 1
Internal Audit Value - What is the point of conducting internal audits to a checklist Internal Auditing 40
L 5 minutes only for this Survey on the Value of PDCA and Your EMS Miscellaneous Environmental Standards and EMS Related Discussions 1
M How calculate P value for Linearity and Bias using Excel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
J F and P-value in L9 Taguchi Design Using Minitab Software 22
Value of Ppk or Cpk when targeting thinner material Statistical Analysis Tools, Techniques and SPC 4
How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
Analysis of 'Value Added' System & Process Steps - Inspection Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 2
P Which ISO 13485 clause(es) are applicable for Value Proposition Creation ISO 13485:2016 - Medical Device Quality Management Systems 1
R The Value and Effectiveness of In Process Inspection Quality Manager and Management Related Issues 17
D Value-Added Analysis - Staff (Employee) Satisfaction Quality Tools, Improvement and Analysis 11
T ISO Auditor Training - What online training is actually value added? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 13
Specific Capability case - Target Value is same as the Lower Limit Capability, Accuracy and Stability - Processes, Machines, etc. 9
S GR&R for an "R" value instrument installed on my 10K Horizontal Tester Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5