Relation of the photon yield from a sputtering source to the population distribution and excitation function