This ANOVA Statistical Analysis Spreadsheet Tool has been designed to help make sense of the results of on-farm trials and try-outs.
Don’t start statistical analysis until you’ve checked that all data is present and correct. If you come across data that is clearly incorrect it is better to delete it than to include it in your analysis.
This ANOVA tool will statistically analyse your data but it can only be used on quantitative (numerical) data. Statistical outputs like the P-value and LSD will help you make sense of the trial results.
Interpreting your data requires consideration of both quantitative and qualitative information. Analysing the implications of your trial results relies on your judgement. Record the outcomes and your conclusions for future reference and for sharing with others.
Click to download a copy of the ANOVA Statistical Analysis Spreadsheet
Save your file for future reference.