climatic graphs excel.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Name:	__________________________				Class:	_________		Date:	_________
2
3	Enter the answers for the boxes in blue. Use the Formulas to calculate the answers for the boxes in yellow.
4
5	Country	Singapore
6
7	Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Oct	Nov	Dec
8	Temperature (°C)	26	26.6	27	27.3	27.5	27.5	27.3	27.2	27	27	26.6	26.2
9	http://www.worldclimate.com/cgi-bin/data.pl?ref=N01E103+1102+48694W
10
11	Highest Temperature:			27.5
12	Lowest Temperature:			26
13	Temperature Range:
14	Average Temperature:
15
16	Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Oct	Nov	Dec	Total rainfall
17	Rainfall (mm)	238.5	165.1	173.6	166.4	170.7	163.1	149.8	171.3	163.5	191	250.1	268.7
18	http://www.worldclimate.com/cgi-bin/data.pl?ref=N01E103+2100+48694W
19
20	Create your graph (Combo chart) on the rainfall and temperature below by highlighting the data and then on chart wizard:
21
22	Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Oct	Nov	Dec
23	Temperature (°C)	26	26.6	27	27.3	27.5	27.5	27.3	27.2	27	27	26.6	26.2
24	Rainfall (mm)	238.5	165.1	173.6	166.4	170.7	163.1	149.8	171.3	163.5	191	250.1	268.7
25
26
27
28										Climatic Type:
29
30										Reason for the Climate type:
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100