BUSINESS INFORM №8-2015

The title and content

ABSTRACTS AND INFORMATION ABOUT AUTHORS

14

Section: Economic and Mathematical Modeling
UDC 336.001.57.004
Hlotov Y. O.
Statistical Analysis of Results of Simulation Modeling the Investment Project with MS Excel (p. 84 - 89)
The article examines the methodology of statistical analysis of source data as well as results of simulation modeling the investment project with MS Excel, based on economic task. A quantification to assess the narrowness of relationship between the random variables in MS Excel is proposed to be carried out in two ways: using the statistics functions COVAR () and CORREL () and using special tools for analyzing statistical data: Data analysis ? Correlation. If the number of the studied variables is higher than 2, a more convenient choice will be to use the Excel analysis tools. Usefulness of the statistical analysis of source data and the results of the simulation experiment is that in many cases it helps to reveal inexactness in the source data, or even errors in the task statement. Statistical analysis also allows to test the hypothesis about the normal distribution of both source data and results. To do this, special statistical criteria by Kolmogorov-Smirnov, Pearson and others can be used. MS Excel provides to quickly and effectively implement a calculation of the required criterion and conduct a statistical assessment of hypotheses by means of the descriptive statistics tool that automatically calculates the characteristics of distributions, which are widely used in practice.
Keywords: simulation modeling, statistical analysis, normal distribution, skewness, kurtosis, correlation
Fig.: 5. Tabl.: 2. Formulae: 6. Bibl.: 12.

Hlotov Yevhen O. – Candidate of Sciences (Engineering), Associate Professor, Head of the Department, Department of Economic and Mathematical Methods and Information Technology, Kharkiv Institute of Finance of the Kyiv National University of Trade and Economics (5 Pletnovskyi Lane, Kharkіv, 61003, Ukraine)
Email: [email protected]

Article is written in Ukrainian
Downloads/views: 55

Download article (pdf) -

Reference to this article:
Hlotov, Yevhen O. (2015) “Statistical Analysis of Results of Simulation Modeling the Investment Project with MS Excel.” Business Inform 8:84–89.

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 |

FOR AUTHORS

License Contract

Conditions of Publication

Article Requirements

Regulations on Peer-Reviewing

Publication Contract

Current Issue

Frequently asked questions

INFORMATION

The Plan of Scientific Conferences

OUR PARTNERS

Journal «The Problems of Economy»

The site and its metadata are licensed under CC BY-SA.

Write to webmaster