Total Separations - Nonfarm
Returns the total separations rate for nonfarm employees from FRED (JOLTS data). This includes both quits and layoffs/discharges.
What's Included
- Quits (voluntary separations)
- Layoffs and discharges
- Other separations
Data Source
Data is sourced from the Bureau of Labor Statistics JOLTS survey via FRED.
Notes
- Rate = separations / total employment
- Monthly data
- Key labor market indicator
Syntax
=Separations()Returns
number
Total separations rate
Examples
=Separations()=Separations()-Quits()When to Use
- Labor market analysis
- Turnover assessment
- Economic cycle research
- HR benchmarking
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Voluntary quits only | Quits() |
| Unemployment rate | UnemploymentRate() |
| Job openings | FRED direct access |
Common Issues & FAQ
What's the difference from Quits?
Separations includes both voluntary quits AND involuntary layoffs/discharges.
Is this seasonally adjusted?
Yes, JOLTS data is seasonally adjusted.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?