questionfor.info's home » Microsoft »» Microsoft Excel

Drawing Sample (Microsoft Excel Question)


Fri, 23 May 2008 18:03:00 GMT, 2 comments.

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 assum

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? I

no, how I can write my own function using VBA?

Thanks and Regards

--

Arun Kumar Saha


tags: assum, draw, drawing, excel, members, microsoft, msdn, population, random, replacement, sample, size, software, suppose


  1. 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" <Arun.Kumar.Saha.1961e27.excel.questionfor.info.excelbanter.com> wrote in message

    news:Arun.Kumar.Saha.1961e27.excel.questionfor.info.excelbanter.com...

    > 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

  2. Hello,

    I suggest to take my UDF redw:

    http://www.sulprobil.com/html/redw.html

    Regards,

    Bernd

Hot Articles & Questions on "Microsoft Excel"

Browse Topic


©excel.questionfor.info, All Rights Reserved. [46.88]