Distribution of E2 excitations in sd-shell nuclei