|
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 |
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|