Calculating Employee Burnout Rate by Department from Survey Data

Nov 1, 2025, 1:42 PM

https://docs.google.com/forms/d/e/1FAIpQLSeofGuuSDbQAM0W0k7HoiErTWpWH8xr8J0hF14r-Ig1k__kQg/viewform?usp=dialog so this is a survey from which we want to calculate the employee burnout rate based on each department

It looks like you’ve shared the link to the blank questionnaire rather than the spreadsheet that contains the survey responses.
To calculate an employee burnout rate by department we’ll need the actual response data, typically stored in a Google Sheets file (created automatically when you click “Responses → Link to Sheets” in Google Forms).
Could you please do one of the following?
  1. Share a downloadable copy of the responses (e.g. a CSV or Excel export).
  2. Provide a public link to the Google Sheet that stores the responses.
Once I have the data I can load it, compute burnout rates by department, and visualise the results for you. 😊

نتائج السرفي.zip

Missing file

so this is a survey from which we want to calculate the employee burnout rate based on each department

Burnout rate by department / specialty

Using the question “I feel burned out from my work” as the key indicator:
  • responses “always” and “frequently” were treated as burned-out, while “sometimes” and “rarely” were treated as not burned-out.
  • The survey contains 42 responses across 16 specialties / work areas.
Below is the computed burnout rate for each specialty (you can also see it in the horizontal bar chart above):
Specialty / Department# Responses# Burned-outBurnout Rate
Dermatologist100 %
ICU3266.7 %
Intern (combined)4125.0 %
MICU & Internal Medicine11100 %
Ophthalmologist22100 %
Ophthalmology100 %
Orthopedic Surgeon11100 %
Radiologist11100 %
Emergency Medicine2150 %
General Practitioner7571.4 %
Internal Medicine44100 %
Obstetrics & Gynecology3133.3 %
Pediatrics5360.0 %
Surgery6583.3 %
انترن (Intern – Arabic entry)11100 %
Key observations
  1. Several specialties show a very high burnout rate (≈ 100 %), although they have very small sample sizes (1–2 people). Caution is required when interpreting those values.
  2. Among specialties with a reasonable sample (≥ 5 respondents), Surgery (83 %) and General Practice (71 %) appear to be the highest-risk areas.
  3. Specialties such as Dermatology and Ophthalmology (1–2 respondents each) reported no or low burnout in this small sample.
Feel free to let me know if you’d like:
  • a different definition of burnout (e.g., include “sometimes” as partial burnout),
  • to combine/clean department names (e.g., merge Intern/انترن),
  • statistical tests or confidence intervals, or
  • further breakdowns by work place, gender, etc.

Burnout rate by department / specialty

Using the item “I feel burned out from my work” as the key indicator:
  • Answers “always” or “frequently” were counted as burned-out; “sometimes” and “rarely” were counted as not burned-out.
  • 42 responses were analysed across 16 specialties.
Specialty / Department# Responses# Burned-outBurnout Rate
Dermatologist100 %
ICU3266.7 %
Intern (combined)4125.0 %
MICU & Internal Medicine11100 %
Ophthalmologist22100 %
Ophthalmology100 %
Orthopedic Surgeon11100 %
Radiologist11100 %
Emergency Medicine2150 %
General Practitioner7571.4 %
Internal Medicine44100 %
Obstetrics & Gynecology3133.3 %
Pediatrics5360.0 %
Surgery6583.3 %
انترن (Intern – Arabic entry)11100 %
Insights
  1. Very high burnout rates (≈ 100 %) appear in several specialties but with only 1–2 respondents; interpret with caution.
  2. Among better-sampled groups, Surgery (83 %) and General Practice (71 %) stand out as highest risk.
  3. Dermatology and Ophthalmology show low or zero burnout in this small sample.
The horizontal bar chart above visualises these percentages.
Need anything else? I can:
  • merge or rename specialties,
  • adjust the burnout definition,
  • add confidence intervals or statistical tests,
  • break results down by work-place, gender, or shift patterns.
Just let me know what you’d like to explore next! 😊
Get started with Vizly