Excel Data Analysis-Interactive Exercise Grading Guide DAT/565 Version 1 Individual Assignment: Excel Data Analysis-Interactive Exercise Purpose of Assignment The implementation of Business Analytics requires appropriate software tools. One of the most popular tools used by IT/BI professionals is Microsoft Excel. The tool can run on computer desktops as well as in the cloud, utilizing Microsoft 365. This tool has now further extended itself into smart phones and tablets. Business analysts who have Advanced Excel knowledge can readily create persuasive analytical graphs that can be shared over a variety of file sharing tools that are compatible with MS Excel. This assignment will enable students to work and interact with MS Excel in creating analytics charts. Resources Required Historical Population and Growth Rate Grading Guide Content Met Partially Met Not Met Excel Area Chart Student selects the data for each continent and their populations and group together at the top of the spreadsheet and uses only population data from the last 10 years. Student creates an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. Written Narratives Student interprets the historical trend in increase/decrease of population per continent. Student formulates a prediction on how the population would vary in the next decade and provides and explains how he/she arrived at his/her conclusion. Student investigates how Excel creates a forecast and explains the steps involved. Student converts their area chart into a line chart in Excel, and adds forecasted values, and includes a screenshot in his/her paper. Student compares the forecasted output that Excel has provided with the conclusions he/she have arrived at in regards to the trend in the increase/decrease of population. Student recommends other Excel data analysis properties or chart types that could be used to demonstrate his/her data findings. The paper is a minimum of 1,400 words in length. Copyright © 2016 by University of Phoenix. All rights reserved. Comments: 1 Excel Data Analysis-Interactive Exercise Grading Guide DAT/565 Version 1 Writing Guidelines Met Total Available Total Earned 8 #/X Partially Met Not Met Total Available Total Earned 2 #/X 10 #/X The paper — including tables and graphs, headings, a title page, and a reference page — is consistent with APA formatting guidelines and meets course-level requirements. The paper includes properly cited intellectual property using APA style in-text citations and a reference page. The paper includes paragraph and sentence transitions that are logical and maintain flow throughout the paper. The paper includes sentences that are complete, clear, and concise. The paper follows proper rules of grammar and usage including spelling and punctuation. Assignment Total # Additional comments: Copyright © 2016 by University of Phoenix. All rights reserved. Comments: 2 
Purchase answer to see full attachment