cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
nac
nac
Level III

create big data set from small sample data set

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

Re: create big data set from small sample data set

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.

View solution in original post

2 REPLIES 2

Re: create big data set from small sample data set

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.
nac
nac
Level III

Re: create big data set from small sample data set

Thank you ;)