Attachment E.4.xlsx
XLSX spreadsheet 19 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 appears to be a quality control spreadsheet (Attachment E.4) detailing data issues and interviewer concerns for a survey project. The document highlights several data quality concerns, including filtering inconsistencies in survey responses (e.g., discrepancies in response counts for questions RLO11B, VOAB5H, and DB1Z), problematic interview durations (some negative or under 10 minutes), and questionable interviewer behavior patterns. Specific concerns are raised about multiple interviewers completing over 10 interviews per day and high rates of first-attempt completions, suggesting possible shortcuts in proper household rostering and random walk procedures.
This document is related to a solicitation (951700-25-Q-0009) from the U.S. Agency for Global Media (USAGM) for Survey Data Quality Control Services, which will be awarded as a Firm Fixed Price (FFP) Blanket Purchase Agreement (BPA). The opportunity is designated as a 100% small business set-aside.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFQ - 951700-25-Q-0009 - Amendment 00001.pdf | ||
| Attachment A - SOW - Amendment 00001.pdf | ||
| Attachment D - 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 A - SOW.pdf | ||
| RFQ - 951700-25-Q-0009.pdf | ||
| Attachment E.2.xlsx | XLSX spreadsheet | |
| Attachment E.5.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
5a - Final QC
| Variable Name / Q# | Missing / Incorrect / Query | Issue |
| RLO11B | Filter/Data Incorrect | There are N=14 resondents who answered RLOB11B but according to survey filtering should have been 14. |
| VOAB5H | Filter/Data Incorrect | According to the QQ, only N=25 respondents should be asked VOAB5H but there are 77 responses. |
| DB1Z | Filter/Data Incorrect | 506 respondents should have answered DB1Z, but only 26 did. |
| DURATION | Interviewer Issues | Many interviewer durations are either negative or under 10 mins. |
| Interviewer Completes per day | Interviewer Issues | Interviewers 1, 2, 3, and 7 have over 10 completed interviews in a single day. Please confirm that these interviews were conducted properly, including accurately rostering the household, conducting the random walk, no questions were skipped, time of day the interviewer worked, and the interviewer did not rush the interviews. |
| interviews completed on the first contact attempt. | Interviewer Issues | Over 60% of interviewers completed over 90% of their interviews on the 1st contact attempt (Interviewers 4, 7, 37, 22, 94, 55, 24, 64, 12, 15). Please confirm that these interviewers were accurately rostering the household, interviewing the selected respondent, and conducting recontact attempt (i.e. did not replace the household prior to condcuting 2 recontact attempts). | NOTE: Typically, there are 10-20 QC flags of this nature per project |
| Household size by interviewer | Interviewer Issues | 7 interviewers (15, 66, 34, 52, 28, 23, and 44) had ovr 50% of their completed interviews conducted with 2 person households. Many also conducted a significant portion with single person household. Please confirm that interviewers were properly rostering households. |
File details come from the government source that posted it. Updated .