Page 41 - Industrial Process Plant Construction Estimating and Man Hour Analysis
P. 41

Introduction to construction statistics using Excel Chapter  1 11


             1.5.3  Excel functions
             Excel provides the following functions for the correlation coefficient and coef-
             ficient determination:
                CORREL (R1, R2) ¼correlation coefficient of data in arrays R1 and R2
                CORREL (R1, R2)^2 ¼coefficient determination
   36   37   38   39   40   41   42   43   44   45   46