Distributing the value of Beginning No. Median Number and Ending No.

[mart_mrexcel]

I have a beginning number of 110, the Ending is 150 and the Median 130. How can I distribute the beginning, Median and ending in 11 column? what is the formula to get the gaps in between 110 to 150 with a median of 130 in 11 columns?

 

[Gerald Higgins]

I think this isn't really an Excel problem, it's a maths problem.

You've basically got 5 increments between start and median, and another 5 between median and end.

So the size of each increment is ([MEDIAN]-[START])/5 or ([END]-[MEDIAN])/5

 

[mart_mrexcel]

I think this isn't really an Excel problem, it's a maths problem.

You've basically got 5 increments between start and median, and another 5 between median and end.


Thanks ...just got one question how did you come up with the 5

 

[Gerald Higgins]

Do you think it should not be 5 ?

 

[mart_mrexcel]

no its not that just trying to figure it out. Thanks anyways

 

[Stiuart_W]

1 2 3 4 5 6 7 8 9 10 11


1 is the start, 11 is the end. 6 is the Median. You can see there are 5 gaps (1 to 2, 2 to 3 etc) so you subtract Median - Start and divide by the number of gaps (5)