Common errors in filling in spreadsheets and how to avoid them
Errors during research can occur not only at the stage of planning, data collection and statistical analysis, but also at the stage of filling in spreadsheets. In most cases they can be easily corrected, otherwise results may be distorted. These errors can be categorized into invalid format and input errors. In the first case, the mixing of the absence of data and the zero values is especially dangerous, since it can lead to systematic errors: overestimation (if the zero values are filled in as the absence of data) or underestimation (if the absence of data is filled in as zero values) of the mean or the prevalence. Input errors are most often random, and their effect decreases with increasing sample size, but for the better analysis they should also be corrected as much as possible. The article provides an algorithm that allows you to find input errors and correct them before statistical analysis.