Understanding Members Survey Over Time

The Approach

The project utilised data analysis using Excel.The data was received in an Excel spreadsheet with a row for each respondent and a column for each question (or part depending on the form of the question).

Summary statistics were produced for each question including noting the number of respondents who left a question blank, the number who responded “Would prefer not to answer” and the number who responded “Other, please specify”. The qualitative answers were summarised and common threads amongst them were noted in the resulting report.

"The volunteer was brilliant to work with and provided exactly what we requested and needed. Our project was completed on time and to an excellent standard.”

The Client

The National Federation of Women's Institutes (NFWI) is an education charity that focuses on women learning new skills together and benefitting from life-long learning and self-development. They also campaign for change, with all their campaigns coming from their members.

The Client's Problem

The NFWI conducted a membership survey in 2020. They repeated the survey in 2024 and wanted an analysis undertaken of the 2024 results and a comparison made between the results from the two surveys.

The Solution

• The only deliverable was a report covering the 2024 results and the differences, where there were any, between those from 2020 and those from 2024.
• Amongst the things covered in the report were the proportion of respondents giving each answer. Where the proportions differed significantly between the surveys, comments were offered as to possible explanations for these differences (e.g. change in age profile of the respondents between the two surveys).

The Benefits