From Data to Action: An Adaptable Crosstabs Template for Participatory Survey Data Analysis

Authors

• Natalia Pinzon, University of California, DavisFollow
• Vikram Koundinya, University of California (UC)-Davis & UC Cooperative ExtensionFollow
• William O'R Dowling, RhizobiaFollow
• Ryan Galt, University of California - DavisFollow

Volume

63

Issue

2

Abstract

We present a practical and accessible template for quantitative survey data analysis designed for non-academic researchers in order to facilitate engagement from community collaborators. The template, created in Google Sheets, is mainly for computing cross-tabulations, but it also displays frequency distributions and p-values for determining statistical significance. The template allows collaborators to record their observations and questions, promoting an efficient yet interactive review process and fostering a democratic analysis environment. Based on our own experience using this template for a data party, we highlight its effectiveness in promoting collaborative data interpretation, decision-making, and the actionable use of survey findings.

Creative Commons License

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 4.0 License.

Recommended Citation

Pinzon, N., Koundinya, V., Dowling, W. O., & Galt, R. (2025). From Data to Action: An Adaptable Crosstabs Template for Participatory Survey Data Analysis. Journal of Extension, 63(2), Article 17. https://doi.org/10.34068/joe.63.02.17