title: Front Loaded and Back Loaded | Normal Distribution Column Chart and S Curves in Excel
body: <p>Most of us may be aware of normal distribution curves however those who are new to front-loaded and back-loaded normal distribution, I would like to provide the background and then would proceed on stating my problem.</p>
  
  <hr>
  
  <p><strong>Front-Loaded Distribution</strong>: As demonstrated below, it have a rapid start. For e.g. in a project when more resources assumed to be consumed early in the project, cost/hours is distributed aggressively at the start of project.
  <a href="https://i.stack.imgur.com/2yAEU.png" rel="noreferrer"><img src="https://i.stack.imgur.com/2yAEU.png" alt="Front-Loaded Distribution / S Curve"></a></p>
  
  <hr>
  
  <p><strong>Back-Loaded Distribution</strong>: Contrary to Front-Loaded distribution, it start out with a lower slope and increasingly steep towards the end of the project. For e.g. when most resources assumed to be consumed late in the project.
  <a href="https://i.stack.imgur.com/0PkLr.png" rel="noreferrer"><img src="https://i.stack.imgur.com/0PkLr.png" alt="Rear Load Distribution S Curve"></a></p>
  
  <p>In the above charts, <strong>green line is S-Curve</strong> which represents cumulative distribution (utilization of resources over the proposed time) and the blue Columns represents the isolated distribution of resources (Cost/Hours) in that period.</p>
  
  <hr>
  
  <p>For reference, I am providing the Bell Curve / standard normal distribution (when Mean=Median) chart (below) and the associated formula to begin with.
  <a href="https://i.stack.imgur.com/UaP3J.png" rel="noreferrer"><img src="https://i.stack.imgur.com/UaP3J.png" alt="Normal Distribution S Curve"></a></p>
  
  <hr>
  
  <p><strong>Problem Statement</strong>: I was able to generate the normal distribution curve (See below with formulae) however I am unable to find a solution for Front loaded or Back Loaded curves. </p>
  
  <p><em>How to bring the skewness to the right (front-loaded / positively skewed distribution which means mean is greater than median) and left skewed (back-loaded / negatively skewed distribution which means mean is less than median) in a normal distribution?</em> </p>
  
  <p><a href="https://i.stack.imgur.com/fesb9.png" rel="noreferrer"><img src="https://i.stack.imgur.com/fesb9.png" alt="Gaussian Bell Curve with Excel Formula"></a></p>
  
  <p><strong>Formula Explaned</strong>:</p>
  
  <p><em>Cell B8</em> denotes arbitrarily chosen standard deviation. It affects the kurtosis of normal distribution. In the above screenshot, I am choosing the range of the normal distribution to be from -3SD to 3SD.</p>
  
  <p><em>Cell B9 to B18</em> denotes the even distribution of Z-Score using the formula:</p>
  
  <pre><code>=B8-((2*$B$8)/Period)
  </code></pre>
  
  <p><em>Cell C9 to C18</em> denotes the normal distribution on the basis of Z Score and the Amount using the formula:</p>
  
  <pre><code>=(NORMSDIST(B9)-NORMSDIST(B8))*Amount/(1-2*NORMSDIST($B$8))
  </code></pre>
  
  <hr>
  
  <p><strong>Update:</strong> Following one of the link in comment, I closest got to the below situation. The issue is highlighted in Yellow pattern as due to the usage of volatile Rand() function the charts are not smooth as they should be. As my given formula above do not create ZigZag pattern, I am sure we can have skewed normal distribution and smooth too !
  <a href="https://i.stack.imgur.com/WV2XM.png" rel="noreferrer"><img src="https://i.stack.imgur.com/WV2XM.png" alt="ZigZag Columns Issue in Normal Distribution"></a></p>
  
  <p>Note: </p>
  
  <ol>
  <li><p>I am using Excel 2016, so I welcome if any newly introduced formula can solve my problem. Also, I am not hesitant to use UDFs.</p></li>
  <li><p>The numbers of front-load and back-load distribution are notional. They could vary. I am only interested in shape of resulting chart.</p></li>
  </ol>
  
  <p>Kindly help !</p>