Forum Discussion
Summing Cells to Equal a Certain Value
Hi there, I'm in the process of creating a decision analytic model on Excel. As part of the model, I need to calculate values along the normal distribution curve for the three measured outcomes w...
Forcing a summation equal to 1 should mean the base values (the outcomes from your model) would change as well.
I believe your reference values somewhere in your calculation is being rounded which tends to give this kind of error in modelling.
On certain cases, I have seen the excel values for normal distribution deviates a little bit at the 3rd or 4th decimal place. Are you taking this in to account? Refer online sources to validate your results on excel.
I believe your reference values somewhere in your calculation is being rounded which tends to give this kind of error in modelling.
On certain cases, I have seen the excel values for normal distribution deviates a little bit at the 3rd or 4th decimal place. Are you taking this in to account? Refer online sources to validate your results on excel.