Attachment E.5.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Survey Data Quality Control Services
- Solicitation number
- 951700-25-Q-0009
- Issued by
-
US Agency for Global Media
About this file
This is a quality control data file showing error examples and issues in survey data management and querying. The file appears to be an attachment (E.5) showing sample data quality issues, including missing variable names, incorrect query logic, and database filtering problems. Specific examples include an issue with case count discrepancies (140 expected vs 113 actual) and problems with English language variable coding.
The file relates to a solicitation (951700-25-Q-0009) from the U.S. Agency for Global Media (USAGM) for Survey Data Quality Control Services. The requirement will be awarded as a Firm Fixed Price (FFP) Blanket Purchase Agreement (BPA) and is 100% set-aside for small businesses.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFQ - 951700-25-Q-0009 - Amendment 00001.pdf | ||
| Attachment D - Amendment 00001.pdf | ||
| Attachment A - SOW - Amendment 00001.pdf | ||
| Attachment E.6.xlsx | XLSX spreadsheet | |
| Attachment E.1.xlsx | XLSX spreadsheet | |
| Attachment E.3.xlsx | XLSX spreadsheet | |
| Attachment D - QA.xlsx | XLSX spreadsheet | |
| Attachment E.4.xlsx | XLSX spreadsheet | |
| Attachment A - SOW.pdf | ||
| RFQ - 951700-25-Q-0009.pdf | ||
| Attachment E.2.xlsx | XLSX spreadsheet | |
| Attachment C - Price Schedule.xlsx | XLSX spreadsheet | |
| Attachment B - TC.pdf |
Show all 13
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
3a - Dummy QC
| Variable Name / Q# | Missing / Incorrect / Query | Issue | |
| DB1 | Incorrect | N=140 caes should be asked DB1 (Filter: IF AC1C=1 OR AC1D=1), but only N=113 cases | |
| DM5A5 | Incorrect | We're not sure which variable contains "English". We can also see 5 variables "T_Q_145_1" to "T_Q_145_5" and one of which is blank. "English" should be asked of all but none of the variables look to be "asked of all. Please could you look into. | Note - these are indicative, not exhaustive. Depending on quality of script, there may be significantly more. |
File details come from the government source that posted it. Updated .