How to build a regression in excel

Microsoft Office Excel has many applications in various fields, including such disciplines as econometrics, also employ this software utility. Almost all of the laboratory and practical work is done in Excel.

Instruction

1. To build the regression, use the software Microsoft Office Excel or its analogs, for example, similar utility in Open Office. Thus to calculate the index, use the LINEST():(Znaczenia; Znacheniyah; Const; stats).
2. Calculate the set of points on the regression line using the function called "TREND" (Znaczeniu; Znacheniyah; Novietne; Konst). Calculate using the given numbers unknown value of the coefficients m and b. Actions here may vary depending on this you the conditions of the problem, so check the order of evaluation, after reviewing the additional material on the topic.
3. If you have any problems with the construction of the regression equation, use special literature in econometrics, and use the additional material themed sites, for example, http://office.microsoft.com/ru-ru/excel-help/CH006252831.aspx?CTT=97, http://www.cyberforum.ru/ms-excel/, http://emm.ostu.ru/lect/lect6.html laboratory work in the discipline - http://teacher.dn-ua.com/old_version/excel/. Please note that also the regression equation may be different, so pay attention to additional information in the subject.
4. In the event that you have problems using Microsoft Office Excel download special tutorials on the subject, which is causing you trouble, or enroll in special training courses which is available for almost all cities.
5. This will also make sure that these skills will come in handy in the future, as econometrics is often included in the programs in the faculties of Humanities to expand General knowledge and are unlikely to be useful in the future, for example, lawyers.