Statistical Analysis of Results of Simulation Modeling the Investment Project with MS Excel
Journal Title: Бізнес Інформ - Year 2015, Vol 8, Issue 0
Abstract
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.
Authors and Affiliations
Yevhen Hlotov
Keywords
Related Articles
- EP ID EP122569
- DOI -
- Views 120
- Downloads 0
Complex Assessment of Efficiency of Regional Systems of Solid Waste Utilisation
The problem of utilisation of solid waste is one of the most important ecological-economic and social problems of regional development. At the same time it should be taken into account that justification of investments i...
Organisation of Strategic Management of a Holding Structure under Conditions of Unpredictable Changes of Environment
The article develops a model of influence of environmental factors on strategic plans, which allows transformation of planned indicators into forecasted values. It presents a classification of main environmental factors,...
Concept of Building a Mechanism of Management of Development of Cluster and Network Structures
Cluster structures give a significant impulse to development of both states with a developed economy and developing countries. In spite of this, formation and development of cluster structures in Ukrainian economy are mo...
Specific Features of Reflection of Information Regarding Lease Operations in the National and International Standards
The article identifies the degree of correspondence of the national Provisions (Standard) of Business Accounting (PSBA) Lease with the international standard and provides recommendations with respect to their closing up....
Managing Recreation Enterprises Efficiency under Conditions of Informatisation and Globalisation of Economy
The goal of the article is development of recommendations on improvement of the recreation enterprise efficiency management mechanism with consideration of new tendencies of globalisation and informatisation of economy....