Proportionally weighted random generator?
make a copy of your list with each entry separate
four separate listings of page 1 from your example
next to this column enter = rand() copy and paste in the cells next to each
page listing
select both columns and sort based on the rand() column
If you are willing to check page 1 more than once just take the top or
bottom number of cells to check
if you just want the selection to have mulitple chances and you only want to
test page1 oncejsust select the top unique numbers in your list. there are
many ways ot do this.
"WildlyHarry" wrote:
I have a set of data that contains page numbers from a report that I run.
These page numbers can appear multiple times in any given report based on
activity on that page. I run a frequency of the number of times a given page
appears. I would like to take a random sampling of this report for audit
purposes, but I would like the random sample to be propotionally weighted
based on the frequency a page appears on my reports. For example if ten page
numbers appear on my report, but page number 1 appears four times. I want
page number 1 to be weighted in such a way that it is four times as likely to
appear on my random sampling. Is there anyway to set a up a generator to
make this happen? Thanks in advance.
|