How to Analyze Data from a Google Forms Survey

Value of the Information & Strength of the Argument

The informational value lies in the concrete demonstration of a workflow that is genuinely useful for instructors and students: moving from a Google Forms survey to a CSV export and then to Excel for descriptive statistics and a correlation matrix. The author shows the actual commands, the cleaned data, and the resulting table, which makes the process reproducible. The argumentation is honest and self-critical: he states upfront that Google’s built-in analysis is weak, admits his questions were poorly designed, notes that most correlations are weak and therefore not very interesting, and emphasizes that a good study generates more questions than it answers. He also distinguishes between what frequency distributions can show (single-variable distributions and averages) and what correlations can show (relationships between variables). The main weakness in argumentation is that he treats Likert-type ordinal data as interval data for correlation purposes without discussing that assumption, and he does not address statistical significance, sample size adequacy, or the risk of overinterpreting weak correlations. The pedagogical value is high for beginners, but the analytical depth remains introductory.

Scientific Rigor, Source Quality, Title Accuracy

Scientifically, the video is a classroom demonstration rather than a research report. No external sources, references, or literature are cited, and no statistical tests of significance are performed. The author does show his own written manuscript, including hypothesis, design, results, and interpretation, which adds transparency. The data collection is a convenience sample of his own students, which he acknowledges implicitly by noting he could have sought a thousand responses but settled for something above thirty. The title is fully adequate to the content: the video does exactly what it promises, showing how to export Google Forms data and analyze it in Excel. There is no misleading framing or exaggerated claim. The main limitation is the absence of any discussion of correlation assumptions, effect sizes, or alternative statistical approaches.

The title accurately reflects the content: the video demonstrates exporting Google Forms responses to Excel and running cross-variable analyses such as correlations. It is a faithful, if narrow, description of what is shown.

6/10

The video is a transparent, first-person walkthrough of a small classroom survey workflow. The author openly acknowledges methodological weaknesses (poorly designed Likert items, small convenience sample of 33 students, weak correlations) and shows the raw data, the correlation table, and the write-up. However, no formal citations, no statistical significance testing, no discussion of assumptions (normality, linearity, ordinal vs interval treatment of Likert data), and no peer review are present. Reliability is therefore moderate: honest and reproducible in spirit, but not rigorous in the technical sense.

Markers derived by PSI from the transcript: the creator did not define chapters.

• 00:00Introduction: goal is to show how to collect survey data and analyze it in Excel, with a disclaimer that Google's built-in analysis is weak.
• 01:00Description of the survey design: three Likert-type perception questions plus self-reported GPA.
• 03:00Distribution of the survey via QR code in class and collection of at least 33 responses.
• 05:00Review of Google Forms' built-in frequency distribution graphs and their limitations.
• 07:00Exporting responses as a CSV file and opening the data in Excel.
• 09:00Data cleaning and computation of column averages using the AVERAGE function.
• 11:00Building and interpreting the correlation matrix across all variables.
• 13:00Conclusion: correlations are more informative than frequency distributions alone, and good studies generate new questions.