/ced2ar-web

You are viewing the official metadata. View crowdsourced contributions.

Stata SAS
Variable Name qwi_z_w3
Top Access Level undefined (no restrictions)
Label QWI: FQ average monthly earnings
Codebook National QWI
Concept
Type numeric

Files

qwi_national_wia.dta   http://download.vrdc.cornell.edu/qwipu.national/beta/r4580/qwi_national_wia.dta.gz  ( Stata )
qwi_national_wia.sas7bdat   http://download.vrdc.cornell.edu/qwipu.national/beta/r4580/qwi_national_wia.sas7bdat.gz  ( SAS )
qwi_national_wia.csv   http://download.vrdc.cornell.edu/qwipu.national/beta/r4580/qwi_national_wia.csv.gz  ( CSV )

Full Description

Measuring earnings using UI wage records in the QWI system presents some interesting challenges. The earnings of end-of-quarter employees who are not present at the beginning of the quarter are the earnings of accessions during the quarter. The QWI system does not provide any information about how much of the quarter such individuals worked. The range of possibilities goes from one day to every day of the quarter. Hence, estimates of the average earnings of such individuals may not be comparable from quarter to quarter unless one assumes that the average accession works the same number of quarters regardless of other conditions in the economy. Similarly, the earnings of beginning-of-quarter workers who are not present at the end of the quarter represent the earnings of separations. These present the same comparison problems as the average earnings of accessions; namely, it is difficult to model the number of weeks worked during the quarter. If we consider only those individuals employed at the employer in a given quarter who were neither accessions nor separations during that quarter, we are left, exactly, with the full-quarter employees.

The QWI system measures the average earnings of full-quarter employees by summing the earnings on the UI wage records of all individuals at a given employer who have full-quarter status in a given quarter, then dividing by the number of full-quarter employees.

Summary Statistics

Valid values 37260
Invalid values 1080
Minimum 212.787
Maximum 24174.711
Mean 2679.631
Standard deviation 1831.52

Value Ranges

Value Range

Range: [ 212.786636705592 , 24174.7113894223 ]