rosasellen12
New Member
- Joined
- Oct 20, 2022
- Messages
- 9
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
Suppose I want to compute the maximum probabilities that will not get under the 0.95 limit. The maximum possible combination is 0.95, multiplied in each column displayed in yellow. Therefore, is it possible to calculate it in excel such that each column will be multiplied by different combinations, then it would find the maximum allowable range that would not get under the limit. Also, the numbers on the left would be displayed that it is possible to see the designated numbers in each column that got the lowest number that would not get under the limit.
In this scenario, in order to get the lowest number, x1=5, x2=7 and x3=8 that the yellow cells are multipled to in order to get 0.951, which is not under 0.95.
In this scenario, in order to get the lowest number, x1=5, x2=7 and x3=8 that the yellow cells are multipled to in order to get 0.951, which is not under 0.95.