Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Add the BANG function for statistics Please

The ! (pronounced BANG) function is useful in statistics. If for example I
have 5! it means 5*4*3*2*1. When calculating odds it is a slick way of making calculations less complex.

1 vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Rob S shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Rob S commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

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

  • Kenneth Barber commented  ·   ·  Flag as inappropriate

    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.

  • Rob S commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base