I think it depends on a combination of speed, gear, engine load and its there so that it will pass the drive by noise tests which are very prescriptive.

I suppose it might also have something to do do with back pressure in the system to smooth out the power/torque curves but somehow I doubt it.