Random Sample

Follow
Betty Modi

Is there a way to get 20% of the population as Random Sample in datameer. I used RAND()  and put a filter but that gives only count. What if I want a percentage of the total Population as Random sample

0

Comments

1 comment

Date Votes
  • Alan Mark

    Hi Betty,

    First, create a column with RAND() in it to generate a column of random values.

    Since RAND() generates a number between 0 and 1, you can use this column as a comparative column to determine if you're above or below 20%.

    So, you can use it with an IF statement like so:

    IF(#RANDCOLUMN <= 0.20; #PopulationColumn; '')

    Basically, IF the randomly generated number is less than or equal to 0.20 (20%) THEN use your PopulationColumn, else null(two single quotes).

    From there you can put a filter on the new generated column from your if statement to remove null values to get a randomly sampled population of values.

    Alan

    1
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post