• 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 Chart to 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.

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Lab assignment should follow the basic outline below. Be sure to type your assignment and have it stapled and in order, upon arrival to the following class. If you have purchased the Lab Manual, you do not have to type your data if you are turning in pages from your manual along with the other typed sections of your assignment. Remember for Lab 1 (Excel), you are copying/pasting your spreadsheets into your word document under Data instead of using a chart/table as in the other labs that follow. (Another reminder, for Lab 1, Data will consist of Exercise 1 and 2 spreadsheets, while Analysis will only consist of Homework Exercise 1 questions a-d.)

Outline is as follows:

Cover sheet (front page)

– title of Lab

– class/ section

– Your Name

– Professor’s Name

Introduction (next page)

– Summary in your own words of the Theory/Introduction of Lab

Data (If you have the Lab manual, you may hand-write answers as long as they are legible)

– chart/ table/ excel spreadsheet

– calculations (if any)

Analysis

– Questions (either type the answers in complete sentences or type the Question with the answer below it)

Conclusion

-Summary

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"