Distributed detection over adaptive networks: Refined asymptotics and the role of connectivity