# Random data generation in Minitab

#### Ron Rompen

Trusted Information Resource
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?

#### Miner

##### Forum Moderator
Staff member
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

• 610.1 KB Views: 192

#### Ron Rompen

Trusted Information Resource
Thanks Miner. I have never used the Data Subset function before, but on first view, it looks like exactly what I need.

P Individuals Chart for Non-Sequential Data - Random Sample without Reference to Time Statistical Analysis Tools, Techniques and SPC 4
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
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
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
Solving "Random" Puzzles Key To Scoring A-List Tech Jobs Career and Occupation Discussions 8
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
Random Uncertainties - Can anyone explain "Random Uncertainties"? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Unannounced Random Audits General Auditing Discussions 1
GR&R Destructive Data Analysis Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Raw data retention EU Medical Device Regulations 0
Exporting data to the cloud is a "Significant Change"? EU Medical Device Regulations 5
Data sheet from McMasterCarr enough for RoHS/REACH documentation? REACH and RoHS Conversations 4
Eudamed data fields EU Medical Device Regulations 4
Need Help with FPY Data in Assembly Process Manufacturing and Related Processes 7
AMS 2750 E or F Continuous Furnace TUS Data Collection AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
Reduce occurrence rating based on the PMS data and customer complaint data ISO 14971 - Medical Device Risk Management 2
Customer Complaint & SCAR, false data Nonconformance and Corrective Action 14
Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Safety data sheets software REACH and RoHS Conversations 2
Data Protection and Privacy Policy - looking for a template/example EU Medical Device Regulations 1
Non parametric test for semi-quantitative data. Statistical Analysis Tools, Techniques and SPC 5
Disabling measurement data during fault conditions IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
EU MDR - Annex II 6.1 Pre-clinical and clinical data EU Medical Device Regulations 4
Ppk results shown as asterisk after the transformation of Non-normal data Using Minitab Software 4
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
Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
Best practice to ensure inputting of data in production Lean in Manufacturing and Service Industries 19
Preservation of Electronic Data / Information Technology ISO 13485:2016 - Medical Device Quality Management Systems 5
Comparing data from destructive testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
Technical Data Package vs Digital Product Definition APQP and PPAP 0
Putting back excluded rows/data points in a control chart Using Minitab Software 0
General Data Protection Regulation (GDRP) CE Marking (Conformité Européene) / CB Scheme 6
Minitab - Updating Graph with specific data points Using Minitab Software 2
PEMS Hazards - IEC 60601 Clause 14.6 - Internal data use - Pressure sensor IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
Transform variable data into attribute data Reliability Analysis - Predictions, Testing and Standards 24
Clinical evaluation without clinical data - MDR Article 61(10) EU Medical Device Regulations 8