Peter Gwozdz Results: #NOME? SBP = Statistical Background Percent 17 End of the Gap 15,0% 0,0 minimum from this column Poisson Confidence Interval (Demonstration)
Input data in column A #NOME? Statistical Mountain Number 6 Mountain Number Poisson tail #NOME? minimum from this column
70% Confidence (70% is recommended) #NOME? Statistical (Mountain) Background 0 Gap Number 9 Cutoff integer check of user input for use in the Poisson function #NOME? minimum SBP value from this column 1 Number of samples;  must be an integer
9 Cutoff 9 Cutoff 0,0 Type Outliers 9 Gap check 70% Enter the confidence
9 Gap 9 Gap 0,0 (Mountain) Background 4 Gap display check
4 Gap frequency display = Average Gap Frequency Statistical #NOME? Calculated Low Confidence Limit
To reduce the x-axis on the graph #NOME? Statistical Gap Number SBP Trials End = End of Gap = Cutoff + Gap -1 Gap Gap #NOME? Calculated High Confidence Limit
Delete cells at the bottom;  all 5 of these columns #NOME? Statistical Average Gap Frequency Cutoff Gap Cutoff Gap End Mountain M+G Gap Statistical Numbers Average Average SBP
Do not delete the rows, just highlight the data & press Delete = Statistical Background Number Number Mountain Gap Frequency Frequency I downloaded the Poisson functions from:
A67 < Label Step Total Frequency Gap Display 6,0 Size (of the Type) 9 9 17 6 6 0 #NOME? #### 0,0 #NOME? #NOME? This is the requested Cutoff & Gap http://statpages.org/confint.html
2 < Copy of the "Total" 0 0 0 0 0 #NOME? Size confidence minimum 8 8 8 8 15 5 6 1 #NOME? #### 0,1 #NOME? #NOME? These blue rows are the "neighbor" values These Poisson functions are Macros
5      Column A 1 0 0 1 0 #NOME? Size confidence maximum 8 9 8 9 16 5 6 1 #NOME? #### 0,1 #NOME? #NOME? Cutoff / Gap with +/- One So Excel gives a warning when opening this file
6      Start at row 11 2 1 1
2
0 8 10 8 10 17 5 6 1 #NOME? #### 0,1 #NOME? #NOME? There may be duplicates in here Peter Gwozdz
7 3 1 0 3 0 9 8 9 8 16 6 6 0 #NOME? #### 0,0 #NOME? #NOME? See if your values are "local minimums"
7 4 1 0 4 0 9 10 9 10 18 6 7 1 #NOME? #### 0,1 #NOME? #NOME?
8 5 2 1 5 0 10 8 10 8 17 6 6 0 #NOME? #### 0,0 #NOME? #NOME?
18 6 3 1 6 0 10 9 10 9 18 6 7 1 #NOME? #### 0,1 #NOME? #NOME?
19 7 5 2 7 0 10 10 10 10 19 6 12 6 #NOME? #### 0,6 #NOME? #NOME?
19 8 6 1 8,9 0 7 7 7 7 13 3 6 3 #NOME? #### 0,4 #NOME? #NOME? The rest of these are 2 counts beyond your values
19 9 6 0 9 4 7 8 7 8 14 3 6 3 #NOME? #### 0,4 #NOME? #NOME? There may be "false minimums" at another gap beyond your gap
19 10 6 0 10 4 7 9 7 9 15 3 6 3 #NOME? #### 0,3 #NOME? #NOME? And duplicates
19 11 6 0 11 4 7 10 7 10 16 3 6 3 #NOME? #### 0,3 #NOME? #NOME?
20 12 6 0 12 4 7 11 7 11 17 3 6 3 #NOME? #### 0,3 #NOME? #NOME?
20 13 6 0 13 4 8 7 8 7 14 5 6 1 #NOME? #### 0,1 #NOME? #NOME?
20 14 6 0 14 4 8 11 8 11 18 5 7 2 #NOME? #### 0,2 #NOME? #NOME?
20 15 6 0 15 4 9 7 9 7 15 6 6 0 #NOME? #### 0,0 #NOME? #NOME?
20 16 6 0 16 4 9 11 9 11 19 6 12 6 #NOME? #### 0,5 #NOME? #NOME?
21 17 6 0 17 4 10 7 10 7 16 6 6 0 #NOME? #### 0,0 #NOME? #NOME?
21 18 7 1 17,1 0 10 11 10 11 20 6 17 11 #NOME? #### 1,0 #NOME? #NOME?
21 19 12 5 19 0 11 7 11 7 17 6 6 0 #NOME? #### 0,0 #NOME? #NOME?
21 20 17 5 20 0 11 8 11 8 18 6 7 1 #NOME? #### 0,1 #NOME? #NOME?
21 21 22 5 21 0 11 9 11 9 19 6 12 6 #NOME? #### 0,7 #NOME? #NOME?
22 22 29 7 22 0 11 10 11 10 20 6 17 11 #NOME? #### 1,1 #NOME? #NOME?
22 23 39 10 23 0 11 11 11 11 21 6 22 16 #NOME? #### 1,5 #NOME? #NOME?
22 24 54 15 24 0
22 25 64 10 25 0
22
22
22
23
23
23
23
23
23
23
23
23
23
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
25
25
25
25
25
25
25
25
25
25
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
27
27
27
27
27
27
27
27
27
27
27
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
29
29
29
29
29
29
29
29
29
29
29
30
30
30
30
30
30
30
30
30
30
30
30
31
31
31
31
31
32
32
32
32
32
32
32
32
32
33
33
33
33
33
33
34
34
34
34
35
35