Create a Front Load & Backload Distribution

[mjohnston0209]

My goal is to create a front loaded and back loaded distribution based on variable dates and dollar values.

What I envision is distributing a dollar value based on a variable number of months and on if a front loaded distribution or back loaded distribution is selected. I found a file on a previous thread that does a great job for a normal distribution. I hope it can be tweaked for either of the other two types of distribution mentioned above. Attached is a pic of the file I found and the formula used in Cell B8.

Thanks!

 

[KRice]

When you describe the distribution as front or back loaded, are you looking for a distribution that has tails at both ends, but shifted toward one side or the other, or do you want a distribution with little to no tail on one side or the other? The first would resemble a skew normal distribution; while the latter would resemble a beta distribution.

For example, the skew normal distribution described here...

Skew normal distribution - Wikipedia

en.wikipedia.org

...will typically give tails on both sides of different "lengths".

And the beta distribution, as described here...

Beta Distribution — Intuition, Examples, and Derivation

When to use Beta distribution

towardsdatascience.com

....could be shifted from one side to the other with only one tail.

Let me know and I'll have a look at adapting the preferred option to your problem.

 

[mjohnston0209]

When you describe the distribution as front or back loaded, are you looking for a distribution that has tails at both ends, but shifted toward one side or the other, or do you want a distribution with little to no tail on one side or the other? The first would resemble a skew normal distribution; while the latter would resemble a beta distribution.

For example, the skew normal distribution described here...

Skew normal distribution - Wikipedia

en.wikipedia.org

...will typically give tails on both sides of different "lengths".
View attachment 75200
And the beta distribution, as described here...

Beta Distribution — Intuition, Examples, and Derivation

When to use Beta distribution

towardsdatascience.com

....could be shifted from one side to the other with only one tail.

View attachment 75199
Let me know and I'll have a look at adapting the preferred option to your problem.

Looking for a skewed distribution! Just not sure how to incorporate that into the formulas I already have.

 

[KRice]

Compare the purple curve in the skew normal to the red curve in the beta...note the skew normal has a small tail on the left, while the beta has none. So the skew normal will ramp up more slowly than the beta. Both are skewed, but one has a tail of different lengths on both ends, while the other has only one tail.

 

[mjohnston0209]

Compare the purple curve in the skew normal to the red curve in the beta...note the skew normal has a small tail on the left, while the beta has none. So the skew normal will ramp up more slowly than the beta. Both are skewed, but one has a tail of different lengths on both ends, while the other has only one tail.

Both tails is the desired result. I tried using that add-in. I installed it last night, but the button to copy the data was grayed out.