Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drawing Sample
Hi all,
I want to draw a random sample [with replacement] of size 10 (suppose) from a population having members : 1, 2, 3, and 4, where I assume following: Probability that 1 will be drawn is : 0.1 Probability that 2 will be drawn is : 0.4 Probability that 3 will be drawn is : 0.4 Probability that 4 will be drawn is : 0.1 Can anyone tell me that : is there any VBA function for doing that? If no, how I can write my own function using VBA? Thanks and Regards, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drawing Sample
Arun Kumar Saha -
Here's a non-VBA solution, using nested IF functions and the cumulative distribution: Enter =RAND() into a cell, e.g., cell A1. In another cell, e.g., B1, enter =IF(A1<=0.1,1,IF(A1<=0.5,2,IF(A1<=0.9,3,4))) Copy A1:B1 and paste into A2:B10. Press F9 to debug. Or, download the tryout version of RiskSim from www.treeplan.com, and use its RANDDISCRETE function. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Arun Kumar Saha" wrote in message ... Hi all, I want to draw a random sample [with replacement] of size 10 (suppose) from a population having members : 1, 2, 3, and 4, where I assume following: Probability that 1 will be drawn is : 0.1 Probability that 2 will be drawn is : 0.4 Probability that 3 will be drawn is : 0.4 Probability that 4 will be drawn is : 0.1 Can anyone tell me that : is there any VBA function for doing that? If no, how I can write my own function using VBA? Thanks and Regards, -- Arun Kumar Saha |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drawing Sample
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sample program | Charts and Charting in Excel | |||
Calculate a sample | Excel Discussion (Misc queries) | |||
The Sample Covariance | Excel Discussion (Misc queries) | |||
SAMPLE FORMS | New Users to Excel | |||
Sample | Excel Discussion (Misc queries) |