Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!


Use Excel and Access to analyze “The Engagement Analysis,” beginning on page 187

Use Excel and Access to analyze “The Engagement Analysis,” beginning on page 187

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.

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Ace Tutors only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Ace Tutors are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Ace Tutors is known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Ace Tutors, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.