Skip to content
CIPD question explained · Data tasks

How Do You Calculate Staff Turnover for a CIPD Assignment? A UAE Guide

Your brief gives you leavers and headcount and asks for a turnover rate. You want the right formula, and to show what the number means.

Here is the formula, a worked example and how to interpret it.

  • The formula in one line
  • Step-by-step worked example
  • Stability index explained
  • How to interpret the result
Ask a CIPD Mentor Upload Your Data Task

Get Help With Your Data Task

A CIPD mentor reads your brief first, then replies with a fixed AED quote. No payment is needed to ask.

3 quick steps · about 2 minutes

Core assignment scope

Your requirements

Where are you with this assignment? *

Early check-in on your writing?

Send everything once, closer to the deadline

The brief lets the mentor quote accurately.

    Secure contact & price estimate

    Estimated starting price—

    Choose your level, word count and deadline in step 1 to see an estimate.

    Per-page rates from our pricing page (1 page = 250 words). Your mentor confirms the exact AED total in writing before you pay.

    • Encrypted & confidential
    • Free, confidential AED quote
    • Similarity report on request
    The answer

    What Is the Staff Turnover Formula?

    Quick answer: Staff turnover rate = (number of leavers in the period ÷ average number of employees in the period) × 100. Average employees = (headcount at the start + headcount at the end) ÷ 2.

    Use the same period for both numbers, usually 12 months. State the period, the source of your data and whether you counted all leavers or only voluntary ones.

    Worked example

    How Does the Calculation Work, Step by Step?

    An illustrative example with round numbers, for a fictional Dubai hotel. Use your own organisation's anonymised data in your assignment.

    StepCalculationResult
    Headcount on 1 JanuaryGiven180
    Headcount on 31 DecemberGiven220
    Average headcount(180 + 220) ÷ 2200
    Leavers in the yearGiven50
    Turnover rate(50 ÷ 200) × 10025%
    Stability index

    Should You Also Calculate the Stability Index?

    Quick answer: Yes, if your brief asks you to interpret turnover. Stability index = (employees with one year or more of service now ÷ total headcount one year ago) × 100.

    In the example, if 150 of the 180 people employed a year ago are still there, the stability index is (150 ÷ 180) × 100 = 83%. A 25% turnover rate with 83% stability suggests most leavers are recent joiners, which points to recruitment or induction rather than long-serving staff leaving.

    Stuck on the Numbers in Your CIPD Data Task?

    A mentor walks through your calculations with you. You write the analysis.

    Ask a CIPD Mentor Upload Your Brief
    ConfidentialCIPD-focused mentorsEvening and weekend slots
    Interpret it

    How Do You Interpret Turnover in a CIPD Assignment?

    "Turnover is 25%, which is high."
    25%, compared with last year and a sourced sector figure.
    One overall number.
    Split by department, length of service or reason for leaving.
    No cost.
    An estimate of replacement cost in AED, with your assumptions stated.
    No action.
    A recommendation linked to the cause the data suggests.

    Related help: 5CO02 Evidence-Based Practice, 3CO02 Principles of Analytics and 5HR02 Talent Management and Workforce Planning.

    FAQs

    What Else Do Learners Ask About Staff Turnover?

    There is no single good rate. It depends on the sector, role and country. Compare your figure with your own past years and with a published sector figure, and say which source you used.

    Use average headcount, (start + end) / 2, unless your brief says otherwise. It is fairer when headcount changes during the year.

    Include all leavers in the overall rate, then show a separate figure for early leavers if your data allows. Early leaving often points to recruitment or induction problems.

    Data and evidence tasks, for example in 3CO02 and 5CO02, often do. Workforce planning in 5HR02 uses turnover too. Follow your own brief.
    WhatsApp Get Free Quote