w3a3

Instructions

In this assignment, you will extract data from an Access Database and import it into Excel in order to conduct statistical analysis. It will also allow you to apply data visualization and interpretation techniques.1)Watch the Access: Introduction to Databases video https://www.youtube.com/watch?time_continue=3&v=eXiCza050ug2)Download Access Database for Analytics Assignment. On Microsoft Windows and Microsoft Office in order to open this file. 3)Read this Business Analytics Problem document. 4)Read and follow these instructions in Step I: Exporting Access Data Into Excel presentation. 5)Export the data needed to complete DS1 from Access to Excel6)Read and follow this Step II: Prepare, Analyze, Interpret presentation to replicate the process to complete DS1.7)Interpret in 100 words the results of your analysis for DS1.8)Choose any two additional Exercises from the Business Analytics Problem, complete the analysis and interpret your results (100 words for each exercise).---Submit the results of your analysis for all three exercises (DS1 and the two you chose) in one Excel file.---Submit your interpretations for each of the three exercises you completed in a Word Document.

Answer

DS1The time series plot indicates that there were months which the TGIF did not generate any revenue. For instance, in January 2013, February 2011, March 2012, April 2013 among others, there was no revenue collected. However, the general trend indicates that in 2011, the highest revenue was collected in January, which kept on consistently decreasing up to July, where thereafter increased up to October. In 2011, there was no revenue in November and December. There was a general decline in gross revenue throughout the year in 2012. In 2012, July had the highest gross revenue. The first two months of 2013, the gross revenue was at its lowest, and in December, it had the highest gross revenue. There was a consistent increase in gross revenue in the last three months of 2013. DS2The summary sho...
To avoid plagiarism, part of the answer is hidden. Click on the button below to order the full answer.
Order Answer Back
Price Calculator
Manage orders
Why we are Ranked the best
  • Unlimited Revisions
  • Free 24/7 Support and chat
  • Money back guaranteed
  • Low prices with discounts
  • Experienced writers.
  • Free Unlimited support

Hear from our customers

Get a quote Chat with support Find an expert Frequently asked questions