Microsoft Office Excel has many applications in various fields of activity, including such a discipline as econometrics, which also uses this software utility in its work. Almost all actions of laboratory and practical work are performed in Excel.
Instructions
Step 1
In order to build a regression, use the Microsoft Office Excel software or its analogues, for example, a similar utility in Open Office. In this case, to calculate the indicator, use its LINEST () function:(Values_y; Values_x; Const; statistics).
Step 2
Calculate the set of points on the regression line using the function named TREND (y-values; x-values; new_x-values; const). Calculate the unknown value of the coefficients m and b using the given numbers. The steps here may vary depending on the problem condition given to you, so check the calculation order by looking at the additional material on this topic.
Step 3
If you have problems with the construction of the regression equation, use special literature on econometrics, and also use additional material from thematic sites, for example, https://office.microsoft.com/en-ru/excel-help/CH006252831.aspx? CTT = 97, https://www.cyberforum.ru/ms-excel/, https://emm.ostu.ru/lect/lect6.html, laboratory work on this discipline - https://teacher.dn-ua.com / old_version / excel /. Please note that also the regression equations can be different, so pay attention to the additional information in the topic.
Step 4
If you have problems using Microsoft Office Excel, download special video tutorials on a topic that is causing you difficulties, or sign up for special training courses that are available in almost all cities.
Step 5
At the same time, make sure that these skills will be useful to you in the future, since econometrics is often included in the programs at humanitarian faculties to expand general knowledge and is unlikely to be useful in the future, for example, to lawyers.
