basic operation in excel and eviews
DESCRIPTION
Basic Operation in Excel and EviewsTRANSCRIPT
![Page 1: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/1.jpg)
Bs (Hons)Economics
![Page 2: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/2.jpg)
![Page 3: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/3.jpg)
Addition In Excel: Addition two columns: On Existing data Write in Command Bar
=sum(b2+c2)
Press enterAddition in Eviews: Addition two variables: Import data Write In command Bar
genr A = x + y
![Page 4: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/4.jpg)
Multiplication In Excel: Multiplication two columns On Existing data Write in Command Bar =sum(b2*c2) Press enter
Multiplication In E Views: Multiplication two variables: Write in command Bar genr B = x*y
![Page 5: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/5.jpg)
Subtraction In Excel: Subtraction two variables: On Existing data Write in Command Bar
=sum(b2-c2)
Press enterSubtraction In E Views: Subtraction two variables: Write in command Bar
genr C = y-x
![Page 6: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/6.jpg)
Division In Excel: Dividing two Columns On Existing data Write in Command Bar =sum(b2/c2) Press enter
Division In E Views: Dividing two Variables Write in command Bar genr D = x/y
![Page 7: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/7.jpg)
Log In Excel: Log two columns: On Variable one Write in Command Bar (log(b2)) Press enterLog In E Views: Log two variables: Write in command Bar genr lx = log(x)
![Page 8: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/8.jpg)
Simple Linear Regression In Excel
Open Excel File Click on Data Data Analysis Select Regression Check Labels Select X,Y Range Click
<Ok>• Simple Linear Regression In EviewsOpen E views ----- file------new------ work file ---- new window with name work file
create will openSelect option work file structure/Un structure typeselect option for data descriptionObservation select------ okAfter pasting the data
Write following command ls y c x
![Page 9: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/9.jpg)
Multiple Linear Regression In Excel Open Excel File Click on Data Data Analysis Select Regression Check Labels Input the dependent (Y) data by first placing the cursor in
the "Input Y-Range” The independent variables are entered by first placing the cursor in the "Input X-Range" field, then highlighting multiple columns in the workbook Click <Ok>
• Multiple Linear Regression In Eviews Open E views ----- file------new------ work file ---- new window with name work file create will open
Select option work file Structure/ Un structure typeselect option for data descriptionObservation select------ okAfter pasting the data
Write following command ls y c x1 x2
![Page 10: Basic Operation in Excel and Eviews](https://reader036.vdocuments.us/reader036/viewer/2022062303/5585ecbed8b42a48148b4b06/html5/thumbnails/10.jpg)
The end