Alexander L. answered 09/01/19
5+ Years Private Tutoring Experience in Organic Chemistry
Like dissolves like. I can't provide a formula for such a question. However, alcohols dissolve well in water for the same reason that they don't dissolve well in organic solvents. The ability to lose an H+ allows dissociation in water. However, as the chain length increases in hydrocarbons (organic, non-polar components) and the molecule becomes less and less soluble in water and more and more soluble in something organic like DMSO.
So dodecanol has a higher solubility in DMSO than ethanol, but ethanol has a higher solubility in water than dodecanol.