Statistics
ANOVA Google Sheets Homework
Suppose we are interested in studying the effect of different types of fertilizer on the yield of wheat crops. We have collected data from four different farms, each using a different type of fertilizer. The yield in tons per acre for each farm is shown below:
- Farm 1: 2.5, 3.1, 3.5, 3.8, 4.2
- Farm 2: 2.1, 2.5, 2.9, 3.2, 3.7
- Farm 3: 2.8, 3.2, 3.6, 3.9, 4.1
- Farm 4: 2.3, 2.7, 3.0, 3.3, 3.8
To analyze this data using One-Way ANOVA, we would treat the type of fertilizer (i.e., the four different farms) as the categorical independent variable and the yield as the dependent variable. Use One-Way ANOVA in google sheets to find whether there is a significant difference in crop yield between the four farms.
Turn in a Word document answering the following:
Step 1: State hypotheses
Step 2: Set a criterion for a decision.
Step 3: Collect sample data and compute an F statistic.
Step 4: Make a statistical decision.
Step 5: Draw a conclusion and interpret results.
