statistics - Excel: Simulate random sample of integers with given mean, sd, skewness and kurtosis -



statistics - Excel: Simulate random sample of integers with given mean, sd, skewness and kurtosis -

not sure if possible in excel: need simulate sample of random integers (between 1 , 5) fixed mean, standard deviation, skewness , kurtosis. far i've come across =norm.inv(rand(),mean,sd) generate distributed data.

once you've identified distribution want, need obtain quantile function distribution.

if not available straight in excel, code in vba.

then utilize function rand , utilize input quantile function.

the resulting random numbers distributed correctly.

excel statistics

Comments

Popular posts from this blog

c - Compilation of a code: unkown type name string -

java - Bypassing "final local variable defined in an enclosing type" -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -