Hi,
Hope this is not an off topic subject - Is there an excel function for calculating odds? I need to calculate the probability of hitting 5 balls in a 37 ball lottery where 6 balls are chosen.
Sorry if this is off topic (ducking under the desk)
Thank you.
Jack Black
Yes, it can, but you'd need to know what the calculation would be and then convert it to a formula. There's nothing built into Excel that automatically deals with odds.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The only way I know how to state the calculation is how I described it. Should I try a maths forum instead? Thanks for the quick reply.
What you described is not a calculation. Yes, a maths forum is where you would normally ask how to CALCULATE odds. Once you know how that is done, you can bring the equation here and ask how it can be done with a formula.
If you get lucky, one of our experts who happens to be a maths guru may see this and help you out.
Thanks. I will wait and see if I get lucky.
You'd better hope Mr Shorty sees this, but as I believe he's based Stateside, he may not be around for a few hours yet.
In the meantime, do a bit of homework: https://www.wikihow.com/Calculate-Odds
Thanks AliG but I will wait to see if Mr Shorty sees this post. I have a creative mind not a mathematical mind.
Not up for a challenge, then? I'm a linguist, however I'd have got stuck in and tried to work it out, but then that's just me. I like to keep my brain active. If I had time, I'd probably try to work it out for you, but sadly I don't today.
Mr Shorty is usually here mid to late afternoon my time - so in 3-4 hours' time, roughly.
Oh, I am always up for a challenge. But this MrShorty is short on time right now
Well, if you need to know now ...
https://www.easysurf.cc/lotodd.htm
Fantastic. Thanks a lot. Should have known there was a calculator like that (giving myself a facepalm).
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Here it is on an Excel sheet, too, FWIW...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Good stuff, Glenn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks