Skip to main content
T
Theo_Gagner10-Marble
10-Marble
November 5, 2018
Solved

Truncate Array to Count out of Range Results | Monte Carlo

  • November 5, 2018
  • 3 replies
  • 3091 views

Hello Community,

 

I have a worksheet running Monte Carlo simulation where I look at the output array and calculate a mean and standard deviation.  I would like to use those results to calculate the number of simulations where the result was out of a range. For example, calculate the number of results than are more than 3 standard deviations from the mean.  I can write "for" loops to do this work, but I feel like there might be a more elegant way to "throw out" out of range elements of an array.

Best answer by Theo_Gagner

Luc, your use of the SUM tool got me thinking of combining it with Booleans operators.

Sum of Boolean.PNG

 

Looks like there is a highly compacted way to do this when we combine both.  Thanks for the feedback!

3 replies

L
LucMeekes23-Emerald IV
23-Emerald IV
November 5, 2018

Yes, there is a smart way, without writing for loops:

LM_20181105_Count.png

Above is the function that counts all values below -0.7.

To count all values above 0.7, change -0.7 to 0.7 and change "lt" to "gt". That results in an error message, because there is no such value. So you have to make sure that there are values in the region you want to count.

 

Success!
Luc

    L
    LucMeekes23-Emerald IV
    23-Emerald IV
    November 5, 2018

    A small improvement:

    LM_20181105_Count.png

    Success!
    Luc

      T
      Theo_Gagner10-MarbleAuthorAnswer
      10-Marble
      November 6, 2018

      Luc, your use of the SUM tool got me thinking of combining it with Booleans operators.

      Sum of Boolean.PNG

       

      Looks like there is a highly compacted way to do this when we combine both.  Thanks for the feedback!

        L
        LucMeekes23-Emerald IV
        23-Emerald IV
        November 6, 2018

        Smart!

        W
        Werner_E25-Diamond I
        25-Diamond I
        November 5, 2018
        For example, calculate the number of results than are more than 3 standard deviations from the mean.  I can write "for" loops to do this work, but I feel like there might be a more elegant way to "throw out" out of range elements of an array.

        If your goal is to just count the out of range elements you may use Lucs method.

        If your goal is to "throw out" those elements and keeps the rest in a smaller vector you may use a combination of "Match" and "trim".

         

        Terms & ConditionsCookie settingsAccessibility statement