Posted to microsoft.public.excel.programming

Diogo

external usenet poster

Posts: 19

Sample a random calculated cell

Hi

Need help with the following:

I've a cell that is calculated with the random function

I need a procedure that simulates me hiting the F9 button and copying the
result to a column so I can make a statistic to see how many values are above
a certain value? lets say I need 100 values to have a representative sample.
How can I make this?

Please help. Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I random sample from a set until every sample is selected?	random sampling	Excel Discussion (Misc queries)	6	April 26th 10 09:54 PM
Random Sample	Funkyfido	Excel Worksheet Functions	2	September 22nd 08 11:09 AM
How do I make a random sample?	Confused student	Excel Discussion (Misc queries)	4	April 25th 08 04:12 PM
random sample	skimpw	Excel Worksheet Functions	0	August 15th 06 01:15 AM
Random Sample Without Duplication	beccadawn0622	Excel Discussion (Misc queries)	3	January 25th 06 02:13 PM

All times are GMT +1. The time now is 02:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us