% Distribution

[coleit]

Hi

I have a distribution question, I have this split over 10 qtrs, 100% total, which creates a bell curve

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Quarter[/TD]
[TD]% Split[/TD]
[/TR]
[TR]
[TD]Q1
[/TD]
[TD]4%[/TD]
[/TR]
[TR]
[TD]Q2[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]Q3[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]Q4[/TD]
[TD]12%[/TD]
[/TR]
[TR]
[TD]Q5[/TD]
[TD]13%[/TD]
[/TR]
[TR]
[TD]Q6[/TD]
[TD]13%[/TD]
[/TR]
[TR]
[TD]Q7[/TD]
[TD]12%[/TD]
[/TR]
[TR]
[TD]Q8[/TD]
[TD]11%[/TD]
[/TR]
[TR]
[TD]Q9[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]Q10[/TD]
[TD]4%[/TD]
[/TR]
</tbody>[/TABLE]


What I would like to do is evenly distribute the % for the 10 qtrs into 11 qtrs, keeping to the 100% total and keeping to bell curve profile.

Any help appreciated.

Thanks.

 

[oldbrewer]

is this normal distribution data or have you just put numbers in that make a type of bell curve

(bell curves can be tall and thin or short and fat)

 

[oldbrewer]

A normal distribution in a variate

with mean

and variance

is a statistic distribution with probability density function
[TABLE="width: 100%, align: center"]
<tbody>[TR]
[TD="align: left"]

[/TD]
[/TR]
</tbody>[/TABLE]
this might help......

 

[coleit]

is this normal distribution data or have you just put numbers in that make a type of bell curve

(bell curves can be tall and thin or short and fat)

I just put the numbers in.

 

[coleit]

A normal distribution in a variate

with mean

and variance

is a statistic distribution with probability density function
[TABLE="width: 100%, align: center"]
<tbody>[TR]
[TD="align: left"]

[/TD]
[/TR]
</tbody>[/TABLE]
this might help......

To be honest this doesn't help me, what I need is an Excel formula or some VBA code - thanks anyway.