Систематизація даних агрономічного експерименту за допомогою електронних таблиць

Abstract

Розглянуто можливості використання електронних таблиць Excel для первинної систематизації даних, отриманих у результаті проведення агрономічного експерименту. Продемонстровано ефективні способи перекодування та шкалювання даних за допомогою автофільтрів та формул =IF(), =VLOOKUP(), =CONCATENATE(). Створення та аналіз таблиць кростабуляції за допомогою реманенту «Зведені таблиці».

Рассмотрены возможности использования электронных таблиц Excel для первичной систематизації данных, полученных в результате проведения агрономического эксперимента. Продемонстрировано эффективное перекодтрование и шкалирование данных с помощью автофильтров и формул =IF(), =VLOOKUP(), =CONCATENATE(). Создание таблиц кростабуляции с использованием сводных таблиц.

The possibility of using Excel spreadsheets for primary systematization of data obtained as a result of the agronomic experiment is considered. For realizing the systemic entry in the science-related documents, it is necessary to carry out the procedure for re-assigning the data to the signatures of the values, including the data stratification. The purpose of such a systematization is to make the studied system understandable and convenient, simplified, more appropriate for the purpose of the study. For this purpose, the collected data to convert a measuring scale. Measurement Scale - a sign rules for granting studied numerical value. The type of scale chosen principally zalezhateme choice of methods confirm the hypothesis of the study. The number of possible benchmarking criteria influences the choice of type of scale. This means that the criterion can serve as an alternative to any of its sign, the value of which can be detected as one of the possible scales. After such criteria comparable to investigate found, it is possible to compare experiment variations. The purpose of the research is to describe in a simplified and accessible form the basic methods and methods of systematization of the data of the agronomic experiment. The research methodology was to analyze the effectiveness of the tools of systematization of experimental data at the preparatory stage of the study. The main purpose of this publication is to demonstrate the Excel spreadsheet processor to organize data in different types of scales. The problem of data systematization is a cornerstone in the solution of the ABC-XYZ problem in market-making and logistics, VEN analysis-in the pharmaceutical industry, defined structures and quality of the crop in vegetable-growing, in the course of forest tax works, etc. The practical use of these data systematization tools will greatly accelerate the analysis process, improve the quality, and make the conclusions understood. Effective recomputation and data scaling with auto filters and formulas =IF(), =VLOOKUP(), =CONCATENATE().Creating tables of crosstabulation using pivot tables