Calculating Summary Statistics in Google Sheets

In this activity, students work together to analyze microbial diversity data to determine the effectiveness of using hand sanitizers versus hand-washing with soap. Student teams use Google Sheets to calculate summary statistics, visualize trends, and perform hypothesis testing, all while focusing on understanding the logic behind the formulas.

Publication Details

Journal
QUBES
Published
2025-01-01
DOI
https://doi.org/10.25334/jxvx-mb20
Primary Topic
Various Chemistry Research Topics
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Calculating Summary Statistics in Google Sheets

QUBES
Various Chemistry Research Topics
article

Calculating Summary Statistics in Google Sheets

article en

Abstract

In this activity, students work together to analyze microbial diversity data to determine the effectiveness of using hand sanitizers versus hand-washing with soap. Student teams use Google Sheets to calculate summary statistics, visualize trends, and perform hypothesis testing, all while focusing on understanding the logic behind the formulas.

QUBES
Openalex Percentile: Top 52%
Various Chemistry Research Topics
DOIOpen Access PDFOpenAlex
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Calculating Summary Statistics in Google Sheets · QUBES (2025) | TGRS Research Map | TGRS