Please make sure every bulleted point in the project instructions is touched and included in the body of the assignment also don't forget to include in-text citations where appropriate, thanks.
Project instructions Competency In this project, you will demonstrate your mastery of the following competency: · Apply common techniques used for working with data Scenario You work in the customer service department at Trexpedition, an online travel and hospitality booking service that provides booking for travel around the world. Your team recently released a customer survey to help inform Trexpedition on its customers’ overall satisfaction, needs, and issues. The survey was sent to many of Trexpedition’s most frequent customers via email and social media over the course of a two-month span. Your supervisor, Andrea Chang, was pleased with the number of surveys that the team received, but there’s one problem—there are so many responses, it’s proving challenging to sort through the data to find useful trends. You have been asked to review the data from the customer surveys and organize it. Directions Part One: Customer Survey Spreadsheet To help Andrea make sense of the customer survey data the company has received, you have decided to create a spreadsheet to organize and sort the data. Review the questions and response data in the Trexpedition Customer Survey Results document in the Supporting Materials section. As you review the results, consider which spreadsheet functions and operations you could use to help make the data more organized and useful to Andrea and the team. As you are starting to review the customer survey results, you receive an direct message from Andrea with more information about her specific needs for the data: Hello, Thanks again for taking the time to go through all these customer surveys. I’ve been very busy lately, and I don’t think I would have had the time to do all this work myself. This is a big help. I just wanted to let you know more about how the data will be used: · The customer service team will use the data to inform ways to improve the overall experience for customers on the Trexpedition website. · I’m going to be using the spreadsheet during meetings with the Trexpedition leadership team, so I need it to be formatted in a user-friendly and visually appealing manner. · The marketing and sales teams will also be using the data to learn more about how to reach potential and existing customers. They will need to be able to use the spreadsheet to identify trends in the data that can inform what new offerings might appeal to customers. Thanks again, Andrea To ensure that your spreadsheet meets Andrea’s data needs, you should use spreadsheet functions and operations. The way you format your spreadsheet is up to you, but make sure that it will be useful to the stakeholders at Trexpedition. Your final spreadsheet can include, but is not limited to, the following functions and operations: · Filters · Cell formatting · Charts, tables, and graphs · Pivot tables · Formulas, for example: · Average · Count · Countif · SUM · Freeze panes · Logical functions · Decimal and number formatting Part Two: Written Report Once you have completed your spreadsheet, Andrea has one additional request. She would like for you to write a brief report that summarizes how you used functions and operations to meet her data needs and those of others in the organization. Write a 150- to 250-word report to accompany the spreadsheet you created for Andrea. Be sure to include the following in your report: · Explain how the spreadsheet meets Andrea’s stated data needs and the data needs of others in the organization. · Explain how you used the spreadsheet to analyze the data. Consider the following: · What trends does your analysis of the survey results show? · Which survey responses got the most positive results? The most negative? · Detail which functions and operations you used in the spreadsheet to complete your analysis. · Describe how you used formatting to make the spreadsheet user-friendly and visually appealing. · Explain what implications the results of the survey have for the company. Report on conclusions of the data analysis by providing three recommendations for ways Trexpedition should respond to the customer survey responses. What to Submit Every project has a deliverable or deliverables, which are the files that must be submitted before your project can be assessed. For this project, you must submit the following: 1. Customer Survey Spreadsheet Create a spreadsheet to organize and sort the data from the Trexpedition customer survey results. 2. Written Report Write a 150- to 250-word report to accompany the spreadsheet you created for Andrea explaining how you used functions and formatting to organize the data to meet her needs. Trexpedition Customer Survey Results Thank you for being a valued Trexpedition customer! We appreciate you taking the time out of your busy day to answer some questions and help us make Trexpedition the best online travel and hospitality booking site we can possibly be! 1–7 Scale: Answer the following questions on a scale of 1–7, or select “N/A” if the question does not apply to you. 1. How satisfied were you with Trexpedition’s flight booking service? 2. How satisfied were you with Trexpedition’s hotel booking service? 3. How satisfied were you with Trexpedition’s rental car booking service? 4. How satisfied were you with Trexpedition’s bundling function (bundling flight, hotel, and/or rental car orders into one order)? 5. How likely would you be to recommend Trexpedition to a friend or family member? 6. How satisfied were you with the customer service you received from Trexpedition customer service representatives? 7. Based on your experiences with other travel booking sites, how well does Trexpedition’s pricing compare? Binary Scale: Answer the following questions with either “Yes” or “No.” 1. I found the Trexpedition website to have a visually appealing layout. 2. The Trexpedition website was easy to navigate, and it was easy to find what I was looking for on the site. 3. I received a confirmation email within 30 minutes of my reservation. 4. A Trexpedition customer support representative contacted me via instant chat within the first 2 minutes of my time on the site. 5. A Trexpedition customer support representative helped me with all issues or questions I had. 6. I was aware that Trexpedition offers a bundling service, allowing customers to bundle flight, hotel, and rental car bookings in a single order. Multiple Choice: Please answer the following questions about potential improvements we could make to the Trexpedition site. 1. Which of the following additions would you most like to see on the Trexpedition website? A. More hotel options B. More flight options C. More rental car options D. None of the above 2. Which of the following improvements would you most like to see on the Trexpedition experience? A. Improved site layout B. Increased site speed C. More relevant advertisements D. Improved checkout experience E. None of the above Survey Responses Survey 1 Scale of 1–7: Q1: 7 Q2: 6 Q3: 5 Q4: 5 Q5: 7 Q6: 5 Q7: 7 Binary Scale: Q1: Y Q2: Y Q3: Y Q4: Y Q5: N Q6: Y Multiple Choice: Q1: A Q2: C Survey 2 Scale of 1–7: Q1: 6 Q2: 6 Q3: 6 Q4: 5 Q5: 6 Q6: 5 Q7: 5 Binary Scale: Q1: Y Q2: N Q3: N Q4: N Q5: Y Q6: Y Multiple Choice: Q1: B Q2: A Survey 3 Scale of 1–7: Q1: 5 Q2: 7 Q3: 5 Q4: N/A Q5: 5 Q6: 6 Q7: 7 Binary Scale: Q1: N Q2: Y Q3: N Q4: Y Q5: Y Q6: N Multiple Choice: Q1: B Q2: D Survey 4 Scale of 1–7: Q1: 4 Q2: 3 Q3: 5 Q4: 6 Q5: 5 Q6: 3 Q7: 5 Binary Scale: Q1: Y Q2: N Q3: N Q4: N Q5: N Q6: Y Multiple Choice: Q1: B Q2: E Survey 5 Scale of 1–7: Q1: 5 Q2: 7 Q3: 7 Q4: 7 Q5: 5 Q6: 7 Q7: 7 Binary Scale: Q1: N Q2: Y Q3: N Q4: Y Q5: Y Q6: Y Multiple Choice: Q1: D Q2: A Survey 6 Scale of 1–7: Q1: 6 Q2: 7 Q3: 7 Q4: 6 Q5: 7 Q6: 5 Q7: 6 Binary Scale: Q1: Y Q2: Y Q3: N Q4: Y Q5: N Q6: Y Multiple Choice: Q1: C Q2: C Survey 7 Scale of 1–7: Q1: 6 Q2: 6 Q3: 6 Q4: 6 Q5: 6 Q6: 6 Q7: 6 Binary Scale: Q1: N Q2: Y Q3: N Q4: Y Q5: Y Q6: Y Multiple Choice: Q1: C Q2: B Survey 8 Scale of 1–7: Q1: 4 Q2: 2 Q3: 3 Q4: N/A Q5: 3 Q6: 3 Q7: 3 Binary Scale: Q1: N Q2: N Q3: Y Q4: N Q5: N Q6: N Multiple Choice: Q1: D Q2: E Survey 9 Scale of 1–7: Q1: 7 Q2: 7 Q3: 7 Q4: 7 Q5: 6 Q6: 5 Q7: 7 Binary Scale: Q1: Y Q2: N Q3: N Q4: Y Q5: N Q6: Y Multiple Choice: Q1: A Q2: A Survey 10 Scale of 1–7: Q1: 5 Q2: 5 Q3: 5 Q4: 5 Q5: 5 Q6: 6 Q7: 5 Binary Scale: Q1: Y Q2: Y Q3: Y Q4: