distributions

Does Excel have functions that will enable me to calculate Z scores for Normal distributions that are not symmetrical? Suppose I have all of the data for all of the major league baseball teams going back over 100 years. Suppose I want to calculate the mean and std dev for win streaks of various...

Hello everybody, I'm using the NORMINV() function to calculate likely random outcomes of specific variables in a Monte Carlo simulation. (Modeling this after the example from the excellent book, How To Measure Anything.) However, NORMINV() uses standard distribution. What if my distribution is...

Hello all, I have a situation where I want to be able to calculate the XIRR of given distributions, combined with proceeds of a potential sale. In order to correctly calculate the XIRR, I have to create a new row that has all distributions to date and also the proceeds dictated by that given...

Hello, Im trying to find the ability/process to draw a curve and then obtain tabular forms of the probability distribution of that curve for X = 1 to 60 (1 month to 5 years). Once i have those 60 probability distributions i would apply a total revenue figure over that distribution to timephase...