Hypothesis Testing with Spreadsheets – Part II

Is the “height success rate” for seeds grown in organic soil significantly higher than that for those grown in the non-organic soil? Let’s use a statistical test to find out! But before we delve in, let’s review the amazing Central Limit Theorem (CLT). Why so remarkable, you may ask? Continue reading “Hypothesis Testing with Spreadsheets – Part II”

Hypothesis Testing with Spreadsheets – Part I

seedlings2
Seedlings for Experiment. Photo: Amie

What is the impact of organic soil on a seedling’s height? Will an organically-grown seedling be taller than one grown in non-organic soil? Armed with data, we’ll now tackle these questions by performing a statistical test in a spreadsheet!

To see how we our experimental design and data collection method, please see: www.spreadsheetsolving.com/posts/experiment-spreadsheet Continue reading “Hypothesis Testing with Spreadsheets – Part I”

Design & Conduct Experiments with Spreadsheets

seedlings2
Seedlings for Experiment. Photo: Amie

Seeking science experiment ideas? Want to conduct an experiment? Curious about hypothesis testing? Understanding how to design and test an effective experiment is an essential skill. Let’s investigate this research question: What is the impact of organic soil on a seedling’s height?

Spreadsheets are a platform to test an experiment or conduct a research study. With spreadsheets, we can collect & organize data, compute summary statistics, and even test hypotheses!

So, let’s begin our experiment with spreadsheets, statistics, seeds, & soil! Continue reading “Design & Conduct Experiments with Spreadsheets”