Report1.rtf

(20 KB) Pobierz

——————————

Gridding Report

——————————

 

Tue Dec 03 18:44:16 2013

Elasped time for gridding:               0.05 seconds

 

 

Data Source

 

Source Data File Name:               C:\Documents and Settings\Michal\Pulpit\punkty.xlsx (sheet 'Arkusz1')

X Column:               B

Y Column:               A

Z Column:               C

 

 

Data Counts

 

Active Data:              104

 

Original Data:              105

Excluded Data:              0

Deleted Duplicates:              1

Retained Duplicates:              1

Artificial Data:              0

Superseded Data:              0

 

 

Exclusion Filtering

 

Exclusion Filter String:              Not In Use

 

 

Duplicate Filtering

 

Duplicate Points to Keep:              First

X Duplicate Tolerance:              0.00047      

Y Duplicate Tolerance:              0.00048      

 

Deleted Duplicates:              1

Retained Duplicates:              1

Artificial Data:              0

 

————————————————————————————————————————————

X              Y              Z              ID              Status

————————————————————————————————————————————

63267                       67598                       79                          64                      Retained

63267                       67598                       98                          65                      Deleted

————————————————————————————————————————————

 

 

Breakline Filtering

 

Breakline Filtering:              Not In Use

 

 

Data Counts

 

Active Data:              104

 

 

Univariate Statistics

 

————————————————————————————————————————————

              X              Y              Z

————————————————————————————————————————————

Count:                               104              104              104

 

1%%-tile:                            61984              65943              65

5%%-tile:                            62005              65964              72

10%%-tile:                            62037              65979              79

25%%-tile:                            62349              66709              86

50%%-tile:                            63624              67955              103

75%%-tile:                            65154              69262              115

90%%-tile:                            65950              70019              118

95%%-tile:                            65963              70038              120

99%%-tile:                            65983              70042              125

 

Minimum:                              61978              65940              63

Maximum:                              65993              70046              127

 

Mean:                                 63809.4711538              68025.0096154              100.201923077

Median:                               63640              67994.5              103

Geometric Mean:                       63793.3973447              68010.0834734              98.8295874964

Harmonic Mean:                        63777.3727831              67995.156017              97.3706409192

Root Mean Square:                     63825.588416              68039.929889              101.477877468

Trim Mean (10%%):                     63767.2903226              68006.3333333              100.430107527

Interquartile Mean:                   63667.9433962              67996.4150943              101.867924528

Midrange:                             63985.5              67993              95

Winsorized Mean:                      63810.8269231              68024.9519231              100.528846154

TriMean:                              63687.75              67970.25              101.75

 

Variance:                             2077099.8244              2049836.08729              259.832617625

Standard Deviation:                   1441.21470448              1431.72486438              16.1193243539

Interquartile Range:                  2805              2553              29

Range:                                4015              4106              64

Mean Difference:                      1653.31646751              1654.01474981              18.4269977595

Median Abs. Deviation:                1391.5              1276.5              12.5

Average Abs. Deviation:               1271.97115385              1258.39423077              13.5480769231

Quartile Dispersion:                  0.0219994823651              0.0187760625427              0.144278606965

Relative Mean Diff.:                  0.0259102048272              0.0243148036166              0.183898643795

 

Standard Error:                       141.322728873              140.392173492              1.58062979666

Coef. of Variation:                   0.0225862192307              0.0210470365602              0.160868413089

Skewness:                             0.203320375714              -0.00284352609102              -0.400517787393

Kurtosis:                             1.5445521006              1.57746719629              2.09756125883

 

Sum:                                  6636185              7074601              10421

Sum Absolute:                         6636185              7074601              10421

Sum Squares:                          423665396611              481460934167              1070967

Mean Square:                          4073705736.64              4629432059.3              10297.7596154

————————————————————————————————————————————

 

 

Inter-Variable Covariance

 

————————————————————————————————

              X              Y              Z

————————————————————————————————

X:               2077099.8              126185.08              8880.0496

Y:               126185.08              2049836.1              15070.124

Z:               8880.0496              15070.124              259.83262

————————————————————————————————

 

...

Zgłoś jeśli naruszono regulamin