Skip to content

Sample project · Survey data analysis

Survey of 190 adults: charts and plain-language findings

A raw survey sheet of 190 rows with coded answers and blank cells, with no summary tables, charts or explanation of what the answers show.

This is a sample project using sample survey dataset of 190 respondents (age, children, education, happiness, health, income, relationship status, religiosity). It is not paid client work.

What I did

Built frequency tables for each key question, turned them into the right chart for each type of data, and wrote a short plain-language interpretation under every chart.

  1. 1Checked the raw data and flagged missing answers instead of guessing them
  2. 2Grouped ages into ten-year bands and counted every category
  3. 3Picked the right chart for each question (histogram for age, bar for relationship status, pie for happiness, line for education)
  4. 4Wrote a plain-language interpretation under each chart

The work

Raw survey spreadsheet with 190 rows of coded answers and some blank cells
Before: raw survey data
Bar chart of respondents by relationship status with frequency table and interpretation
After: relationship status bar chart
Histogram of respondent age in ten-year groups
Age histogram
Stem-and-leaf plot of respondent age
Age stem-and-leaf plot
Pie chart of reported happiness
Happiness pie chart
Line chart of years of education completed
Education line chart

Key findings

  • Married is the largest group: 93 of 190 people, about 49%
  • About 58% of people who answered say they are pretty happy; 14% say not too happy
  • Education peaks at 12 years (63 people) with a second peak at 16 years (32 people)

Tools

Excel

Delivered

Excel workbook with a data sheet and seven chart sheets

Result

Seven ready-to-read sheets: histogram, bar chart, box plot, stem-and-leaf plot, pie chart, line chart and frequency table, each with its own interpretation.

WhatsApp
Request a quote