Особливості використання електронних таблиць в агрономічних дослідженнях

Abstract

Разработаны унифицированные рекомендации по применению эффективных технологий обработки данных агрономических исследований с помощью электронных таблиц. Рассмотрены возможности автоматизированной проверки данных и их предварительного анализа. Результаты могут быть использованы в среде специализированных программ.

Spreadsheet use general problems in agricultural research data analysis and ways of their resolutions.Purpose: Provision to researches of uniform rules, guidelines, and effective technologies in creating and processing of the large data volumes in MS Excel (Windows, Microsoft Office) and its analogues.Results: The article contains recommended options of the spreadsheet use expediency, general rules for data sets creation and primary information transformation, effective methods of automated data verification, data preliminary analysis and preparation for its use in specialized programs.Technology of the automatic cell filling marker function, window shapes, data validity verification, sorting, filtering, elements of descriptive statistics, built-in features and error visualization tools are proposed for the data sets creation.Efficient technologies of the group-averages tables using subtotals calculation are recommended for the preliminary comparative analysis. Preliminary result preparation methods for the use and further in-depth analysis with specialized software are shown.Particular attention is paid to discussing the possibilities in grouped tables application. Useful examples of their use in agricultural research are given. In particular, we show methods of the absolute and relative difference calculations, data grouping, cumulative conclusions receiving, parameters structure defining, and graphic interpretation of the grouped tables for the existence visual determination of the significant differences between the variants.