Excel Data Analysis and Interactive Exercise

Anonymous
timer Asked: Apr 11th, 2017

Question description

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).

Create narratives based on the Excel Area Chartto discuss the following in a minimum of 1,400 words:

  • Interpret the historical trend in increase/decrease of population per continent.
  • Formulate a prediction on how the population would vary in the next decade. How did you arrive at this conclusion?
  • Investigate how Excel creates a forecast. Explain the steps involved.
  • Convert your area chart into a line chart in Excel, and add forecasted values. Include a screenshot in your paper.
  • Compare the forecasted output that Excel has provided with the conclusions you have arrived at in regards to the trend in the increase/decrease of population.
  • Recommend other Excel data analysis properties or chart types that could be used to demonstrate your data findings.

Format assignment consistent with APA guidelines.

Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors