franzpeter
New Member
- Joined
- Apr 5, 2018
- Messages
- 4
Hello,
unfortunately it is not possible to upload a file, so I try to explain it as best as I can:
I use =NORM.INV to produce columns of random values like:
<tbody>
</tbody>
Each column represents a curve in a diagram that is always updated, if F9 is pressed.
<tbody>
</tbody>
It would be great, if you have some hints how the tasks could be solved (hints on single tasks are also welcome of course .... so that I can put it all together).
If you need the file please let me know how I could send it ...
Best Regards ...
unfortunately it is not possible to upload a file, so I try to explain it as best as I can:
I use =NORM.INV to produce columns of random values like:
Values | Values | Values | Values | Values | Values | Values | Values | Values | Values |
26.8538815 | 5.45631173 | -51.0077324 | 79.4960151 | 39.7611752 | -5.85417276 | 0.19933706 | 36.3109158 | -55.9130755 | -46.7417441 |
19.0776181 | 64.8366344 | -44.4498798 | 8.03219761 | -73.8140031 | 10.2904382 | -42.6979209 | 6.03050914 | 58.5401413 | -56.3084451 |
4.39047624 | 59.9762818 | 40.6865279 | -44.8519101 | 47.4748356 | 55.2761705 | -43.4841945 | -34.0451411 | 40.9571417 | 75.5229871 |
44.7989651 | -56.3868303 | 8.22514414 | -36.3734794 | 119.625039 | 149.910503 | 29.3530674 | 25.6213267 | 55.5856752 | -3.09640204 |
21.7888541 | 22.6155273 | -71.7567003 | -30.3726047 | 7.35397868 | -37.6750579 | 36.2415254 | -50.6866414 | -7.07544591 | 83.0755513 |
47.6036592 | 94.5247985 | 75.6824659 | -56.3281605 | -67.5962421 | 15.3664056 | 47.7862198 | -51.3547504 | 4.77921981 | -73.7810138 |
107.963969 | -44.7986498 | 19.760799 | 78.366183 | -9.11769394 | 29.7125062 | -68.8502439 | -24.5809575 | 14.4002962 | 20.2050168 |
0.99586994 | 94.2060914 | 86.806993 | 42.2206337 | 84.0763841 | 29.8304161 | -87.7718429 | 39.3643671 | 37.2497699 | 75.1516207 |
67.2919977 | -36.2620536 | 53.2990103 | 44.1607761 | -20.9931005 | 23.5962428 | -21.414425 | -4.17458175 | 29.7556998 | 64.432296 |
9.02666472 | 22.2611111 | 50.6139662 | 20.7483508 | -47.2115601 | 41.1012334 | -30.3950436 | -52.8670562 | 62.9456079 | -42.8888878 |
43.3791379 | 26.7891076 | 8.22455558 | -34.5639249 | -3.28262263 | -22.8775143 | -69.8304546 | -92.9627745 | -14.6273932 | -21.3035731 |
102.232077 | -53.0051999 | 40.8151199 | -67.4846056 | 14.7968863 | 44.1383743 | -81.5909865 | 103.312873 | 78.5493199 | -5.51498408 |
-34.0479123 | -25.885055 | -52.7465259 | 12.7435909 | -43.5573836 | -37.0990157 | -18.4488095 | 63.0978172 | -22.8850337 | -49.3460674 |
79.89857 | 20.1725486 | 116.887492 | 49.1896592 | -46.8293044 | 16.8340522 | 2.30193905 | -25.0458245 | -61.9686291 | 8.34629485 |
<tbody>
</tbody>
Each column represents a curve in a diagram that is always updated, if F9 is pressed.
It would be great, if you have some hints how the following tasks could be solved. | ||||
Task 1: It should be possible to generate thousends of these curves automatically if F9 is pressed without entering thousends of columns manually and without assigning them manually to a diagram after the calculation is finished. | ||||
Task 2: Ideally I can define the number of curves I want manually by entering this numer into a cell and the rest will be done fully automatically after F9 is pressed. | ||||
Task 3: All of these curves should be visible in a diagram, i.e. the diagramm changes dynamically depending on the number of curves calculated. | ||||
For the values in the colums a random generator is used. | ||||
Task 4: It should be possible to define a bernoulli or another distribution and to define the probability of success via cells in the excel sheet (i.e. without using the excel add-ins to avoid manual configuration). | ||||
If F9 is pressed the calculations above are then made based on the selected distribution. | ||||
Task 5: After x (e.g. thousends) of calculations are finished a result list is provided based on conficence levels. | ||||
Example: See right side. | List provided after calculations are finished: | |||
It is not clear how these calculations could be done in Excel and how the confidence levels could be achieved. | Confidence (%) | Threshold +/- 50 | Threshold +/- 100 | Threshold +/- 150 |
50% | 70% | 20% | 10% | |
55% | etc. | etc. | etc. | |
60% | etc. | etc. | etc. | |
65% | etc. | etc. | etc. | |
70% | etc. | etc. | etc. | |
75% | etc. | etc. | etc. | |
80% | etc. | etc. | etc. | |
85% | etc. | etc. | etc. | |
90% | etc. | etc. | etc. | |
95% | 60% | 30% | 10% | |
100% | etc. | etc. | etc. | |
Threshold: The percentage of curves the are between + 50 and -50 or +100 and - 100 etc. relative to the number of curves produced (e.g. 10.000) after F9 was pressed. |
<tbody>
</tbody>
It would be great, if you have some hints how the tasks could be solved (hints on single tasks are also welcome of course .... so that I can put it all together).
If you need the file please let me know how I could send it ...
Best Regards ...