Examples of spreadsheet data used to calculate correlations
Building . | Consumption indicator (litres/user/day) . | Monthly building consumption (m³/month) . | Plumbing fixtures (%) . | Defects (%) . | Average flow rate of plumbing fixtures (L/s) . | Age of the building during measurements (years) . |
---|---|---|---|---|---|---|
I | 61.74 | 12.75 | 6.46 | 3.32 | 0.1006875 | 50 |
II | 54.78 | 52.58 | 4.07 | 3.83 | 0.0140000 | 50 |
III | 29.04 | 163.17 | 13.64 | 8.16 | 0.1376471 | 16 |
IV | 37.20 | 119.58 | 15.07 | 11.99 | 0.1438824 | 43 |
V | 69.33 | 77.00 | 4.31 | 4.08 | 0.0205000 | 26 |
VI | 61.41 | 81.50 | 6.94 | 9.18 | 0.1196620 | 15 |
VII | 21.75 | 70.75 | 7.66 | 6.63 | 0.1065556 | 26 |
VIII | 19.33 | 10.33 | 5.02 | 4.85 | 0.0852143 | 37 |
IX | 24.36 | 10.25 | 2.63 | 1.79 | 0.1970250 | 30 |
X | 16.59 | 245.83 | 34.21 | 46.17 | 0.0773448 | 19 |
Mean | 39.55 | 84.37 | 10.00 | 10.00 | 0.1002519 | 31.2 |
Median | 33.12 | 73.88 | 6.70 | 5.74 | 0.1036216 | 28 |
Variance | 409.85 | 5,653.59 | 88.79 | 171.03 | 0.0030705 | 175.29 |
Std. dev. | 20.24 | 75.19 | 9.42 | 13.08 | 0.0554119 | 13.24 |
Building . | Consumption indicator (litres/user/day) . | Monthly building consumption (m³/month) . | Plumbing fixtures (%) . | Defects (%) . | Average flow rate of plumbing fixtures (L/s) . | Age of the building during measurements (years) . |
---|---|---|---|---|---|---|
I | 61.74 | 12.75 | 6.46 | 3.32 | 0.1006875 | 50 |
II | 54.78 | 52.58 | 4.07 | 3.83 | 0.0140000 | 50 |
III | 29.04 | 163.17 | 13.64 | 8.16 | 0.1376471 | 16 |
IV | 37.20 | 119.58 | 15.07 | 11.99 | 0.1438824 | 43 |
V | 69.33 | 77.00 | 4.31 | 4.08 | 0.0205000 | 26 |
VI | 61.41 | 81.50 | 6.94 | 9.18 | 0.1196620 | 15 |
VII | 21.75 | 70.75 | 7.66 | 6.63 | 0.1065556 | 26 |
VIII | 19.33 | 10.33 | 5.02 | 4.85 | 0.0852143 | 37 |
IX | 24.36 | 10.25 | 2.63 | 1.79 | 0.1970250 | 30 |
X | 16.59 | 245.83 | 34.21 | 46.17 | 0.0773448 | 19 |
Mean | 39.55 | 84.37 | 10.00 | 10.00 | 0.1002519 | 31.2 |
Median | 33.12 | 73.88 | 6.70 | 5.74 | 0.1036216 | 28 |
Variance | 409.85 | 5,653.59 | 88.79 | 171.03 | 0.0030705 | 175.29 |
Std. dev. | 20.24 | 75.19 | 9.42 | 13.08 | 0.0554119 | 13.24 |