HELP!!! Randon Sample Generator VARIATION
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: HELP!!! Randon Sample Generator VARIATION

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Boston, MA
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    This is a variation on other randon sampling techniques...

    I have a worksheet with the entire population in Worksheet("SegmentA"), with around 1,000 rows. I have already calculated for the statistically valid sample size "n" and it is in Worksheet("Stats").

    Now, if n=70, how can I generate a subset of
    Worksheet("SegmentA") with only 70 records instead of 1,000?

    The sample data can also be pasted in the same Worksheet("SegmentA"), like in Column R.

    Please? Anyone?

    Thanks,
    Christina

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Boston, MA
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ANYONE???

    I'm really DESPERATE!!!

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-27 13:08, MacroChris wrote:
    This is a variation on other randon sampling techniques...

    I have a worksheet with the entire population in Worksheet("SegmentA"), with around 1,000 rows. I have already calculated for the statistically valid sample size "n" and it is in Worksheet("Stats").

    Now, if n=70, how can I generate a subset of
    Worksheet("SegmentA") with only 70 records instead of 1,000?

    The sample data can also be pasted in the same Worksheet("SegmentA"), like in Column R.

    Please? Anyone?

    Thanks,
    Christina
    Hi Christina:
    Have you tried TOOLS|DATA_ANLYSIS|SAMPLING|Sampling_Method ... Random, Number of samples =70

    and get the output on a specified output range, a New Worksheet Ply, or a new Workbook.

    HTH

    Please post back if it works for you ... otherwise explain a little further and let us take it from there!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Boston, MA
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks, Yogi -

    I have, but the people who will eventually use the model are not really that sophisticated. That's why I need to put a macro in to do it for them systematically.

    Christina

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com