Cthugha said:
This is true, but it should be stressed that it is only the superfluid fraction that approaches 100%, not the condensate fraction. Due to strong depletion of the ground state caused by the interactions, the condensate fraction is much less, on the order of 10% and the excitation spectrum becomes well populated.
I think this is an important distinction which clearly (as the other posters in this thread has noted) confuses people.
The basic idea of a Bose-Einstein Condensate is that you have non-interacting bosons (in this case meaning they take, statistically, the Bose-Einstein distribution in equilibrium) which nevertheless condense --- this is novel because normally gasses condense due to long-range attractive interactions (usually some dipolar interaction)! In the case of a BEC, no long range attractive interaction is needed, but purely because of quantum statistics.
On the theoretical side, a BEC is necessarily a single-particle theory, i.e. it describes a state of many particles as a simple (symmetrised) product of single particle states.
Real systems have interactions, which cause their real many-body quantum state to *not* be expressible in such a simple fashion, and thus in theory strictly speaking it does not really make sense to call them BECs because no Bose-Einstein distributions are in sight.
Nevertheless, for weakly interaction atomic gasses, one can show (both theoretically and experimentally) that the actual state is very close (large overlap) with the simple BEC state. Thus we can approximate it, and talk about the atoms in them as if they are essentially non-interacting. The self-consistency check is the "condensate fraction" (which is an awful term, because it doesn't measure anything of the sort) --- a non-interacting BEC would have a condensate fraction of 100% at 0 kelvin, and it changes reasonably smoothly with interaction strength.
Nevertheless, one intuitively feels that actually a dilute weakly interacting Bose gas and superfluids proper (strong interactions) are quite similar --- for one thing in theory there is no phase transition as you change the interaction strength! This is possible, but unfortunately is quite mathematical and not really appropriate to go into here. For the specialists, I will mention that the best unifying view I have come across is to consider the spectral distribution of the single-particle density operator --- the canonical reference should be Leggett's book on Quantum Liquids.