Skip to Main Content
UMass Chan Medical School, Lamar Soutter Library. Education. Research. Health Care. Empowering the future. Preserving the past.
UMass Chan Medical School Homepage Lamar Soutter Library Homepage

Analysis-Ready Data Sets Tutorial

Step by step tutorial on how to make your data analysis-ready using Excel or REDCap.

Validation Review

Best Practices 4 and 5 for Validating Data Sets

  1. Plan for “other” data responses.
    Lists of answers to single-answer questions should include all possible responses. To encompass all the possibilities, include an “other,” category as answer and create a text box to capture the information.
  2. Plan for “prefer not to answer”
    Leave a place for the interviewer to record “did not choose to answer” or “does not know.” This will avoid null data.