1. Has the globe been becoming warmer and drier over 1950-2000? Draw evidence on the

descriptive statistics of relevant variables in the dataset.

2. Do hot countries tend to be poor (with lower per capita GDP)? Do dry countries tend to be

poor? Use appropriate graphs to interpret the relationship between relevant variables. You

only need to present

two

relationships. Carefully interpret and explain.

3. Calculate the sample covariance and correlation for the two relationships in question 2

above using Data Analysis Tool Pack or Excel statistical functions. In addition, you are

required to calculate the sample covariance and correlation using a second method (using

basic Excel formulae without Data Analysis Tool Pack). The calculations by the second

method should be carefully laid out in Excel and should NOT use any hard-wired Excel

statistical functions e.g. COVARIANCE.S, CORREL, et al. You can use the Excel sort

command, the sum command, and any other non-statistical excel commands. Carefully

interpret your results.