Dummy Data with Dependency

Mikael

Quite Involved in Discussions
#1
Hi

There are some webpages that do random dummy data to test with, but I need the data to be related/depend on each other, for instance if I have two fields a start and stop date, it must make sense relative to each other.

Does anyone knows a tool where I can define an interval and the relations?

Or perhaps someone have an idea how generate it in Excel?
 
Elsmar Forum Sponsor

Steve Prevette

Deming Disciple
Leader
Super Moderator
#2
Hi

There are some webpages that do random dummy data to test with, but I need the data to be related/depend on each other, for instance if I have two fields a start and stop date, it must make sense relative to each other.

Does anyone knows a tool where I can define an interval and the relations?

Or perhaps someone have an idea how generate it in Excel?
You are basically entering the arena of Monte Carlo simulations, which can be easily done in Excel. There is a rand() function in Excel which will give you a uniformly distributed number between 0 and 1. You then run that through the inverse of the distribuiton you want. Excel has several inverse distributiones including that for Normal.

If you wanted to do the start date stop date example, you could randomly generate start dates (probably sticking to a uniform distribution) then add to that some Normally distributed random variable for the cycle time.

You can also simulate serially-dependent data by generating the next random number from some combination of the previous value, and the new random number.
 

Miner

Forum Moderator
Leader
Admin
#3
To expand on Steve's comment, you can add RAND() into any distribution function that uses a probability term.

For example: NORM.INV(probability, mean, standard_dev). Substitute RAND() for probability, and you have NORM.INV(RAND(), mean, standard_dev). This will give you random data from a normal distribution.

LOGNORM.INV(RAND(), mean, standard_dev) will give you random data from a lognormal distribution, which is commonly used for time data.
 

Mikael

Quite Involved in Discussions
#4
Thx you both :), though I am not sure how to use the random() correct.


I created 2x date field and time, so I need to add the random minutes, this works:
=SUM(D14+TIME(0;(RANDBETWEEN(1;59));0))

But if I try to add:
LOGNORM.INV(RANDbetween(), mean, standard_dev)

I cannot make it work, how important is that?
 
Last edited:

Steve Prevette

Deming Disciple
Leader
Super Moderator
#5
Thx you both :), though I am not sure how to use the random() correct.


I created 2x date field and time, so I need to add the random minutes, this works:
=SUM(D14+TIME(0;(RANDBETWEEN(1;59));0))

But if I try to add:
LOGNORM.INV(RANDbetween(), mean, standard_dev)

I cannot make it work, how important is that?
Try this: =LOGNORM.INV(RAND(),1,2)

When you use the inverses, the random number must be uniform between zero and 1, which is what RAND() gives you. Then you can apply the mean and standard deviation you want to the Lognorm.inv.
 

Mikael

Quite Involved in Discussions
#6
Thx, that works and of course it does not makes sense to define the interval there, but can I then define that it has to be minutes from 1 to 59 or sometimes hours 0 -23 ? Maybe it is a stupid question because I don't understand what it does, can you help me a little on why I need lognorm.inv?
 

Steve Prevette

Deming Disciple
Leader
Super Moderator
#7
The Log Normal distribution is frequently used to model times because it has the beneficial property of not generating negative numbers. Basically looks like the bell curve (the "Normal Distribution") except it terminates at zero rather than running into negative numbers. There are other distributions with this property, but the log normal is the simplest (mathematically) to use.

Excel stores dates and times as numbers, starting with January 1, 1900. So you really don't need to worry about generating 0 to 23 for hours and 0 to 59 for minutes. Generate a random number, then format the cell to a date/time or just time format. It may take some trial and error to get the correct ranges to use, but is probably the easiest way to go. Plus, if you want to add the cycle time to the start date to get a finish date, you need to go this route.
 
Thread starter Similar threads Forum Replies Date
J Dummy SMTP server for email testing Software Quality Assurance 3
S How to use Dummy Variable in Regression Model in Minitab Six Sigma 2
I Do we need GOOD and BAD Wire Harness "Dummy" Samples? IATF 16949 - Automotive Quality Systems Standard 3
M Dummy Recall Guidelines - How to evaluate recall effectiveness ISO 13485:2016 - Medical Device Quality Management Systems 3
J Certified Crash Test Dummy General Measurement Device and Calibration Topics 4
M ADME data- substances based MD EU Medical Device Regulations 0
B Can a software that receive data from a MD be classified as Class I?or is not a MD? EU Medical Device Regulations 5
T Process Potential estimation for binary data Capability, Accuracy and Stability - Processes, Machines, etc. 3
RoxaneB Data Storytelling Misc. Quality Assurance and Business Systems Related Topics 4
MaHoDie Summative Evaluation with Post-Market Data? Human Factors and Ergonomics in Engineering 2
J EU Data Act Medical Information Technology, Medical Software and Health Informatics 0
P Transferring medical data from a device (Sec 201(h)): regulatory implications US Medical Device Regulations 3
Z Change color or shape of individual data point in control chart Using Minitab Software 6
R FDA ECG Data Requirements Medical Information Technology, Medical Software and Health Informatics 3
T SQL Server 2019 - Master Data Services - Validation needed? ISO 13485:2016 - Medical Device Quality Management Systems 4
C Elaborating a control chart with skewed data Manufacturing and Related Processes 4
D Data normality versus capability Capability, Accuracy and Stability - Processes, Machines, etc. 11
I In-Process Inspection Raw Data ISO 13485:2016 - Medical Device Quality Management Systems 3
T Class III device and shelf life data requirements US Medical Device Regulations 7
S Discussion on OBL and OEM test data for submission as per new EUMDR EU Medical Device Regulations 0
C How to place software version for SaMD product in HIBC secondary data structure (UDI-PI)? Other US Medical Device Regulations 3
PQ Systems Better Data Visualization & Communication with Statistical Indices Using SQCpack Software 0
PQ Systems Data Entry Workflows with SQCpack Using SQCpack Software 0
PQ Systems Data Security in the Quality Industry Using GAGEpack Software 0
B Establishing a Data Analysis Procedure ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
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 to upload data in bulk on EUDAMED? EU Medical Device Regulations 13
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 6
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

Similar threads

Top Bottom