What I Expect for Text Fields

• Name the worksheet appropriately
• Add a comment at the top with a quick description of the worksheet
• Count
  • The number of non-empty cells (counta)
  • The number of numeric cells (count)
  • The number of blank cells (countblank)
  • The number of NAs (countif)
• For any text with a small number of unique instances
  • Build a table of unique values
  • Count the number of times each value occurs.
  • Build a chart, perhaps a pie chart displaying the values.
• For text with a large number of unique instances
  • Build a table of unique values
  • Count the number of times each value occurs.
  • Rank the data by occurrence.
  • Build a chart showing the most frequently occurring values
  • Perhaps count the number of unique, duplicated, ... values.
  • Perhaps build a chart displaying the number of unique, duplicated, ... values.
• Provide any other analysis that seems important for your analysis.
• Add this information to your methods document.
  • Discuss any interesting or important findings.