QCEW Over-the-Year Change Calculation Details

Over-the-year (OTY) level and percent changes are available for QCEW data points from the Open Data Access files and from the CSV files on the QCEW Data Files page. These files contain OTY changes for QCEW data points that represent averages. Each OTY field was calculated using the rounded values present in the file. For example, the OTY Average weekly wage value is calculated by subtracting the prior period's AWW from the current period's AWW instead of calculating the differences of the underlying components of AWW first, then re-calculating AWW.

Over-the-year level changes represent the change between the given data point, and that same data point for the prior year. For example, the over-the-year change in "month 1" employment for first quarter 2012 data is the change that occured between January 2011 employment and January 2012 employment. See example below.

     [2012 OTY Month 1 Employment Change] = [2012 Month 1 Employment] - [2011 Month 1 Employment]

Over-the-year (OTY) percent changes represent the percent change between the given data point, and that same data point for the prior year. For example, the over-the-year percent change in "month 1" employment for first quarter 2012 data is the percent change that occured between January 2011 employment and January 2012 employment. OTY percent changes are rounded to the tenths place. See example below.

     current = [2012 Month 1 Employment]

     prior = [2011 Month 1 Employment]

     [2012 OTY Month 1 Employment % Change]  =  100 * ( (current - prior) / prior )

     NOTE: OTY percent changes are rounded to the tenths place.



Related Documentation:   QCEW Data Guide;   Documentation Guide;   QCEW Data Files;   Open Data Access Guide;  

 

Last Modified Date: April 27, 2015