Download“Population Historical” data from the government website.
- Select the data for each continent and their populations and group together at the top of the spreadsheet. Use only population data from the last 10 years.
- create an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. (1 hour for a, b, c).
- Formulate a prediction on how the population would vary in the next decade. How did you arrive at this conclusion?
- Convert your area chart into a line chart in Excel, and add forecasted values. Include a screenshot in your paper.
Categories: