Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random number generator | Excel Worksheet Functions | |||
Random Name Generator | Excel Worksheet Functions | |||
Random alpha generator | Excel Worksheet Functions | |||
Random number generator | Excel Worksheet Functions | |||
Random # Generator | Excel Worksheet Functions |