Well, I will tell you about one of my favourite tools I've found and that is this right here.
http://tools.seobook.com/general/keyword/This will give you searches and results for the big 3 laid right in front of you. Google, Yahoo, MSN.
As far as ratio's that's a bit of a tough one to answer, but I will tell you, that it's much better to optimize for lesser searched terms. You have a much better chance of getting good rankings with lesser searched terms than any of the largely popular one's. You will just want to rank for more of them.
A good rule of thumb is anything over say 1000 to 1500 searches a month may be worth going after. Of course try and find higher one's but these can still be worth going after. To get good traffic from these lesser searched terms you can optimize different pages for different terms and more of them.
When your typing in what the competition is in Google search
type the term in "parenthesis", that is your direct competition for the term. When you don't use parenthesis it brings back your overall competition for the term.
Obviously the lesser amount of competing sites for a term the better, again, a good rule of thumb, try to use terms that have less than 1 million competing sites overall, less even better!
Davin