An effective operator approach based on the coupled cluster method is described and applied to calculate vibrational expectation values and absolute transition matrix elements. Coupled cluster linear response theory (CCLRT) is used to calculate excited states. The convergence pattern of these properties with the rank of the excitation operator is studied. The method is applied to a water molecule. Arponen-type double similarity transformation in extended coupled cluster (ECCM) framework is also used to generate an effective operator, and the convergence pattern of these properties is compared to the normal coupled cluster (NCCM) approach. It is found that the coupled cluster method provides an accurate description of these quantities for low lying vibrational excited states. The ECCM provides a significant improvement for the calculation of the transition matrix elements.