Looking for the excel formula for the Standard Deviation of the velocity of the bullet. Believe my chrono only uses up to 8 inputs to calculate the ES and SD. I want to run the numbers based on a greater number of inputs.
SD excel formula
- Thread starter FTRinTexas
- Start date
Thanks Dave.
Erik Cortina
Team Lapua Brux Borden Captain
What about ES? Is there a formula in Excel to do that?
I know I'm being lazy, but if it's there why not use it! ;D
I know I'm being lazy, but if it's there why not use it! ;D
Using Excel 97-2003, listing the velocities in cells B1 thru B10:
Average velocity =Average(B1:B10)
SD = STDEV(B1:B10)
ES = MAX(B1:B10)-MIN(B1:B10)
Dave beat me to the punch.
Average velocity =Average(B1:B10)
SD = STDEV(B1:B10)
ES = MAX(B1:B10)-MIN(B1:B10)
Dave beat me to the punch.
Upgrades & Donations
This Forum's expenses are primarily paid by member contributions. You can upgrade your Forum membership in seconds. Gold and Silver members get unlimited FREE classifieds for one year. Gold members can upload custom avatars.
Click Upgrade Membership Button ABOVE to get Gold or Silver Status.
You can also donate any amount, large or small, with the button below. Include your Forum Name in the PayPal Notes field.
To DONATE by CHECK, or make a recurring donation, CLICK HERE to learn how.
Click Upgrade Membership Button ABOVE to get Gold or Silver Status.
You can also donate any amount, large or small, with the button below. Include your Forum Name in the PayPal Notes field.
To DONATE by CHECK, or make a recurring donation, CLICK HERE to learn how.