Business Analysis

Use Excel and Access to analyze "The Engagement Analysis," beginning on page 187. This company assists couples about to be engaged with their selection of an engagement ring. You are given a database attached to this assignment to download and use for your data analysis. The focus of this analysis is to answer several questions the operations manager has asked regarding the years 2010 and 2015. In specific, the operations manager wants to know (Monk, 2017, p. 187): 

• Is true that Christmas Eve, the day before New Year’s Eve (December 30), and Valentine’s Day (February 14) are by far the most popular days for popping the question? Are there any other popular days for proposals during the year? How much do couples spend on their engagement rings?


• 
  


• Have there been changes in this spending from 2010 to 2015?


• 
  


• Do people spend more for rings at certain times during the year?


• 
  


• How long do couples date before becoming engaged and are there changes in this length of time over the years? 


• 
  


• Some couples get married in a church, and others do not. How does the behavior of these two groups differ and in what ways?


• 
  


• The three-county area can be divided into five geographical regions—northeast, northwest, southeast, southwest, and central. To some degree, the regions differ ethnically and culturally. Are there regional differences in the behavior of your company’s clients?

Begin by reviewing the attached Access file labeled "EngagementAnalysis.accdb". More details regarding the assignments are explained in detail in the case study.

Deliverable Tasks:

• Task 1 (Excel file): There are two tasks in this first assignment. First, import summary data from the Access file into a new Excel spreadsheet file you will create as per the instructions on page 190.  The second task requires you to create Pivot tables and charts in Excel from the summary worksheets. You will use these pivot tables to compare 2010 results with 2015 results (Monk, 2017, p.192).  

• Task 2 (Word file): Referring back to the questions the Operations manager has asked (see the bullet list on page 187 of your textbook), you will document your findings and answer the questions posed to you by the operations manager in a formal Memo addressed to the operations manager.  Finally, not chronicled in the textbook, you are also tasked in this assignment to find and report on two additional trends in the data analysis that appear to you to be worth of reporting to the operations manager. (Hint: look carefully at your Excel Pivot tables). 

• Task 3 (PowerPoint file): This assignment is not chronicled in the textbook. The operations manager has requested that you address her management team and explain your findings and conclusions in a narrated PowerPoint program. This PowerPoint program will highlight not only your      findings and conclusions, but clearly address both the questions posed by  the operations manager and explain your additional findings (see assignment 2).  As a minimum you need to include the following:  a template appropriate to the case study, a title page, charts, tables, and graphs that depict the historical data and findings and a minimum of 5 pages of bullet points.