main statistical methods have long been used in all areas of human activity.However, the most important role played by statistics on the economy.After all, this branch of science regulate socio-economic relations of economic entities engaged in the analysis and processing of vast amounts of information.
Very often in economic studies find a solution to a problem in identifying the factors that determine the level of the dynamics in the economy.This often solves the problem of correlation and regression analysis.To achieve the reliability of the analysis is necessary not only to identify certain relationships, but also to quantify these indicators.
regression analysis solves this problem, as a test of the hypothesis of statistics on the presence and strength of correlation.Sufficient number of factors that influence the processes in the economy, are not random variables.This fact is a prerequisite for the analysis of economic phenomena in terms of relations between random and non-random values.These communications are called regression and, accordingly, a statistical method that their studies - regression analysis.
Due to the continuous development of computer technology, the use of computer technology is increasingly used in statistical calculations.Thus, the use of specific computer programs of statistical information allows you to quickly solve the problem on the relationship of various parameters using regression analysis.
So, correlation and regression analysis (example is a) quite clearly shows its use with the help of Microsoft Excel for data processing exchange rates.The package itself
Microsoft Excel allows you to solve complex statistical and engineering problems using a special set of tools for analyzing the data.Correlation and regression analysis in Excel is performed with the obligatory indication of the input data and the choice of the initial parameters.Self analysis is carried out using a statistical macro (you can use the engineering functions), the result is placed in the output range that can be set by the user.If other means of software, it is possible to obtain the result graphically.
With graphic analyst can see a visual representation of statistical data.This mode considerably facilitates the perception and understanding of the results.
For example, in the reduction of statistical data in the table is sometimes difficult to detect errors or inaccuracies.Presentation of data in a graph allows you to quickly and easily detect deviations and anomalies, a sharp increase or drop in the data, although the table does not portend such negative moments.
Correlation is a tool package Microsoft Excel.It can be used to quantify the relationship of several data sets.Correlation analysis allows you to set the relationship data sets in magnitude.For example, there are such things: "positive" correlation (higher values of one data set associated with the same high values of another array), "negative" correlation (small values of a data set associated with the same values of another array), and the correlation is zero (datatwo arrays are not connected).Regression analysis in Microsoft Excel is plotted using a statistical method such as least squares.
Thus, correlation and regression analysis is much easier to carry out with the use of modern computer technologies to get the desired result in the shortest time.
