Nuclear equation of state from ground and collective excited state properties of nuclei