Does one weight yarn go further than another?

Maybe it's obvious to some, but I haven't really worked with different weights. Obviously you usually get more yardage the thinner you go, but it also knits up smaller...

Trying to decide between a 2 weight and a 4 weight, and wondering if I should go with balls of a 2 that are about 360 yards, or if I should get balls of a 4 that are 270 yards.