Look (in the Internet) for data on the distribution of the population in the European countries in the past years. Import them, if necessary, in an Excel file.
Then, produce a report which satisfies the request which follow.

1) Create a table containing, for each country, the minimum and the maximum population in the period of time which you consider and the years when these minimum and maximum are attained.

2) Create a chart which compares the population's variation for the countries in the period that you are examining.

3) Group also the data in order to create a chart which compares the population for the countries in the Western, Central and Eastern regions of Europe. (Hint: you can use the group functionalities of pivot tables, if you like.)

4) Create a line chart which displays data on the Italian population. Add a forecast trendline to this chart, to show the growth of the Italian population in the next five years.
Ultime modifiche: lunedì, 17 novembre 2008, 23:54