Before you import data into the R statistical program, save your data file as a .csv (comma separated values). You can do this in Excel or OpenOffice by doing a “save as” and selecting .csv. Don’t put spaces in the file name. It also helps to save the file on a jump drive so the file location will be easy to type into the R console.
In my example, I type in the name I want to call the data, the request to read.table, the file location and file name, a command that tells the program to expect a header at the top of the columns. Make this FALSE if you don’t have names at the top of your columns. Finally I type out that the data is separated by a comma. Watch the video for the exact command. YouTube doesn’t like lines of programming in the video description.
If you do it right, the program will not really respond. If you made an error, the program will tell you. Confirm you’ve imported the file by typing the name you gave the data and pressing return. You should then see all of the data on the screen.
This video shows three ways to import data files into EViews 7. It also shows how to manually input data into the program.
The easiest way to bring a file into EViews is to click the file and drag it into the program. Sometimes this method doesn’t work, especially with older versions of EViews.
The second way is to open a work file in EViews, then select “File” then “Import” from the top menu. Navigate to the spreadsheet or other data file and click OK.
The third way is to open a work file in EViews and open the data file in a spreadsheet program like Microsoft Excel or OpenOffice. Select the data you want to import, right-click and copy or press Ctrl+C, then paste into the EViews work file by right-clicking and paste or by pressing Ctrl+V.
Manual data entry in EViews is done by opening a work file, click on “Quick” in the top menu and select “Empty Group”. You can then manually input your data like a spreadsheet. Click “Name” at the top of the spreadsheet box, give the set a name, and you will now have your data in the work file.
A quick and easy tutorial of ordinary least squares regression analysis using EViews 7 student version statistical software.
Once your data is imported into EViews, select “Quick” on the top menu bar, then click on “estimate equation”. In the box that opens, type in the exact file name of your dependent variable, the letter “c” for the constant term, followed by the names of your independent variables. Press “OK” and the program gives you the results of the OLS regression.
An alternative way to run this regression is to us the command line by typing the letters ls, space, dependent variable name, space, the letter “c”, space, the independent variable names with spaces between each. For example, my sample regression in the video is:
ls gdp c cpi m1
Press enter and the same regression results will appear.
Jodi Beggs was giving the following task: “Could you talk a little bit about what behavioral economics is? And about your site? And about the economics of The Simpsons? Oh, and this meeting is joint with the Finance and Investing Club, so could you make it relevant to finance as well? By the way, you have 40 minutes.”