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.


Interested in financial markets beyond the Dow and S&P? Sign up for a free account at ADVFN and get global market data.

New Economancer Advertiser: ADVFN

I’ll keep this short because I know folks don’t like advertisements and sponsored posts. Up to this point the cost of hosting and data gets paid with the help of Google Adsense. Occasionally a product link from Amazon leads to a sale, but I’ve yet to collect enough for the minimum payout with them.

The site has grown enough in traffic that I searched out a reputable advertiser willing to pair with the site. I’m excited to announce ADVFN as that advertiser.

I was very selective and wanted a site that I actually like and use. ADVFN is a great source for global exchange prices. I like them because they provide information other sites charge for, focus on exchanges beyond the United States, and sign-up is free.

So give them a look and consider registering a free account. I promise I’ll do my best to not beat you over the head with the ads.

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.


Interested in financial markets beyond the Dow and S&P? Sign up for a free account at ADVFN and get global market data.

“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.

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.

Interested in financial markets beyond the Dow and S&P? Sign up for a free account at ADVFN and get global market data.