Shakira Rabiosa

——————————
Gridding Report
——————————

Thu Jun 23 16:35:48 2011
Elasped time for gridding: 0.01 seconds

Data Source

Source Data File Name: C:\Users\Freddyk\Documents\practica1.xlsx (sheet 'Hoja1')
X Column: A
Y Column: B
Z Column: C

Data Counts

Active Data: 10

Original Data: 10
Excluded Data: 0
Deleted Duplicates: 0
Retained Duplicates: 0
Artificial Data: 0Superseded Data: 0

Exclusion Filtering

Exclusion Filter String: Not In Use

Duplicate Filtering

Duplicate Points to Keep: First
X Duplicate Tolerance: 4.2E-006
Y Duplicate Tolerance: 1E-005

No duplicate data were found.

Breakline Filtering

Breakline Filtering: Not In Use

Data Counts

Active Data: 10

Univariate Statistics————————————————————————————————————————————
X Y Z
————————————————————————————————————————————
Count: 10 10 10

1%%-tile: 39 12 544
5%%-tile: 39 12 544
10%%-tile: 39 12 544
25%%-tile: 45 21 765
50%%-tile: 56 30 907
75%%-tile: 68 65 1500
90%%-tile: 70 80 1992
95%%-tile: 70 80 1992
99%%-tile: 70 80 1992

Minimum: 39 12 544Maximum: 75 100 2010

Mean: 57.1 46.1 1205.5
Median: 59 35.5 1003.5
Geometric Mean: 55.5735319256 36.7859371892 1094.55427086
Harmonic Mean: 54.0127516567 29.1756774628 994.88929538
Root Mean Square: 58.5328967334 54.5829643753 1313.76950033
Trim Mean (10%%): N/A N/A N/A
Interquartile Mean: 55.8 36 1026.4Midrange: 57 56 1277
Winsorized Mean: 56.6 44.1 1203.7
TriMean: 56.25 36.5 1019.75

Variance: 184.1 948.988888889 303066.722222
Standard Deviation: 13.5683455145 30.80566326 550.514960943
Interquartile Range: 23 44 735
Range: 36 88 1466
Mean Difference: 16.1555555556 36.1111111111 648.6
Median Abs.Deviation: 11 21 393
Average Abs. Deviation: 11.7 25.5 454.9
Quartile Dispersion: 0.203539823009 0.511627906977 0.324503311258
Relative Mean Diff.: 0.28293442304 0.783321282237 0.538034010784

Standard Error: 4.29068759058 9.74160607338 174.088116258
Coef. of Variation: 0.237624264702 0.668235645553 0.456669399372
Skewness: -0.13635597134 0.4205163295380.33690421149
Kurtosis: 1.20394861624 1.46097492214 1.30464898114

Sum: 571 461 12055
Sum Absolute: 571 461 12055
Sum Squares: 34261 29793 17259903
Mean Square: 3426.1 2979.3 1725990.3
————————————————————————————————————————————

Inter-Variable Covariance

————————————————————————————————
X Y Z————————————————————————————————
X: 184.1 246.32222 4145.2778
Y: 246.32222 948.98889 13200.722
Z: 4145.2778 13200.722 303066.72
————————————————————————————————

Inter-Variable Correlation

————————————————————————————————
X Y Z
————————————————————————————————
X: 1.000 0.589 0.555
Y: 0.589 1.000 0.778
Z: 0.555 0.778 1.000
————————————————————————————————

Inter-Variable Rank Correlation

————————————————————————————————
X Y Z————————————————————————————————
X: 1.000 0.632 0.413
Y: 0.632 1.000 0.806
Z: 0.413 0.806 1.000
————————————————————————————————

Principal Component Analysis

————————————————————————————————————————
PC1 PC2 PC3
————————————————————————————————————————
X: 0.242132837143 0.242132837143 0.970146681162
Y: 0.969171664561 0.969171664561 -0.242503784685
Z:-0.04558479779 -0.04558479779 -0.242503784685

Lambda: 303699.217324 389.635397152 110.958390146
————————————————————————————————————————

Planar Regression: Z = AX+BY+C

Fitted Parameters
————————————————————————————————————————
A B C
————————————————————————————————————————...