Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Adynne
 
Posts: n/a
Default binomial distribution

How do I generate observations using binomial distribution? Pls help.
  #2   Report Post  
hgrove
 
Posts: n/a
Default


Adynne wrote...
How do I generate observations using binomial distribution? Pls help.


N trials would require N separate cells. Each trial has an independent
probability of success of p, with 0 < p < 1. So if you want simulated
counts of successes, you'd need to enter the formula =RAND() in an
N-cell range named Trials , then generate your sample values using the
formula

=COUNTIF(Trials,"<="&p)

There's no way to do this in a single cell formula using only built-in
functions.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=275794

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
how do i draw a distribution chart in excel travish19 Charts and Charting in Excel 3 January 15th 05 02:18 AM
bell-shape normal distribution curve SM Charts and Charting in Excel 6 December 11th 04 09:29 PM
Distribution Graph Eran Raizman New Users to Excel 1 December 3rd 04 10:05 PM
Forced Distribution Mark Excel Worksheet Functions 3 November 3rd 04 12:43 AM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"