The ball is not pulled horizontally: it is pulled by the string at an angle with respect to the vertical. Two forces act on the ball: the tension of the string (T) and gravity (G). The ball moves along a horizontal circle (of radius r) if the resultant of these forces is horizontal. That horizontal resultant is the centripetal force. T
The tension in the string has horizontal and vertical components. The horizontal component provides the centripetal force:
Tsinθ=Fcp=mrω2.
The vertical component acts against gravity and if it is greater than G the ball will rise. The ball can move along a horizontal circle with angular speed ω if the vertical component of the tension cancels gravity:
Tcosθ=G
The radius of the circle is r=Lsinθ.
Tsinθ=mLsinθ ω2->
T=mLω2
and
cosθ=G/T=G/(mLω2).
The faster the ball spins the greater ω; the greater the tension in the string. Also, increasing ω involves decreasing cos(θ), that is, increasing the angle the string makes with the vertical. If θ is greater the ball spins higher.
ehild