Random data generation in Minitab

Ron Rompen

Trusted Information Resource
#1
While providing some training for 'new' users in Minitab, an interesting question came up that I can't find an answer to.

When random data is created in Minitab (under the Calc dropdown menu) you can create the target value and standard deviation easily. But is there a way to limit the LOWER or UPPER limit of the data? For example, if I was creating a random set of normal data for flatness, and set a mean of 0.050 and a standard deviation of .021 (this represents actual data that we have accumulated over a short term study - I am trying to illustrate how Minitab can be used to 'predict the future' using data analysis) then at least SOME of the data that I generate will be less than 0.

I can correct this by brute force methods (visually examine each line of data for a negative value) or copy into Excel, sort, then remove anything less than zero, repaste into Minitab...etc etc etc.

Is there an easier/better way to do this?
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
The easiest way within Minitab is to use Data > Subset Worksheet:
- How do you want to create a subset?: Use rows that match a condition
- Do you want to include or exclude rows?: Exclude rows that match the condition
- Condition: Is less than
- Value: 0; check/uncheck Include value depending on whether you want to include zero.
 

Attachments

Ron Rompen

Trusted Information Resource
#3
Thanks Miner. I have never used the Data Subset function before, but on first view, it looks like exactly what I need.
 
Thread starter Similar threads Forum Replies Date
P Individuals Chart for Non-Sequential Data - Random Sample without Reference to Time Statistical Analysis Tools, Techniques and SPC 4
J Internal audit random sampling methodology Internal Auditing 2
C Random defects vs systematic (designed in) errors or faults. Design and Development of Products and Processes 1
M Stratified Random Sampling Calculations Statistical Analysis Tools, Techniques and SPC 1
A Random Sampling Statistical Analysis Tools, Techniques and SPC 10
G Sampling Question - Random Sample of 100 pcs and 11 pcs. have been rejected Inspection, Prints (Drawings), Testing, Sampling and Related Topics 30
L Do all non-random patterns apply to attributes and variable charts including R chart? Statistical Analysis Tools, Techniques and SPC 5
S Random Sampling of Chickens Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
P Random Sampling at Receiving Inspection: A Practical Implementation needed Inspection, Prints (Drawings), Testing, Sampling and Related Topics 13
S Probability Density Function of a Function of a Random Variable Statistical Analysis Tools, Techniques and SPC 13
I Multiple Comparisons for a Random Factor Using Minitab Software 2
D How to perform Random Sampling Statement Inspection, Prints (Drawings), Testing, Sampling and Related Topics 10
A Random Sampling for in-process inspection Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
P Random Sampling vs. Thorough Review - Records to be Reviewed - Audit Finding Inspection, Prints (Drawings), Testing, Sampling and Related Topics 13
S Random Sampling question - taking samples from the same spot! Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
H Part Number Assignment, Should be coded or Random? Manufacturing and Related Processes 11
Marc Solving "Random" Puzzles Key To Scoring A-List Tech Jobs Career and Occupation Discussions 8
Ajit Basrur Random Insult Generator (RIG) Coffee Break and Water Cooler Discussions 2
M Random 'Normal Distribution' Numbers in Excel Excel .xls Spreadsheet Templates and Tools 26
M Creating a "random disturbance" for each observation via MINITAB Using Minitab Software 1
S Using AQL to get true random sampling using General Inspection Level II AQL - Acceptable Quality Level 4
C Random Uncertainties - Can anyone explain "Random Uncertainties"? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Marc Unannounced Random Audits General Auditing Discussions 1
Fjalar ISO 20417:2021: Technical Data (6.6.4 c) Other Medical Device Related Standards 0
Z PMS Data collection for SAMD SaaS from clients EU Medical Device Regulations 3
S How too Bulk data upload on EUDAMED EU Medical Device Regulations 5
M Validation of Data verification tool per 21 CFR 820 Quality Assurance and Compliance Software Tools and Solutions 1
J Stage 2 audit initial cert, few data points ISO 13485:2016 - Medical Device Quality Management Systems 4
placebo_master Risks of executing a verification protocol against existing data ISO 13485:2016 - Medical Device Quality Management Systems 4
Z Why Control Limits are not the same depending on type of exclusion of data points Using Minitab Software 7
D Question: How to analyze numerical and attribute data Reliability Analysis - Predictions, Testing and Standards 11
N Simple statistics questions on labor data Statistical Analysis Tools, Techniques and SPC 2
T Data verbiage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 6
S QR/2D Codes & Data Strings Misc. Quality Assurance and Business Systems Related Topics 1
A Need to calculate tolerance Intervals with a set of non-normal data and 3-Parameter Weibull distribution Using Minitab Software 0
B GR&R Destructive Data Analysis Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 13
E Raw data retention for Diagnosis Results EU Medical Device Regulations 4
Y Exporting data to the cloud is a "Significant Change"? EU Medical Device Regulations 5
Z Data sheet from McMasterCarr enough for RoHS/REACH documentation? REACH and RoHS Conversations 4
S Eudamed data fields EU Medical Device Regulations 5
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 3
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

Similar threads

Top Bottom