Keyword: «ms excel»

The analysis of possibilities and difficulties of application of a method of projects is carried out. To be more general, students scientific work while studying computer science is analyzed. Students of economic and legal specialties are considered. The evaluation of a teachers labour costs necessary for carrying out this type of work is given. There is an example of a student's work executed in MS Excel

The article deals with the comparative analysis of the performance capabilities of the regression analysis automation by means of econometric programs and MatLab. It considers the problems arising when the multi-factor linear regression analysis by the use of MS Excel is carried out and the problems connected with the solution of the high order linear equation systems and nonlinear econometric models construction. While solving the analogues tasks the advantages of MatLab system are revealed. The particular example gives the description of methodology of choice of the type of analytical dependence at the stage of econometric model specification with a help of built –in graphical tools of MatLab system. It is shown how the results of such choice can be used in MatLab system during the construction of linear and nonlinear models based on Statistics Toolbox instruments. The construction of the approximating model was carried out both by means of MS Excel and MatLab using the polyfit and nlinfit functions. The quality of the regression equation obtained was estimated by the coefficient of determination value. The results of the experiment conducted show that the use of MatLab system in econometric research can considerably simplify the process of carrying out the regression analysis.

The paper deals with the methodological questions of using computing experiment in economic and mathematical modeling with the use of MS Excel and VBA programming environment.