Excel allday
New Member
- Joined
- Jul 1, 2013
- Messages
- 1
Hi!
I'm trying to create a table from 5 to 36 columns (months). Each column should add up to 100%. The problem is that in each column I want the distribution of “percentages” to be normally distributed. For instance in colum 7, I need 100% to be close to normally distributed over 7 rows (For example; 6%, 14%, 18%,24%, 18%, 14%, 6%). The same will apply in column 36: A total of 100 % (close to) normally distributed over 36 rows.
Is there any way to write a formula that will be dynamic with a changing number of months?`
Appreciate if anyone can help!
I'm trying to create a table from 5 to 36 columns (months). Each column should add up to 100%. The problem is that in each column I want the distribution of “percentages” to be normally distributed. For instance in colum 7, I need 100% to be close to normally distributed over 7 rows (For example; 6%, 14%, 18%,24%, 18%, 14%, 6%). The same will apply in column 36: A total of 100 % (close to) normally distributed over 36 rows.
Is there any way to write a formula that will be dynamic with a changing number of months?`
Appreciate if anyone can help!
