| A | B | |
|---|---|---|
1 | Worksheets | |
2 | Velocity | Input velocity data, get estimates for mean, variance, and standard deviation with confidence intervals. (Works for any Normally distributed sample data.) |
3 | AvB Velocity | Statistical analysis of the difference in velocity variance between two different loads. |
4 | X-Y Variance | Input (x,y) coordinates of shots on targets. This sheet computes the variance estimate of each axis with confidence intervals, as well as aggregate variance and sigma, and a test of whether the variance on each axis is statistically different. |
5 | Target Precision | Input (x,y) coordinates of shots on targets. This sheet computes the precision estimate (sigma) with 90% upper confidence bound – Ballistic Precision Class (BPC) |
6 | Precision – known POA | Input (x,y) coordinates of shots on targets relative to the point of aim (POA). Knowing the POA allows more efficient statistics when analyzing multiple targets. |
7 | AvB Target | Compares precision of two different loads. Input R^2 from targets (which is calculated on Target Precision sheets). |
8 | 2-Shot BPC | Shoot two shots at each point of aim and measure their straight-line spread. Can be easier than recording (x,y) for each hit, but sacrifices statistical power in calculating precision estimate (sigma). |
9 | Extreme Spread | Convert an average extreme spread to an estimate of sigma |
10 | Applied σ | Given sigma, find expected extreme spread, covering probabilities, and zero errors. |
11 | ||
12 | ||
13 | David Bookstaber is the original author of this workbook. | |
14 | Please email him if you have any questions or comments: bookstaber@gmail.com | |
15 | References: | |
16 | Detailed explanation and validation of the formulas used here. | |
17 | https://david.bookstaber.com/Interests/category/ballistics/ | |
18 | https://github.com/dbookstaber/ballistipedia | |
19 | http://ballistipedia.com/ | |
20 |