# Excel version of Skewed Normal Cumulative Distribution Function

I'm trying to deskew some distributions based on checks that verify Skew and Kurtosis and within range, if not, I was going to attempt to deskew the data.

On wikipedia, there's a mathematical notation for the CDF of a skewed distribution.

Could someone show me how this would be setup in excel?

http://en.wikipedia.org/wiki/Skew_normal_distribution

Also, anyone know how this varies from a Box Cot estimated lambda distribution transformation?

The skew distribution curve is $$f(\alpha,x)=2 \phi(x) \Phi(\alpha x)$$
Where (in almost-Excel) $$\phi(x)=normal~distribution(x)=norm.dist(x,0,1,False)$$ and $$\Phi(x)=cumulative~normal~distribution(x)=norm.dist(x,0,1,True)$$
So combined, we get (still in almost-Excel) $$f(\alpha,x)=2*norm.dist(x,0,1,False)*norm.dist(\alpha*x,0,1,True)$$