avedev(value
+)
Returns the average of the absolute deviation of a sample from the mean. Formula is: (Σ|x - average|)/n.
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams2"):
avedev("exams2"!$A:$A) = 2.16
avedev("exams2"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)
stdev(value
+)
Returns the standard deviation of its arguments. Formula is: √((Σ(x - average)²)/(n - 1)).
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams3"):
stdev("exams3"!$A:$A) = 2.774
stdev("exams3"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)
var(value
+)
Returns the variance of its arguments. Formula is: (Σ(x - average)²)/(n - 1).
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams4"):
var("exams4"!$A:$A) = 7.69999999
var("exams4"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)
max(value
+)
Returns the maximum of its arguments. Returns 0 if all its arguments cannot be converted to numbers.
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams5"):
max("exams5"!$A:$A) = 15
max("exams5"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)
min(value
+)
Returns the minimum of its arguments. Returns 0 if all its arguments cannot be converted to numbers.
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams6"):
min("exams6"!$A:$A) = 8
min("exams6"!$A$1:$A$1) = 0
min("exams6"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)
average(value
+)
Returns the arithmetic mean of its arguments.
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams7"):
average("exams7"!$A:$A) = 10.8
average("exams7"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)
count(value
+)
Counts its arguments which can be converted to numbers.
If an argument is an XML nodeset, each node in the nodeset is converted to a number and processed. Nodes which cannot converted to numbers are simply ignored.
If an argument is not a XML nodeset and cannot be successfully converted to a number, an error is reported.
Examples (the above XHTML table has attribute id="exams8"):
count("exams8"!$A:$A, 0, 20) = 7
count("exams8"!$A:$A, "French") = ERROR (String "French" is ignored in column $A but not when passed directly as an argument)