## Wednesday, June 18, 2014

### How To Run a Regression in Stata, A Quick and Easy How-To Video

Quick and easy instructions on how to use Stata statistical software to estimate simple linear regressions. This video shows how to use both the command line and the top menu to run a regression.
My video tutoral on importing data and spreadsheets into Stata is also on this website.

style="display:inline-block;width:468px;height:60px"

## Thursday, June 12, 2014

### Quick and Easy Ways to Import Data Into Stata

How to quickly and easily import data files into Stata statistical software. Instructions on ways to import csv spreadsheet files, Microsoft Excel files, how to copy and paste data using the edit command, and how to input data manually in to Stata.

style="display:inline-block;width:468px;height:15px"

## Saturday, April 5, 2014

### "What's The Phrase" Zynga Game App Strategy

I've started playing the "What's The Phase?" game app with my family. It's a "Wheel of Fortune" style game by Zynga. I soon realized there is an advantage to going second.
When you go first, you might be tempted to pick common letters so you can fill in as much of the board as possible. Hopefully this would give the player enough of a clue to guess the phrase, but most of the time all I end up doing is sending my competition a board filled in with some key letters. They get to choose three other letters, and by then have a good idea of the answer to the puzzle. Rarely do I get a second turn on a puzzle with my family if I play this way. My guesses followed by their guesses are enough to solve the puzzle.

So here is my strategy when I have to go first: I choose uncommon letters like Q, X, and Z. I don't expect this to help me during my turn, but it means the second player is doing the heavy lifting instead of me. They choose their three letters and I get the puzzle back with a better chance of guessing the answer.

Depending on how competitive and/or sharp your opponent is, they'll soon start picking uncommon letters too. This doesn't ruin the game. If anything, it makes the game more fun because the rounds last longer and we start trying to solve the puzzles by which letters -aren't- in the phrase.

## Wednesday, March 5, 2014

### How To Import a Data File Into R Statistics Program

Quick and Easy Way to Import Data Files Into R Statistics Program

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.

## Thursday, February 27, 2014

### How To Import Files or Manually Enter Data Into EViews 7

How To Import Files or Manually Enter Data Into EViews 7

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.

### How to Run a Regression Using EViews 7

How to Run a Regression Using EViews 7

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.