topic Re: create big data set from small sample data set in Discussions

create big data set from small sample data set

nac — Thu, 16 Mar 2017 12:14:46 GMT

Dear all,

I have 10 sample results. Normally my sample set include 100 sample but before analysing the remaining 90 samples, I want to simulate big data by using 10 sample result. I apply this approach by using SSPS monte carlo simulation but ı do not know how can i create 100 random sample result by using 10 sample result. Is there anyone help me for this.

Re: create big data set from small sample data set

Mark_Bailey — Thu, 16 Mar 2017 13:48:50 GMT

It is simple to do. I am using the Big Class data set from the sample data library.

Select Rows > Add Rows. Add 90 rows in your case. I added 60 to the existing 40 in Big Class.
Select Cols > New Column. I called it Simulated weight for Big Class example.
Add a formula that samples without replacement from the existing variable, weight in this case.

Making this formula is easy:

Select the source data column.
Select Row > Subscript.
Select Random > Random Integer.
Enter 1 for the lower limit.
Click Insert ("^") key.
Enter 10, in your case, 40, in my case for the upper bound.

Re: create big data set from small sample data set

nac — Fri, 24 Mar 2017 10:55:49 GMT

Thank you ;)