Explain how the spreadsheet meets Andrea’s stated data needs and the data needs of others in the organization. What trends does your analysis of the survey results show? Which survey responses got the most positive results? The most negative? Describe how you used formatting to make the spreadsheet user-friendly and visually appealing.
Trexpedition customer survey results
Create a spreadsheet to organize and sort the data from the Trexpedition customer survey results. 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;
Then in a 150 – 200 written 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.