A comparative study of the equations of motion, and configuration interaction methods for the calculation of excitation properties of methane and water