Presentation optimization of research results using the accidential balance method and influence factors that have different equivalents of measurement

Keywords: sensitivity analysis, random balance method, Excel, diagram


The results obtained based on the random balance method are usually presented using scattering diagrams. Their number corresponds to the number of criteria for evaluation, since both impact factors and evaluation criteria can be measured by different units or their values may fall into different ranges of one scale of measurement. In addition, the evaluation criteria may have acceptable limits, and the results obtained in the study may be beyond them. Based on these diagrams it is not convenient to compare the results obtained with each other. Therefore, the aim of the work was to optimize the visual presentation of the results of the study using the random balance method with the factors of influence having different units of measurement, using relative values and their presentation in the same diagram similar to the presentation of the results obtained based on sensitivity analysis.

In the study were analyzed the methods of graphical presentation of results obtained based on the sensitivity analysis and method of random balance, as well as approaches to the construction of diagrams in the MS Excel spreadsheets. The study's objects were the scattering diagrams of the results of the original study. These diagrams showed the influence of quantitative factors (the amount of excipients) on the quality indicators of tablets (time of disintegration of tablets and the resistance to crushing of tablets). The original study was the development of optimal composition and technology of the tablets by direct compression. The composition of tablets was: extract of bilberry leaves and goat’s rue herb and taurine.

We analyzed the construction of matrices of changes in the magnitude of the factors of influence and the values of points along the abscissa axis for constructing a scattering diagram. We substantiated the expediency of using the relative value for the construction of a single diagram for the presentation of all the results of the influence of factors on the criteria of evaluation. The process of constructing a chart based on the type of “histogram with accumulation” is described. The algorithms of construction of data series diagrams (as data sources of the diagram), their representation and methods of calculation of their values are presented. It was proposed to present the series of data using certain graphic images, rather than color shading. This approach allows to see the vector dependence of the change in the value of the criterion on the magnitude of the factor of influence graphically.

The proposed method allows to present on the one diagram the influence of various factors (with different units of measurement or different ranges of values) on several different evaluation criteria, as well as the result of this influence in relation to the admissible limits (standards) of the evaluation criteria.


1. Briggs A. H., Weinstein M. C., Fenwick E. A. et al. Model parameter estimation and uncertainty analysis: a report of the ISPOR-SMDM Modeling Good Research Practices Task Force Working Group-6. Value in Health 15 (2012) 835– 842. URL:
2. Hroshovyi T. A., Martseniuk V. P., Kucherenko L. I. ta in. Matematychne planuvannia eksperymentu pry provedenni naukovykh doslidzhen u farmatsii. – Ternopil: Ukrmedknyha, 2008. – 367 s.
How to Cite
Revyatskyy, I., & Barchuk, O. (2019). Presentation optimization of research results using the accidential balance method and influence factors that have different equivalents of measurement. Farmatsevtychnyi Zhurnal, (1), 76-85.
Pharmaceutical technology