Page 43 - Industrial Process Plant Construction Estimating and Man Hour Analysis
P. 43
Introduction to construction statistics using Excel Chapter 1 13
Excel statistical functions are used to calculate values for data. Set up Tem-
plate 1.
To produce the values, insert the formulas 5AVERAGE (D297-D299),
5ABS (D300-E300), ¼(D300-E300)^2 in cells F619, G619, and H619,
respectively. Insert the ¼AVERAGE (F299-F04) for MAE (cell F307)
and ¼AVERAGE (G299-G304) for MSE (cell G307); then, highlight
the range E300-FG04 and press Ctrl-D.
