Tips for Best Results
💡 Tips for Best Results
Section titled “💡 Tips for Best Results”Preparing Your Data
Section titled “Preparing Your Data”- Clean your data — Remove test responses, duplicates
- Check encoding — Use UTF-8 for CSV files
- Handle blanks — They will be cleaned up automatically, so you don’t need to worry about them
- Consistent format — Same structure across all sheets
Choosing Settings
Section titled “Choosing Settings”| Scenario | Recommended Settings |
|---|---|
| First-time analysis, exploring data | Auto categories, 4% threshold |
| Tracking study with existing codes | Use template, freeze codes ON |
| Detailed analysis needed | Lower threshold (1-2%), more categories |
| Executive summary needed | Higher threshold (5-10%), fewer categories |
Reviewing Results
Section titled “Reviewing Results”- Check category names — Do they make sense for your data?
- Review “Other” — Are important themes being missed?
- Spot-check assignments — Verify a sample of codings
- Adjust if needed — Re-run with different settings