Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2002
    south bend, Indiana, USA
    Thanked 0 Times in 0 Posts

    stratified lottery (2003)

    Here's what I need to do. We are mandated by law to hold an lottery for admission. It needs to be stratified (weighted) to maintain racial/gender balance to the sourrounding areas. Currently we do this by hand, Pulling a number, then checking ethnicity and sibilings, writing o paper until we reach that goal. If the goal cannot be reached using the process, then all remaining entrants are placed depending on the order they were pulled.
    The remainder applicants are then placed on a waiting list.

    I would like to create a spread sheet where all applicants can be randomly pulled based on the criteria, to make it weighted. HOw do I do that in excel?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: stratified lottery (2003)

    > HOw do I do that in excel?

    You already posted that question in Excel: <post:=566,530>post 566,530</post:>, so I will lock this thread.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts