Overview

Descriptive statistics describes a data set. It is used to summarize and organize the data into something more manageable, actionable, and ready for presentation. It can also help organize data and present a business problem in an understandable manner. You can use descriptive statistics to understand and analyze the data for your organization.

The employees in your company report struggling with burnout (being overworked). You have been asked to analyze the situation and recommend solutions to reduce employee burnout. You have access to an employee survey with employee responses related to the situation.

This week you will analyze the employee survey data and create bar graphs to represent the data visually. Based on your analysis, you will then create an executive summary targeted to a non-technical audience unfamiliar with statistics. See the document Module Four Survey Response Key for the responses that were available on the survey.

Prompt

Part 1: Burnout Analysis

Review the Microsoft Excel file containing the Employee Survey Data Set and familiarize yourself with the survey respondents and burnout indicators. Import these employee survey responses into Excel and conduct a burnout analysis.

Specifically, you must address the following rubric criteria:

Part 1: Graphs. Use Excel to create bar graphs that will answer the following questions:

1. Which gender is experiencing the burnout level "Pretty wiped out almost every day" most? (Hint: Refer to columns A, E, and F in the Excel file.)
2. Which male age group is experiencing the stress level, "A little stress that would be expected with the ups and downs of life" at home the most? (Hint: Refer to columns A, B, G, and H in the Excel file.)
3. Which leadership level strongly agrees with the fact that they love what they do? (Hint: Refer to columns D, K, and L in the Excel file.)
4. Which gender with a tenure of 5+ years had the lowest number of responses for the burnout level "I feel great! Energy to spare!"?(Hint: Refer to columns A, C, E, and F in the Excel file.)

Part 2: Executive Summary. write an Executive Summary of your results addressing the following criteria:

1. Purpose and respondents: Explain the purpose of the executive summary and briefly describe the survey respondents.
2. Results: Summarize your bar graph analyses and answer the questions they represent. Add corresponding bar graphs to relevant sections of the summary to illustrate your analyses.
3. Recommendations: Based on your analysis, recommend two areas the company can focus on to reduce employee burnout.