What trends does your analysis of the survey results show

Assignment Help Other Subject

Reference no: EM133846502

Assignment: Working with Data

Competency

In this project, you will demonstrate your mastery of the following competency:

1. 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 I: 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:

1. The customer service team will use the data to inform ways to improve the overall experience for customers on the Trexpedition website.

2. 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.

3. 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 spreadsheet can include, but is not limited to, the following functions and operations:

A. Filters

B. Cell formatting

C. Charts, tables, and graphs

D. Pivot tables

E. Formulas, for example:

a. Average
b. Count
c. Countif
d. SUM

F. Freeze panes

G. Logical functions

H. Decimal and number formatting

Part II: 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 words report to accompany the spreadsheet you created for Andrea. Be sure to include the following in your report:

A. Explain how the spreadsheet meets Andrea's stated data needs and the data needs of others in the organization.

B. Explain how you used the spreadsheet to analyze the data. Consider the following:

a. What trends does your analysis of the survey results show?

b. Which survey responses got the most positive results? The most negative?

C. Detail which functions and operations you used in the spreadsheet to complete your analysis.

D. Describe how you used formatting to make the spreadsheet user-friendly and visually appealing.

E. 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.

Reference no: EM133846502

Questions Cloud

Orem self-care deficit theory : Using Orem's self-care deficit theory, a nurse assesses a patient's self-care ability in activities of daily living to identify how to best plan care

COPD exacerbation : An older male who is in his early 70's is admitted to the emergency department because of a COPD exacerbation.

What was the main point of the video-podcast : What was the main point of the video/podcast? Provide 2 major points discussed and describe those points. What did you learn from the video/podcast?

What is meant by necessaries : What is meant by Necessaries and what is the reason that minors only enjoy limited capacity to contract? Provide examples.

What trends does your analysis of the survey results show : What trends does your analysis of the survey results show? Which survey responses got the most positive results? The most negative?

What motivates you to work hard and achieve your goals : What motivates you to work hard and achieve your goals? Can you give an example of a time when you were incentivised to work harder than usual?

Define terms competence-compassion and caring : Define the terms competence, compassion, and caring. Are these terms that a nurse should demonstrate during patient care? If so, explain why.

Nursing process as guide plan comprehensive care plan : White a 45 year old pensioner was diagnosed of prolapse of the uterus by Dr. Tumi Umar, Using the nursing process as a guide plan a comprehensive care plan.

Give a short summary of what the document is about : Identify the primary source you are using. Give a short summary of what the document is about, or what the purpose of the document is.

User Account

All Pages