• 0

# Norm.Dist function from Excel

## Question

Can anybody share Caspio solution for Norm.Dist function from Excel?

## Recommended Posts

• 0

Hi there,

You can create an equivalent of Norm.Dist function by using the calculated field which is available on Report type of Datapage.

I have this T-SQL example as a guide.

I have created my example based on Details page.

Your table needs to have following values:

1. Sigma;

2. Mean;

3. Value;

and following set of calculated fields:

1. @x

Expression: (([@Value] - [@Mean]) / [@Sigma])

2. @Z

Expression: (ABS( [@calcfield:@x] ) / SQRT( 2.0 ))

3. @t

Expression: (1.0 / (1.0 + 0.5 * [@calcfield:@Z]))

4. @ans

Expression: [@calcfield:@t]*exp(-[@calcfield:@Z]*[@calcfield:@Z]-1.26551223+[@calcfield:@t]*(1.00002368+[@calcfield:@t]*(0.37409196+[@calcfield:@t]*(0.09678418+[@calcfield:@t]*(-0.18628806+[@calcfield:@t]*(0.27886807+[@calcfield:@t]*(-1.13520398+[@calcfield:@t]*(1.48851587+[@calcfield:@t]*(-0.82215223+[@calcfield:@t]*0.17087277)))))))))/2.0

5. normdist (output)

Expression:

case
when [@calcfield:@x] <= 0 then [@calcfield:@ans]
else 1 - [@calcfield:@ans]
end

You may refer to my DP for more details.

Regards,

vitalikssssss

##### Share on other sites

• 0

You can also refer to this link on how to create a calculated field in a Report DataPage https://howto.caspio.com/datapages/datapage-components/calculated-values/

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible. ×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.