Frenzied units are not affected by other psychology. So long as they are frenzied, they are immune to panic, fear, terror, hatred etc, and do not have to make these tests. Note that this immunity only extends to Psychology tests. It does not include Break tests in close combat which must still be taken as normal. Frenzied troops cannot flee as a charge reaction - they are too consumed by their eagerness to fight!