Typical Climate Data for Perth Western Australia.
Rainfall in mm. Temperature in Celsius.
Avge Avge Highest Highest Lowest Lowest
MAX MIN MAX MIN MAX MIN
JAN 30.0 18.3 45.8 27.8 19.6 9.2
FEB 30.5 18.7 46.2 29.3 19.0 8.7
MAR 28.6 17.3 42.3 28.3 16.4 7.7
APR 24.6 14.5 37.6 24.4 13.6 4.1
MAY 21.1 11.8 32.4 20.8 11.5 1.3
JUN 18.7 10.4 28.1 18.7 8.8 1.3
JUL 17.7 9.2 26.3 16.1 10.5 0.0
AUG 18.3 9.3 27.8 16.6 9.9 1.4
SEP 19.9 10.3 32.7 19.5 11.4 1.8
OCT 21.9 11.8 37.3 22.2 11.9 2.2
NOV 24.8 14.2 40.3 22.0 14.2 5.6
DEC 27.4 16.5 42.3 27.1 14.9 8.6
Avge
RAIN
8.6
13.3
19.3
45.5
122.7
182.4
172.9
134.6
79.9
54.5
21.7
13.9
CLIMATE AVERAGES - long term mean and record values of weather data 1876 to 1992
PERTH REGIONAL OFFICE Longitude: 115.87 E
Latitude: 31.95 S Elevation: 19.0 m
Commenced: 1876 Last record: 1992 W
State: A
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Mean Daily Max Temp (deg C) 30 30 28 25 21 18 17.4 18 20 21 25 27
C
Mean no. Days, Max >= 40.0 deg 1.1 0.6 0.2 0 0 0 0 0 0 0 0 0.3
C
Mean no. Days, Max >= 35.0 deg 6.3 5.5 2.7 0.3 0 0 0 0 0 0.2 1 3.2
Mean no. Days, Max >= 30.0 deg C15 15 11 3 0.2 0 0 0 0.2 1.5 4.6 8.7
Highest Max Temp (deg C) 45.8 46 42 37 32 28 26.3 27 32 37 40 42
Lowest Min Temp (deg C) 9.7 11 7.8 4.6 3 1.6 2 2.3 2.6 4.2 6.2 8.6
Mean 9am Air Temp (deg C) 23.6 23 22 19 15 13 12.1 13 15 17 20 22
Mean 9am Relative Humidity (%) 50 52 56 64 72 78 78 74 68 60 54 51
Mean 3pm Relative Humidity (%) 41 40 42 48 53 60 59 56 53 50 46 44
Mean Rainfall (mm) 8.6 13 19 46 123 182 173 135 80 55 22 14
Mean no. of Raindays 2.9 2.7 4.3 7.6 14 17 18.2 17 14 11 6.5 4.2
Highest Monthly Rainfall (mm) 115 166 145 149 308 476 425 318 199 200 73 81
Lowest Monthly Rainfall (mm) 0 0 0 0 14 55 61.5 12 8.7 1 0 0
Highest Recorded Daily Rain (mm)55 121 77 67 76 99 95 74 52 55 39 47
Mean no. of Clear Days 16 14 14 8.5 6.4 4.9 4.9 6.7 7.5 8.7 9.7 13
Mean no. of Cloudy Days 2.7 2.8 3.5 5.9 6.6 8.4 7 5.5 5 4.2 3.6 2.7
Mean Daily Sunshine (hrs) 11 10 9 7.3 6 5 5.4 6.4 7.4 8.8 9.9 11
Maximum Wind Gust (km/hr) 89 113 113 130 118 128 137 156 113 117 102 102
Mean Daily Evaporation (mm) 8.1 7.7 6.2 4 2.7 2 2 2.5 3.5 5 6.3 7.5
See the next sheet for ways to summarise and display this data.
Think carefully about whether it makes sense to find the sums or averages of these rows and columns.
Data can be summarised by linking sheets together
This simple example shows how discontiguous data from the previous sheet
can be displayed by itself and more easily graphed.
Look at the formula to see how it works. One cell is linked and then filled across. Very sim
0 JAN FEB MAR APR MAY JUN JUL
Mean Daily Max Temp (deg C) 29.7 30.0 28.0 24.6 20.9 18.3 17.4
Highest Max Temp (deg C) 45.8 46.2 42.3 37.1 31.8 28.1 26.3
Lowest Min Temp (deg C) 9.7 10.6 7.8 4.6 3.0 1.6 2.0
Record Max and Min Temperatures - Perth
50.0
45.0
40.0
35.0
30.0 Mean Daily Max Temp (deg
25.0 C)
Highest Max Temp (deg C)
20.0
15.0
10.0
5.0
0.0
us sheet
filled across. Very simple and very powerful.
AUG SEP OCT NOV DEC
18.0 19.5 21.4 24.6 27.4
27.2 32.3 37.3 40.1 42.3
2.3 2.6 4.2 6.2 8.6
an Daily Max Temp (deg
hest Max Temp (deg C)