# Interpreting Level of Confidence - Round Robin for Tensile Testing - Help needed

S

#### Sorin

Performing Round Robin for tensile testing (required for Nadcap cert)

I have 3 operators. Each one processed 4 tests.

Population 12
Level of confidence required is 95%
Standard deviation (for tensile values only) is 0.51.
Required tensile range (for acceptance) is 280-300 ksi. All results were in the upper range - lowest 295.7, highest 297.4.
Average: 296.67
Calculating level of confidence using "confidence" function in Excel is giving me a result of 0.289.

How do I interpret this?

Detailed explanations would be very, very appreciated.

Last edited by a moderator:
N

#### NumberCruncher

Re: Need help interpreting level of confidence

Hi sorin

Take your standard deviation (0.51) and divide by [square root(12)]=3.1641
This gives you 0.1472, which is the estimated standard deviation of your mean (remember sigma/(root n) ?)

Multiply by 3.1641 x 1.96 (ie 95% range for standard normal distribution) to give 0.2885596, or about 0.289.

So for your mean, the 95% confidence interval is between (mean - 0.289) and (mean +0.289) in whatever units you used to measure the tensile strength. So the 95% c.i. will be about 296.7 +/- 0.289 (in tensile strength units).

NC

Last edited by a moderator:
S

#### Sorin

Re: Need help interpreting level of confidence

Hi sorin

Take your standard deviation (0.51) and divide by [square root(12)]=3.1641
This gives you 0.1472, which is the estimated standard deviation of your mean (remember sigma/(root n) ?)

Multiply by 3.1641 x 1.96 (ie 95% range for standard normal distribution) to give 0.2885596, or about 0.289.

So for your mean, the 95% confidence interval is between (mean - 0.289) and (mean +0.289) in whatever units you used to measure the tensile strength. So the 95% c.i. will be about 296.7 +/- 0.289 (in tensile strength units).

NC
Would that mean that in order to have a 95% confidence, only individual results and/or only avg results (for each operator) shall be between 296.381 and 296.959 ?

#### Bev D

##### Heretical Statistician
Staff member
Super Moderator
Re: Need help interpreting level of confidence

the method NumberCruncher applied is for the MEANS and not for the individual values. If you need 95% confidence on the spread of the individual values you need a different formula. You could use an assumption of a Normal distribution of the individual values (mean + 1.96*sample SD/c4), tolerance intervals or prediction intervals. with such a small sample size, tolerance intervals will be very large.

N

#### NumberCruncher

Re: Need help interpreting level of confidence

Hi sorin

Have a look at the Excel help file for "confidence". You should be able to follow the calculation.

As Bev has so concisely explained, the calculation gives the confidence interval of your single, mean result, of 296.67. This will be rather smaller than the interval for individual measurements.

The calculation used by Excel is simply the application of the central limit theorem. Look it up on the net.

NC

Interpreting Tensile Charts General Measurement Device and Calibration Topics 0
Interpreting China Medical Device regulations/standards China Medical Device Regulations 1
ISO 80369-7 standard - Interpreting which Parts should be in scope Other Medical Device Related Standards 7
PACS - interpreting MDD and Borderline Guidance CE Marking (Conformité Européene) / CB Scheme 5
M List of Packaging Contents - Medical Devices - Interpreting EU Directive 93/42/EEC CE Marking (Conformité Européene) / CB Scheme 3
D Interpreting Normal vs Weibull Capabilities Capability, Accuracy and Stability - Processes, Machines, etc. 4
P Interpreting Span Measurement - P95-P5 Six Sigma 1
Interpreting Deviations 5 & 6 in Annex ZA in ISO 14971:2012 ISO 14971 - Medical Device Risk Management 1
Interpreting "misuse" when assessing Hazardous Situations ISO 14971 - Medical Device Risk Management 2
S Interpreting clause 4.1.5 in ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 9
Interpreting Process Controls - 21 CFR Part 820.70(a) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
Help interpreting 21 CFR Part 806 (corrections and removals) Other US Medical Device Regulations 1
G Interpreting Type 1 MSA (Measurement Systems Analysis) Results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Help interpreting MIL-STD-105E Single Sampling Plans Tables Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
M Biocompatibility in Respiratory Products - Help interpreting whitepaper IEC 60601 - Medical Electrical Equipment Safety Standards Series 22
I Interpreting Product Realization (Clause 7) in ISO 9001:2008 for Service Industry ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
V GD&T Interpreting Datums in Two Single Segmented Position Tolerances Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
M Interpreting X bar and R Control Charts Statistical Analysis Tools, Techniques and SPC 2
B Help with interpreting stock market terminologies Coffee Break and Water Cooler Discussions 4
V Interpreting Zinc Plating Specification GMW 3044 - 6K96/48 APQP and PPAP 2
Interpreting and Applying 7.3.2 Design and Development Inputs ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
S Interpreting the Calibration Report for my Dial Indicator General Measurement Device and Calibration Topics 3
J Interpreting Process Capability results and ratios Capability, Accuracy and Stability - Processes, Machines, etc. 1
B Length Measure - Interpreting Calibration Results and Measurement Uncertainty (MU) Measurement Uncertainty (MU) 3
M Interpreting AS9100 Clause 8.2.2 Internal Audit Requirements Internal Auditing 28
T Interpreting my t test in Minitab Using Minitab Software 2
S Interpreting Linear Regression Results from Minitab Using Minitab Software 15
Interpreting LMC for Pattern of Slots (GD&T) Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Interpreting Minitab Test For Equal Variances Using Minitab Software 3
V Interpreting Minitab Gauge R&R Results Using Minitab Software 6
A ISO 2081 - Interpreting Coating Thickness Other ISO and International Standards and European Regulations 3
L Interpreting Injection Molding Tooling Documents - Cavities Manufacturing and Related Processes 3
C Interpreting Gage R&R Results - 3 operators, 3 iterations and 10 parts Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
M Interpreting Measurement Uncertainty for Temperature PRT probes Measurement Uncertainty (MU) 2
N Interpreting Hygrometer Calibration Uncertainty - Temperature Coefficient Measurement Uncertainty (MU) 1
Interpreting Decimals in the mm state - Off Wall Question Inspection, Prints (Drawings), Testing, Sampling and Related Topics 14
J Interpreting clause 7.5.2.1 (validation of software used in production & service) ISO 13485:2016 - Medical Device Quality Management Systems 2
E Interpreting Partial Least Square Results Using Minitab Software 1
C Interpreting Outside Laboratory Calibration Certificate Measurement Uncertainty (MU) 3
M Interpreting MIL-PRF-19500 (Performance Spec, Semicon Dev) - What is LTPD of 20 - ??? Manufacturing and Related Processes 4
T Rules for interpreting control charts Statistical Analysis Tools, Techniques and SPC 2
Q Interpreting Responsibility and Authority Clause 5.5.1 ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 18
H Interpreting 'Evaluation of compliance' in ISO 14001 Internal Auditing 4
P Micrometer Gage R&R study - Interpreting the data and suggestions Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
W Interpreting a Normal Probability Plot Statistical Analysis Tools, Techniques and SPC 4
"Downsizing" ramifications - Evaluating and Interpreting the News World News 0
Q Interpreting calibration result of Air Particle Counter on Counting efficiency General Measurement Device and Calibration Topics 1
A Particle Counter Results - Interpreting Data for a Class 100,000 Cleanroom Other Medical Device Related Standards 12
M GD&T Q&A session - Interpreting FCF (Feature Control Frame) Inspection, Prints (Drawings), Testing, Sampling and Related Topics 43
N TL 9000 - Help Interpreting Normalization Unit for Measurements TL 9000 Telecommunications Standard and QuEST 2