I've got a doozy for y'all. I want to create a formula that will return a random integer according to a pyramid distribution.
For example, A1 might serve as my input, which is itself a randomized integer, let's call it 24 for now. In B1, then, I want my pyramid formula, which will return a new integer that is + or - 50% of the input, but weighted toward the middle (12 and 36 would each have one chance of appearing, 13 and 35 would each have two chances, 14 and 34 would each have 3, and so on).
The formula needs to be 1) dependent on the variable input, and 2) able to be retooled for a different percentage
WAY too much math for me, but I hope to get some responses to dissect and get a little better at this sort of thing. Thanks a ton!
For example, A1 might serve as my input, which is itself a randomized integer, let's call it 24 for now. In B1, then, I want my pyramid formula, which will return a new integer that is + or - 50% of the input, but weighted toward the middle (12 and 36 would each have one chance of appearing, 13 and 35 would each have two chances, 14 and 34 would each have 3, and so on).
The formula needs to be 1) dependent on the variable input, and 2) able to be retooled for a different percentage
WAY too much math for me, but I hope to get some responses to dissect and get a little better at this sort of thing. Thanks a ton!