How can I generate a simulated database

madhu — Sat, 10 Jun 2023 23:56:11 GMT

I need to generate a large database through simulation in JMP Pro 16. It could follow any probability distribution. Can anybody help?

Re: How can I generate a simulated database

txnelson — Fri, 28 Oct 2022 21:37:53 GMT

I see from your previous discussion item that other members have pointed you to the random number functions available in JMP. I assume that from your repeating of the question, you are not capable of expanding on the information they provided, into the creation of a data table. Below is a simple sample of a script that produces a data table with 2 columns with 2 different distributions used for the 2 columns. This should give you a big leg up on expanding the JSL to what you specifically need.

names default to here(1);
dt=new table("Simulated",
	add rows(1000),
	new column("col 1",
		set each value(random uniform(1,1000000)) // range of values from 1 to 1,000,000
	),
	new column("col 2",
		set each value(random normal(200, 15)) // mean of 200, std of 15
	)
);

// There are many other distributions that can be generated

Re: How can I generate a simulated database

madhu — Sat, 29 Oct 2022 00:25:41 GMT

Great, this works. Thank you

topic Re: How can I generate a simulated database in Discussions

How can I generate a simulated database

Re: How can I generate a simulated database

Re: How can I generate a simulated database