|
Peter
Gwozdz |
Results: |
#NOME? |
SBP
= Statistical Background Percent |
12 |
End
of the Gap |
|
|
|
|
|
|
|
|
|
|
15,0% |
|
#NOME? |
minimum
from this column |
|
|
|
|
|
|
Poisson
Confidence Interval (Demonstration) |
|
Confidence
Calculation |
|
|
|
| Input
data in column A |
|
#NOME? |
Statistical Mountain
Number |
|
#NOME? |
Mountain Number |
|
Poisson tail |
|
#NOME? |
minimum from this column |
|
| 70% |
Confidence (70% is
recommended) |
#NOME? |
Statistical (Mountain)
Background |
|
#NOME? |
Gap Number |
|
9 |
Cutoff integer check of
user input |
|
for use in the Poisson
function |
|
#NOME? |
minimum SBP value from
this column |
|
4 |
Number of samples; must be an integer |
40 |
Number of samples in the
set; must be an integer |
| 9 |
Cutoff |
|
9 |
Cutoff |
|
#NOME? |
Type Outliers |
|
4 |
Gap check |
|
|
|
|
|
|
80% |
Enter the confidence |
|
90,0% |
Probability |
|
| 4 |
Gap |
|
4 |
Gap |
|
|
|
#NOME? |
(Mountain) Background |
3 |
Gap display check |
|
|
|
|
#NOME? |
Confidence Interval
Lower Number |
|
| 3 |
Gap frequency display |
|
Click sheet "SPD Doc for instuctions |
|
|
|
= 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 |
|
#NOME? |
Confidence Interval
Upper Number |
|
|
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: |
|
| Label |
< Label |
|
Step |
Total |
Frequency |
Gap |
Display |
|
#NOME? |
Size (of the Type) |
|
|
|
9 |
4 |
12 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
This is the requested
Cutoff & Gap |
|
http://statpages.org/confint.html |
|
| #NOME? |
< Copy of the
"Total" |
0 |
#NOME? |
#NOME? |
0 |
0 |
|
#NOME? |
Size confidence minimum |
|
8 |
3 |
8 |
3 |
10 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
These blue rows are the
"neighbor" values |
|
These Poisson functions
are Macros |
|
| #NOME? |
Column A |
1 |
#NOME? |
#NOME? |
1 |
0 |
|
#NOME? |
Size confidence maximum |
|
8 |
4 |
8 |
4 |
11 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
Cutoff / Gap with +/- One |
|
So Excel gives a warning
when opening this file |
|
| #NOME? |
Start at row 11 |
2 |
#NOME? |
#NOME? |
|
0 |
|
|
8 |
5 |
8 |
5 |
12 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
There may be duplicates
in here |
|
Peter Gwozdz |
|
| #NOME? |
|
3 |
#NOME? |
#NOME? |
3 |
0 |
|
|
9 |
3 |
9 |
3 |
11 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
See if your values are
"local minimums" |
|
|
|
| #NOME? |
|
4 |
#NOME? |
#NOME? |
4 |
0 |
|
|
9 |
5 |
9 |
5 |
13 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
5 |
#NOME? |
#NOME? |
5 |
0 |
|
|
10 |
3 |
10 |
3 |
12 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
6 |
#NOME? |
#NOME? |
6 |
0 |
|
|
10 |
4 |
10 |
4 |
13 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
|
| #NOME? |
|
7 |
#NOME? |
#NOME? |
7 |
0 |
|
|
10 |
5 |
10 |
5 |
14 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
8 |
#NOME? |
#NOME? |
8,9 |
0 |
|
|
7 |
2 |
7 |
2 |
8 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
The rest of these are 2
counts beyond your values |
|
|
|
| #NOME? |
|
9 |
#NOME? |
#NOME? |
9 |
3 |
|
|
7 |
3 |
7 |
3 |
9 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
There may be "false
minimums" at another gap beyond your gap |
|
|
| #NOME? |
|
10 |
#NOME? |
#NOME? |
10 |
3 |
|
|
7 |
4 |
7 |
4 |
10 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
And duplicates |
|
|
|
| #NOME? |
|
11 |
#NOME? |
#NOME? |
11 |
3 |
|
|
7 |
5 |
7 |
5 |
11 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
12 |
#NOME? |
#NOME? |
12 |
3 |
|
|
7 |
6 |
7 |
6 |
12 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
13 |
#NOME? |
#NOME? |
12,1 |
0 |
|
|
8 |
2 |
8 |
2 |
9 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
14 |
#NOME? |
#NOME? |
14 |
0 |
|
|
8 |
6 |
8 |
6 |
13 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
15 |
#NOME? |
#NOME? |
15 |
0 |
|
|
9 |
2 |
9 |
2 |
10 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
16 |
#NOME? |
#NOME? |
16 |
0 |
|
|
9 |
6 |
9 |
6 |
14 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
17 |
#NOME? |
#NOME? |
17 |
0 |
|
|
10 |
2 |
10 |
2 |
11 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
|
|
| #NOME? |
|
18 |
#NOME? |
#NOME? |
18 |
0 |
|
|
10 |
6 |
10 |
6 |
15 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
19 |
#NOME? |
#NOME? |
19 |
0 |
|
|
11 |
2 |
11 |
2 |
12 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
20 |
#NOME? |
#NOME? |
20 |
0 |
|
|
11 |
3 |
11 |
3 |
13 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
| #NOME? |
|
21 |
#NOME? |
#NOME? |
21 |
0 |
|
11 |
4 |
11 |
4 |
14 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
22 |
#NOME? |
#NOME? |
22 |
0 |
|
11 |
5 |
11 |
5 |
15 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
23 |
#NOME? |
#NOME? |
23 |
0 |
|
11 |
6 |
11 |
6 |
16 |
#NOME? |
#### |
###### |
#NOME? |
##### |
#NOME? |
#NOME? |
#NOME? |
|
|
| #NOME? |
|
24 |
#NOME? |
#NOME? |
24 |
0 |
|
|
| #NOME? |
|
25 |
#NOME? |
#NOME? |
25 |
0 |
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
| #NOME? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|