Add the BANG function for statistics Please
The ! (pronounced BANG) function is useful in statistics. If for example I
have 5! it means 54321. When calculating odds it is a slick way of making calculations less complex.
Hi,
This is already supported. Check out the =FACT function.
Hope that helps,
Dan [MS]
6 comments
Comments are closed
Anonymous commented
"BANG" standing for what? I always knew as factorial.

Rob S commented
Thanks Dan. Didn't realize. Years and years ago my math prof used the word BANG and that's what I had in my head. Never considered it was the wrong word. In an equation is it still represented as an EXCLAMATION POINT?

Anonymous commented
Thanks Ken. For the Excel help and for your thoughts on the gambling psyche. It's a mental problem no doubt.

Kenneth Barber commented
Also, part of what draws people to gambling is the possibility of profitting. It might be highly improbable to profit on a game, but it's always possible (assuming that the game isn't rigged). It also doesn't help that news and fiction are filled with stories of people beating the odds with enough persistence and belief in oneself.
I don't know what your friend is like, but if he is insistent on going to the casino, he might deemphasize the times that he loses and emphasize the times that he wins. This is called confirmation bias.
Also, probability can be badly misinterpreted at times. The gambler's fallacy basically means interpreting a "1 in 3 chance" as meaning "every 3 times that I play, 1 of those times will be a win" rather than "every 3 times that I play, I can expect 1 of those to be a win, but there is no guarantee".
There is also the concept of gambling responsibly, where you stop playing after you've lost a certain amount of money that you've previously decided on. If your friend is doing that, you might not have to worry about anything.

Kenneth Barber commented
Most people call the "bang" function the "factorial" function. Use Excel's FACT function.

Rob S commented
I am trying to convince a friend to stop going to the casino. Being a numbers guy I show him his statistical likelihood of winning each game. Needless to say winning will never be common.