Mixed-Data Survey Synthesizer

Pro v1.0.0 1 view

Analyze surveys with both quantitative ratings and qualitative text responses to generate integrated insights showing which themes drive high/low scores.

What You Get

Understand WHY ratings are what they are by correlating qualitative themes with quantitative scores, producing actionable insights that connect numbers to stories.

The Problem

Product managers and researchers struggle to connect survey ratings with open-ended feedback. They analyze numbers separately from themes, missing the crucial insight of what drives satisfaction. Manual correlation is time-consuming and error-prone, leaving teams with statistics that lack context and themes without quantified impact.

The Solution

This skill performs integrated mixed-methods analysis: calculates descriptive statistics for all rating columns, extracts themes from text responses, then correlates themes with rating segments to identify drivers. It produces stakeholder-ready reports where every number connects to qualitative evidence, showing exactly what drives high and low scores with quantified impact.

How It Works

  1. 1 Load CSV and validate data quality for both quantitative (ratings, scales) and qualitative (text) columns
  2. 2 Calculate descriptive statistics (mean, median, std dev, distributions) for each rating column
  3. 3 Extract 5-10 major themes from open-ended responses with frequency counts and example quotes
  4. 4 Correlate themes with rating segments to identify what drives high vs low scores
  5. 5 Perform segment analysis by demographic groups if provided
  6. 6 Synthesize integrated narrative connecting every statistic to qualitative evidence
  7. 7 Generate stakeholder report with executive summary, correlation matrix, and prioritized recommendations

What You'll Need

  • CSV file with survey responses containing both rating columns and text columns
  • Column descriptions indicating which are ratings, which are text, and scale used
  • Minimum 30 responses recommended for meaningful correlation analysis