Subscribe Bookmark RSS Feed

create big data set from small sample data set

nac

Occasional Contributor

Joined:

Feb 17, 2017

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
markbailey

Staff

Joined:

Jun 23, 2011

Solution

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

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

Capture.JPG

Making this formula is easy:

  1. Select the source data column.
  2. Select Row > Subscript.
  3. Select Random > Random Integer.
  4. Enter 1 for the lower limit.
  5. Click Insert ("^") key.
  6. Enter 10, in your case, 40, in my case for the upper bound.
Learn it once, use it forever!
2 REPLIES
markbailey

Staff

Joined:

Jun 23, 2011

Solution

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

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

Capture.JPG

Making this formula is easy:

  1. Select the source data column.
  2. Select Row > Subscript.
  3. Select Random > Random Integer.
  4. Enter 1 for the lower limit.
  5. Click Insert ("^") key.
  6. Enter 10, in your case, 40, in my case for the upper bound.
Learn it once, use it forever!
nac

Occasional Contributor

Joined:

Feb 17, 2017

Thank you ;)