Computer Science homework help.
- Download the TopTalentSurvey Excel file Ch09Ex01 and provide descriptive statistics (mean, mode, minimum, maximum) for each survey item. Use appropriate functions to calculate statistics. This requires planning ahead. Designate an area of the workbook to display the statistics for each month and for each survey question.
- Create a line chart to display the survey results using the means of all survey items.
- Save the Excel spreadsheet under your name and M4 Lab Assignment.
- Open a Word document and copy paste the data and the line chart.
- Write a brief summary identifying the areas that have shown the greatest improvement in customer satisfaction and the ones that have shown a decline in customer satisfaction.
- Save the Word document under your name and M4 Lab Assignment.
- Submit both files to the assignment submission folder.