I would like help distributing a set number of percentages which equal 1 over a dynamic number of periods.
For example: My Array of Period Percents = MyValArray(.05,.05,.05,.05
However, the number of days in my new values is not 10 but 18 days. How do I convert the above percentages to distribute the same way (however diluted) over the 18 days? I am hoping there is a distribution or other statistical formula in excel that I will be able to use. Also, I might also have the opposite problem where I am distributing over less than 10 periods. For example: I know that if I shortened my time period to 5, my values would be Period 1: .10, Period 2: .10, Period 3: .15, Period 4: .4 and Period 5: .25 based on the above array however I do not know the formula or the vba code to calculate it. Thank you ahead of time - you guys are great!