What the above article says is that the first few modes of the bat have nodal lines at roughly the same point. This is the "sweet spot". A ball impacting at this point does not excite many modes. As a consequence less of the ball's energy is transferred to vibrations in the bat. This has two effects: 1 The ball bounces off the bat faster and 2 the hitter feels less jarring and vibration as there is less vibrational energy transferred to his/her arm.
If you have performed a modal analysis on the bat then it is relatively straightforward to calculate which modes will be excited and to what degree. The maths behind it can be found in modal analyis texts (eg D Ewins "Modal testing: theory and practice"

. It involves some very basic matrix maths, and is therefore difficult to write in a post here but in words...
From the modal analysis you get information on Natural frequency, modal mass, damping ratio and mode shape for each mode you have tested. These 4 parameters completely describe the structural dynamics up to the frequency of the highest mode you have tested (under the assumption that the structure is linear and that damping is "proportional", both reasonable assumptions).
From these parameters there are simple relationships which will give you the modal damping and modal stiffness for each mode. Arranged into diagonal matrices, these form the modal mass, modal stiffness and modal damping matrices. These are directly analogous to the mass, stiffness and damping matrices in physical space and we can calculate a frequency response matrix in exactly the same way...
H = 1/( -M*omega^2 + C*j*omega + K )
This is the FRF matrix in "modal space". The FRF matrix in physical space tells us how much response we get at point x if we apply a force at point y. The MODAL FRF matrix tells us how much response we get in mode x if we apply a force to mode y.
So if we know exacly how much force the impacting ball is applying to each mode of the bat (the modal force), we can determine exactly how much each mode will responsd by using the modal FRF matrix.
The trouble is that we don't know the modal force. We can however estimate or measure the actual physical force and it is possible to convert this force to a modal force.
If we arrange our measured mode shapes, obatined from the modal analysis, into the columns of a matrix, then we have the "modal matrix" of the system, phi. The size of the phi matrix is n rows by m columns, where n is the number of measurement positions on the bat and m is the total number of modes we are considering. Let's assume that to all intents and purposes, the force applied by the ball on the bat occurs at a single point. We can define a vector of applied forces at each measurement point. Each element in this vector will be zero except the element correstponding to the position where the impact takes place. We can now find the modal force simply by multiplying the transpose of the modal matrix by the force vector to give us a modal force vector.
So we now have the modal force vector, F, and the modal FRF matrix, H. The modal response vector, X, is then given simply by
X=H*F
The elements of the response vector X tell you exactly what you need to know ie. the degree to which each mode is excited by the impact of the ball.
I realise that what I have said here is not enough to allow you to do the calculation, but if you read this in conjunction with a text book you may find it useful.
M