Skip to main content
michelled19159583
michelled19159583
Known Participant
June 6, 2017
Question

Custom Calculation Script - Standard Deviation

  • June 6, 2017
  • 4 replies
  • 3944 views

I am having trouble creating a Custom calculation script in my Adobe Acrobat XI Standard. I have a table with fields row_1, row_2, row_3, row_4, row_5, row_6, row_7, row_8, row_9, row_10, row_11, row_12, row_13, row_14, row_15. I have a field that already calculates the mean, that field name is mean. So far I have been able to create this but it does not work:

sqrt(((((row_1-mean)^2)+((row_2-mean)^2)+((row_3-mean)^2)+((row_4-mean)^2)+((row_5-mean)^2)+((row_6-mean)^2)+((row_7-mean)^2)+((row_8-mean)^2)+((row_9-mean)^2)+((row_10-mean)^2)+((row_11-mean)^2)+((row_12-mean)^2)+((row_13-mean)^2)+((row_14-mean)^2)+((row_15-mean)^2)))/15)

This topic has been closed for replies.

4 replies

michelled19159583
michelled19159583Author
Known Participant
June 8, 2017

Update:

This is the current script I have and it works properly to calculate the Population Standard Deviation:

var average = this.getField("mean").value;
var v = 0;
var fieldName = new Array("row_1", "row_2", "row_3", "row_4", "row_5", "row_6", "row_7", "row_8", "row_9", "row_10", "row_11", "row_12", "row_13", "row_14", "row_15");
var s = 0;
var sd = 0;
n = 15; //number of fields

for (var i = 0; i < n; i++) {
    v = this.getField(fieldName).value;
    s = s + Math.pow((v - average), 2);
}

sd = Math.sqrt(s / n); //standar deviation
event.value = sd;

However, I need the Sample Standard Deviation. Can anyone help me?

Thanks,

Michelle

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
June 9, 2017

sd = Math.sqrt(s / (n - 1));

michelled19159583
michelled19159583Author
Known Participant
June 6, 2017

Right now this is working separately.

In one form field(Simplified field notation) named MEAN_2 I have:

((((row_1-mean)*(row_1-mean))+((row_2-mean)*(row_2-mean))+((row_3-mean)*(row_3-mean))+((row_4-mean)*(row_4-mean))+((row_5-mean)*(row_5-mean))+((row_6-mean)*(row_6-mean))+((row_7-mean)*(row_7-mean))+((row_8-mean)*(row_8-mean))+((row_9-mean)*(row_9-mean))+((row_10-mean)*(row_10-mean))+((row_11-mean)*(row_11-mean))+((row_12-mean)*(row_12-mean))+((row_13-mean)*(row_13-mean))+((row_14-mean)*(row_14-mean))+((row_15-mean)*(row_15-mean)))/15)

In another form field(Custom calculation script) I have:

event.value = Math.sqrt(this.getField("MEAN_2").value) ;

The second one correctly outputs the Standard deviation of the mean. But, I would like to not have two form fields. All I need is the standard deviation of the form field mean. But for some reason stdev(mean) wont work.

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
June 6, 2017

In the simplified field notation you can only use the operators + - * /

You must change the whole code to JavaScript.

    michelled19159583
    michelled19159583Author
    Known Participant
    June 7, 2017

    Hi Bernd. Do you have any idea of how I could change the entire thing to JavaScript?

    So far, I have a "Value is the average" in one form field which creates the mean, this form field is labeled 'mean'. In the next form field I have a "Simplified field notation" : ((((row_1-mean)*(row_1-mean))+((row_2-mean)*(row_2-mean))+((row_3-mean)*(row_3-mean))+((row_4-mean)*(row_4-mean))+((row_5-mean)*(row_5-mean))+((row_6-mean)*(row_6-mean))+((row_7-mean)*(row_7-mean))+((row_8-mean)*(row_8-mean))+((row_9-mean)*(row_9-mean))+((row_10-mean)*(row_10-mean))+((row_11-mean)*(row_11-mean))+((row_12-mean)*(row_12-mean))+((row_13-mean)*(row_13-mean))+((row_14-mean)*(row_14-mean))+((row_15-mean)*(row_15-mean)))/15). This is part of the equation to find the standard deviation, this second form field is labeled 'MEAN_2'. In the third and final form field I created a "Custom calculation script" : event.value = Math.sqrt(this.getField("MEAN_2").value) ;. That last script takes the square root of the form field MEAN_2, thus giving me the standard deviation. Any idea of how I can combine them all into one?

    try67
    Community Expert
    try67Community Expert
    Community Expert
    June 6, 2017

    And here you can learn how to perform basic mathematical operations (like square root and power) in JS: JavaScript Math Object

      michelled19159583
      michelled19159583Author
      Known Participant
      June 6, 2017

      My issue isn't writing the actually code. I just cannot seem to get any of them to actually work within Adobe Acrobat. For example, if I want the Standard Deviation of the field name mean. Example: stdev(mean). This will not work in the Custom calculation script. Can you please help me. am I missing something in front of the code?

      try67
      Community Expert
      try67Community Expert
      Community Expert
      June 6, 2017

      Why would it work? Did you create a function called stdev? There's no such function built-in to JavaScript or Acrobat, so there's no reason to assume it will magically work...

        Bernd Alheit
        Community Expert
        Bernd AlheitCommunity Expert
        Community Expert
        June 6, 2017

        You must change your code.

        E.g. you will get value of field row_1 with:

        this.getField("row_1").value

          michelled19159583
          michelled19159583Author
          Known Participant
          June 6, 2017

          What must I change it to? I am stuck. row_1, row_2, etc. are imputed values that the user manually enters. My issue is I need to find an equation that will work in Adobe Acrobat that finds standard deviation of a set of numbers. Do you know how to do this?

          Terms & ConditionsAccessibility statement
          Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices