View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dzd&confused dzd&confused is offline
external usenet poster
 
Posts: 1
Default Pull a Sample from a Population

I need a statistically valid, randomly selected breakout of transactions from
a total population of all transactions. Would like to have Excel generate a
statistically valid list from a total population of about 38K transactions.
All 38K transactions, regardless of dollar value, are subject to review
through random selection based on the n of total population. The list should
also incude any transaction = $5,000. The listing should include all data
elements of the select transactions.

Possible? How?