Defining a "sweet spot" may have various possible meanings, given that the idea involves some aspects of what "feels good". Bearing that in mind, there is one mechanical definition that can be dealt with fairly easily by mathematics and also by a simple experiment.
The simple mechanical definition I will describe below considers the bat as a rigid mass, with one point where the ball impacts the bat, and one point where the player's hands are holding the bat. Somewhere between those two points will be centre of gravity of the bat. Impact with the ball causes two superimposed movements i) rotation about the bat's centre of gravity and ii) linear translation of the entire bat.
Movement i) causes the handle of the bat to jerk in the opposite direction to the original velocity of the ball. Movement ii) causes the handle of the bat to jerk in the same direction as the original velocity of the ball. The idea in this theory is that if these two jerking movements cancel out then the player will feel that the bat is "sweet" since there will be little shock transmitted into the players hands when striking the ball. This "sweet spot" is actually a combination of both impact spot and hand grip position.
This idea of a sweet spost can be calculated as below, or found by a neat pendulum experiment. It makes no difference how fast the bat is swung in this definition of a sweet spot. The behaviour remains the same for any impact speed.
Calculating the sweet spot:
Let impact point be distance x from the bat's centre of gravity.
Let the hand grip position be distance y from the bat's centre of gravity.
Impact point ---- centre of gravity ----- hand grip, are all in a straight line with the CofG between the other two.
During impact with ball, at any instant, there is some force F acting on the bat at the impact point.
Linear acceleration of the entire bat = F / mass of bat
The entire bat is subject to this acceleration, including the part of the bat at the handle position.
Angular acceleration of the entire bat = F.x / I
where F.x is the turning moment of the force = Force times distance from CofG
and I is the moment of inertia of the bat.
The angular acceleration of the bat gives rise to a linear acceleration at the handle position = Angular acceleration . y
If the two accelerations at the handle position are equal and opposite they can cancel out.
For that to occur we must have,
F.x.y/I = F/m
Which simplifies to give
I = m.x.y
where I is the moment of inertia of the bat
m is the mass of the bat
x is the distance from CofG to impact point
y is the distance from CofG to hand grip position.
To use the equation I = m.x.y to find sweet spot combinations of x and y you need to know m and I.
m is easy enough - just weigh the bat.
I is more difficult. You need to find a way to measure or calculate the moment of inertia of the bat.
Alternative method: Measuring sweet spot by experiment:
The equation I = m.x.y has another interesting implication.
If the bat is suspended as a pendulum, pivoting about point x, or inverted and pivoting about point y, then the period of swing of the pendulum will be the same in both cases.
Many years ago, when I encountered this theory in a dynamics textbook, I recall that the two points at x and y were called "conjugate points" of a pendulum. Google searching "conjugate points" today shows many other current meanings.
This gives a simple experimental method of determining sweet spot.
Suspend the bat betweet two pin points pushing into the hand grip area so it can swing as a pendulum, and count the number of swings of the pendulum in one minute say.
Then invert the bat, placing the pin pivot in the striking area of the bat and time the swings again. Move the pivot point up and down the bat until the swing period is equal to the original measurement made when pivoted at the hand grip... and that is the theoretical sweet spot.