From what I have learnt it is different for every machine. Basically to low and your motors will never reach full speed , two quick and your motors will struggle and stall.
Here is a you tube video that might help
You are trying to move a Mass from stationary to a pre determined speed you would be amazed at what G forces are involved. So a large motor (Lots of power) and a light load can accelerate quickly without a problem but in the opposite case you have to accelerate slowly so the motor isn't driven beyond its limits in order to get up to full speed.
All of the you tube tutorials I have watched have people basically setting by trial and error. Push it until it breaks and bring it back a bit
It looks as though CNC Cookbook has a good article and a excel spreadsheet explaining it in technical detail with a calculator in excel as well (As it was in inches, I found it confusing as I dont use inches). As you are working in inches its probably a good article to read
Here is the link
https://www.cnccookbook.com/ultimate-benchtop-cnc-mini-mill-part-5-acceleration-and-cutting-forces
I would also consider whether you want maximum efficiency (High acceleration - possible lost steps, Stresses on motor and driver circuitry, Increased power usage) or lower efficiency (Lower acceleration - Less stress on machine but longer production time)
I have also heard of larger machines with to high acceleration actually moving and shaking so even if the motors can handle the acceleration, Also every axis is different as the mass you are moving, and gearing ratios, and even drivers and motors could be different
Hope this helps
Steve