Becoming a good leader is not easy

As a non-athlete I’m really rather fascinated by that coach on the sidelines in sports—what do they actually do? Some of them do shout a lot, and jump up and down. Does that really make a team play better? If so, how? And how does business coaching work: is there a lot of excited yelling in that too? What role should a really good coach play, or shouldn’t play?