Sunday, July 24, 2011

Using Microsoft Excel

Open the link below for the excel sheet: https://spreadsheets.google.com/spreadsheet/ccc?key=0AtUR3aEsvgerdENtUmE5S0N5ZGNueGozb1lqcUVTY0E&hl=en_US

Data on Singapore's temperature from:
http://www.worldclimate.com/cgi-bin/data.pl?ref=N01E103+1102+48694W

Data on Singapore's rainfall from:
http://www.worldclimate.com/cgi-bin/data.pl?ref=N01E103+2100+48694W

Calculating Temperature range:




Calculating average temperature:










Calculate total rainfall














Creating a temperature graph with Chart Wizard:
















Creating a rainfall graph with Chart Wizard













No comments: