How to apply a normal distribution to a value

[Francisco Ortega]

I would like to apply a normal distribution to a value. That is for example that I have an amount of cost of 10 dollars, so my question is how to create a formula that then distributes that cost in a way that looks as a normal distribution for a specified period of time, lets say in this case 6 months. How can I do that?

 

[Chihiro]

Not sure what you are after.

I'd recommend uploading sample workbook demonstrating your data and out put (out put should be created manually, if necessary as an image).

See if link helps you.
http://www.exceluser.com/formulas/statsnormal.htm

 

[bosco_yip]

Something like this,

1] Adding 2 helper rows

2] "random no.", in C3 formula copy across

=RAND()

3] "weighting", in C2 formula copy across

=RANK(C3,$C$3:$H$3)

4] "Monthly distribution", in C5 formula copy across to G5

=ROUND(C2/SUM($C$2:$H$2)*$B5,1)

4] "Last month distribution", in C5 formula copy across to G5

=B5-SUM(C5:G5)

5] See attachment

p.s.

1] Hide 2 helper rows if you needed.

2] Press F9 for data renew.

Regards
Bosco