[vpFREE] Re: Using Excel

 

bl, this function will give you the probability of catching a certain number of picks:


=HYPGEOMDIST(Caught,20,Picked,80)

You replace "Caught" and "Picked" in that function with the actual numbers you are interested in.   For example, if you want to know the chance of catching 10 when you pick 15, you'd use:
=HYPGEOMDIST(10,20,15,80)
 
Better yet, you can give two other cells the names "Caught" and "Picked", and then enter the numbers of interest into those cells.   Then =HYPGEOMDIST(Caught,20,Picked,80) will update every time you change the values in the 'Caught' and 'Picked' cells.

I got that function from this link:


--Dunbar


---In vpFREE@yahoogroups.com, <bornloser1537@...> wrote :

A while ago, there was a discussion concerning a function in excel that could be used for computing Keno statistics. Can someone direct me to the thread?  Thank you.


..... bl


 

__._,_.___
Posted by: h_dunbar@hotmail.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___