iSixSigma

Normsinv

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #53978

    what is the solution if normsinv

    9100%) is #num eror

    0
    #192414

    Gary Cone
    Participant

    You are asking Excel to tell you the z value where everything is included (100%). I theory that value is infinity, that’s what the error is telling you. You also don’t use a percentage in Excel, you you use a proportions – 100% would be 1.

    To see what Excel is doing, put in values of .01 and .99 then .05 and .95, then .1 and .9, …

    You will understand the function, but Excel will never be able to figure out infinity.

    0
    #192416

    MBBinWI
    Participant

    You can use the % or use decimal representations, Excel will interpret either correctly. You can also add as many 9’s as you’d like and Excel will return the proper value. However, as Gary states, 100% (or 1.0) is infinity and therefore cannot be solved.

    0
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.