Page 298 - Industrial Process Plant Construction Estimating and Man Hour Analysis

278 Appendix C

Correlation

CORREL (R1, R2)¼correlation coefficient of data in arrays R1 and R2
^
CORREL (R1, R2) 2¼coefficient determination
The Mean, Variance and Standard Deviation Measures of Central
Tendency AVERAGE (number 1, number 2): Returns the average (arithmetic
mean) of its arguments, which can be numbers or names, arrays, or references that
contain numbers.
VAR (number 1, number 2): estimates variance based on a sample (ignores

logical values and text in the sample Math & Trig function Math Formulas).
STDEV (number 1, number 2): estimates standard deviation based on a
sample (ignores logical values and text in the sample Math & Trig function
Math Formulas). To use the Math Formulas, go to quick access toolbar; select
Math & Trig, and then, select SUMPRODUCT SUMPRODUCT¼returns
the sum of the products of corresponding ranges or arrays; arrays 1, 2, and 3
are 2–255 arrays for which you want to multiply and then add components.
All arrays must have the same dimensions.
LOG¼returns the logarithm of a number to the base you want the
logarithm.
Number is the positive real number for which you want the logarithm.
SQRT¼returns the square root of a number. Number is the number for
which you want the square root.