Podrobný výpis o publikaci

Regression analysis is widely used in situations where it is necessary to determine the dependence of a certain quantitative (continuous) variable on one or more other quantitative (continuous) variables, so-called regressors. It is necessary to determine in advance which variable is independent (explanatory) and which is dependent (explained). The aim of the regression analysis is to describe this dependence using a suitable mathematical-statistical model. The presented paper aims to find the possibilities of using this method in strategic management as a suitable tool for investment and operational activities. Appropriately used regression analysis can find connections, for example, between the volume of mining and macroeconomic indicators of the national economy and the application of these results appears to be another tool for better, more efficient and competitive business management in all sectors of the economy. The theoretical basis of the method is applied to selected sectors of companies such as trade unions, industrial companies, etc. In the research, a tool is created in the MS Excel environment, which can find suitable dependencies according to defined parameters. Based on these results, the management of any company can better define their decisions, whether of a strategic or operational nature. The standard MS Excel package is chosen because it is part of most operating systems in companies and it is not necessary to choose more sophisticated statistical tools for basic knowledge of the issue. The results of the article will be further investigated in the form of more sophisticated systems in the field of mathematical and statistical models.