Transformation of Data Normality Failed

Hello All,

Recently i have collected around 24000 reading from a camera measuring a distance of 2mm ± 1mm. I am trying to understand the capability of the system. This is a manufacturing line.
  1. Data was cleaned
  2. Outliers were removed
Normality test failed. I tried to transform it with all the possible options in mini tab including Cox, Johnson and all the rest. I am now stuck as i cannot predict the ppms.

Any ideas what my next step should be please? I can upload the data if required.

Thank you
Elsmar Forum Sponsor

Ron Rompen

Trusted Information Resource
Try running ALL the data (before cleaning and outlier removal). One thing that I have always questioned is the rationale used in removing outliers. If they are a part of your 'normal' process, then they should be included (IMHO)


Forum Moderator
Staff member
Please upload the data as an Excel file. Many here do not use Minitab.

There are several reasons it might fail a normality test. You may has an unstable process, mixed process streams or chunky data. It will be easier to tell with the data.
thank you Miner.
I tried to remove the outliers but still it will not be normal.

do you think if i remove the outliers the data will be biased?


Forum Moderator
Staff member
Even with the outliers removed, you have distinct shifts and drift in the process that will result in a non-normal distribution that cannot be transformed. Do you have more than one process stream? Are there changes in material or tooling that would cause these shifts. Additional information about the process would help us.
So basically what you are seeing is one big web of paper and foil is being applied on the paper. There are 4 traverses being done at the same time. Camera is reading the position of the foil. So same machine is doing the foil stripe at the same time.


Forum Moderator
Staff member
The out of control issue is primarily driven by abrupt process shifts. Do you have any automatic (or manual) adjustments that might be occurring? This is the major problem with normality. There is a secondary issue that you will have to deal with after dealing with the shifts, and that is the poor resolution of the measurement system. In the graph below, I extracted a portion of the data that was stable and in control. It still failed a normality test due to the chunkiness of the measurements. This is illustrated by the discrete vertical groupings of measurements in the graph below.
Probability Plot of 1.85.jpg
Hello Miner and thank you.
The data is being capture auto by a camera system that does the measurements. So three decimal places would make things better?

The machine is manual adjusted, so could be the operator was doing adjustments or the machine is varying due to mechanical issues. I have to look into that.
Thread starter Similar threads Forum Replies Date
P Ppk results shown as asterisk after the transformation of Non-normal data Using Minitab Software 4
I Finding optimum transformation equation for two sets of data Using Minitab Software 15
L Cpk after Data Transformation - How to Transform LCL /UCL to get Capability Report Capability, Accuracy and Stability - Processes, Machines, etc. 8
P Data Analysis - Johnson Transformation/Weibull Distribution/Capability Analysis Capability, Accuracy and Stability - Processes, Machines, etc. 15
L Lean Transformation - How do you get Senior Leadership engaged Human Factors and Ergonomics in Engineering 6
Marco Bernardi Johnson transformation: The PPU has been got even if USL not? Capability, Accuracy and Stability - Processes, Machines, etc. 3
J Lean Transformation Project - Distribution centre in Europe Lean in Manufacturing and Service Industries 1
P Taguchi Logit Transformation in Minitab Using Minitab Software 7
H Johnson Transformation in Minitab - How upper & lower spec limits are recalculated Using Minitab Software 1
H Specification Limits outside of Johnson Transformation Capability, Accuracy and Stability - Processes, Machines, etc. 15
M Using the Johnson Transformation in Minitab Six Sigma 1
Q Johnson Transformation Tool - Minitab Using Minitab Software 4
D Johnson's Transformation - Minitab 14 - How can I find out Ppk - Non-normal Distribu? Using Minitab Software 9
S Johnson's Transformation Distribution Model Statistical Analysis Tools, Techniques and SPC 2
S Eudamed data fields EU Medical Device Regulations 0
J Need Help with FPY Data in Assembly Process Manufacturing and Related Processes 7
Q AMS 2750 E or F Continuous Furnace TUS Data Collection AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
M Reduce occurrence rating based on the PMS data and customer complaint data ISO 14971 - Medical Device Risk Management 2
J Customer Complaint & SCAR, false data Nonconformance and Corrective Action 14
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
D Safety data sheets software REACH and RoHS Conversations 2
M Data Protection and Privacy Policy - looking for a template/example EU Medical Device Regulations 1
S Non parametric test for semi-quantitative data. Statistical Analysis Tools, Techniques and SPC 5
M Disabling measurement data during fault conditions IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
C EU MDR - Annex II 6.1 Pre-clinical and clinical data EU Medical Device Regulations 4
lanley liao How to correctly understand the bullet list d) of 6.3 Analysis of Data for API Spec Q1 Oil and Gas Industry Standards and Regulations 7
Steve Prevette Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
qualprod Best practice to ensure inputting of data in production Lean in Manufacturing and Service Industries 19
D Preservation of Electronic Data / Information Technology ISO 13485:2016 - Medical Device Quality Management Systems 5
M Comparing data from destructive testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
DuncanGibbons Technical Data Package vs Digital Product Definition APQP and PPAP 0
Z Putting back excluded rows/data points in a control chart Using Minitab Software 0
F General Data Protection Regulation (GDRP) CE Marking (Conformité Européene) / CB Scheme 6
Z Minitab - Updating Graph with specific data points Using Minitab Software 2
E PEMS Hazards - IEC 60601 Clause 14.6 - Internal data use - Pressure sensor IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
K Transform variable data into attribute data Reliability Analysis - Predictions, Testing and Standards 24
R Clinical evaluation without clinical data - MDR Article 61(10) EU Medical Device Regulations 8
H Capability Data for Paint Thickness on Painted Parts Statistical Analysis Tools, Techniques and SPC 10
D BS EN 62304 - Medical-Relevant Data C.5 - Definition of IEC 62304 - Medical Device Software Life Cycle Processes 5
T Submitting MR Compatibility Data for 510(k) Cleared Device Other Medical Device and Orthopedic Related Topics 2
S Quality manager considering data science Quality Manager and Management Related Issues 19
A What are Practical data center best practices IEC 27001 - Information Security Management Systems (ISMS) 1
U Do we need clinical trial data for Class IIa medical device under MDR EU Medical Device Regulations 7
S Average and standard deviation of Cumulative Data Statistical Analysis Tools, Techniques and SPC 5
V IS/ISO/IEC 17025:2017 Clause 7, sub clause 7.11 Control of data and information management ISO 17025 related Discussions 1
Watchcat CERs Literature Databases - Searching for data to evaluate EU Medical Device Regulations 16
J Sample size for creating a data base as a reference to a tested variable Other Medical Device and Orthopedic Related Topics 6
M GUDID data deficiency communication - IS THIS A SCAM? ISO 13485:2016 - Medical Device Quality Management Systems 29
H Question about implications of performing Firmware upgrade via MDDS - Medical Device Data Systems 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
R Demonstrate how sufficient levels of access to data is achieved - Claims of equivalence EU Medical Device Regulations 3

Similar threads

Top Bottom