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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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