calcuculating the normal distribution of a column as an output in a new column

[CamodCPA]

Hello all,

I am trying to complete some work previously done in excel--in Alteryx.

I have run across the data investigation distribution analysis tool, but I need to export this file as an excel output and need the records in tabular format.

I have a simple set of data per employee. Like this

Employee	Count
b	6
c	7
d	1
e	2
f	8

and need a simple output of this (similar to the Norm.Dist function in xlxs)

Employee	Count	NormDist
b	6	x
c	7	x
d	1	x
e	2	x
f	8	x

Let me know what you all think!

[jdunkerley79 · Accepted solution]

Three ways I know of:

1. Use the Python Tool. Something like:

from ayx import Package
Package.installPackages(['pandas', 'scipy'])

from ayx import Alteryx
import scipy.stats
df = Alteryx.read("#1")
def addProb(row):
    return scipy.stats.norm(0, 1).cdf(row['Count'])
df['Prob'] = df.apply(addProb, axis=1)
Alteryx.write(df, 1)

2. Use the R Tool (havent written in ages...)

3. <ShamelessPlug> Install Alteryx Abacus functions and then you get a NormDist function </ShamelessPlug>

Attach sample of 1 & 3