Quick Guide for Analyzing Public Input

Step 1: Categorize Input Type

Input Type	Examples	Example Methods for Analysis
Quantitative Structured	Surveys (multiple-choice, scales)	Frequency counts, cross-tabs, charts
Quantitative Unstructured	Voting dots, sticker maps	Count totals, map clusters spatially
Qualitative Structured	Open-ended survey comments	Thematic coding, word frequency, sentiment analysis
Qualitative Unstructured	Meeting notes, open house feedback	Thematic coding, cluster key points
Spatial Input	Stickers/comments on maps	Geocode, heat map, GIS overlay

Step 2: Suggested Tools

• Excel/Sheets: Counting, sorting, simple stats

• Survey Software: Download coded data (e.g., SurveyMonkey, Qualtrics)

• Manual Coding Matrix: For small text sets in Excel/Word

• Qualitative Software: For large text sets (NVivo, Dedoose, MAXQDA)

• Mapping Tools: GIS (ArcGIS, QGIS), Google MyMaps for cluster mapping

• Data Visualization Tools: Dashboard tools (Power BI, Tableau), Simple graphics (Flourish, Datawrapper, Excel)

How-To Tips

• Create a simple coding guide: broad themes, test, refine.

• Transcribe sticky notes/meeting notes and group by topic.

• For dot/sticker maps: take clear photos, transfer to GIS or digital image.

• Cross-check results with other data for consistency.

Visualize & Report

• Use simple charts and/or infographics for structured results.

• Use heat maps or pin maps for spatial input.

• Include quotes to illustrate themes.

• Note sample size and any limitations.

• Share a summary back to the community ("Did we get this right?").

Key Principles:

• Match input type to analysis method.

• Keep methods transparent.

• Triangulate multiple sources.

• Document how you coded and grouped feedback.