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.
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 attached document the responses that were available on the survey.
Prompt
Part 1: Burnout Analysis: Bar Graphs
All graphs for corresponding questions below are attached files.
- Which gender is experiencing the burnout level “Pretty wiped out almost every day” most?
- 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?
- Which leadership level strongly agrees with the fact that they love what they do?
- Which gender with a tenure of 5+ years had the lowest number of responses for the burnout level “I feel great! Energy to spare!”?
Part 2: Executive Summary
Create an Executive Summary of your results addressing the following criteria:
- Purpose and respondents: Explain the purpose of the executive summary and briefly describe the survey respondents.
- 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.
- Recommendations: Based on your analysis, recommend two areas the company can focus on to reduce employee burnout.
What to Submit
To complete this assignment, you must submit the following:
Executive Summary: Submit a 2-to 3-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Include the screenshots of the graphs you generated in Tableau. Sources should be cited according to APA style.
Response Key
1. Gender
· Male
· Female
· OptOut
2. Age
· 20-29
· 30-39
· 40-49
· 50+
· OptOut
3. Tenure
· Less than 1 year
· 1 year–less than 2 years
· 2–5 years
· 5+ years
· OptOut
4. Leadership Level
· Individual contributor
· Manager
· Director
· Executive
· OptOut
5. What is your current level of burnout at work?
1. I feel great! Energy to spare!
2. A bit worn out at the end of the day, several days a week
3. Pretty wiped out almost every day
4. Most days I don’t know how I make it to 5:00.
5. I’m not sure I can make it another day.
6. How stressed are you at home?
1. I feel great! No stress at all!
2. A little stress that would be expected with the ups and downs of life
3. Pretty stressed out almost every day
4. Most days I don’t know how I make it to the end of the day.
5. It feels like I’m in a pressure cooker.
7. I engage in regular practices to relax and unwind.
1. Strongly disagree
2. Disagree
3. Neutral
4. Agree
5. Strongly agree
8. I love what I do.
1. Strongly disagree
2. Disagree
3. Neutral
4. Agree
5. Strongly agree