reporte
DESCRIPTION
reporte sobre levantamiento topograficio usando estacion total en los espeacios verdad de la escuela de ingenieria civil de la universidad central del ecuadorTRANSCRIPT
Gridding Report
Tue Mar 10 17:26:36 2015Elapsed time for gridding: 0.01 seconds
Data Source
Source Data File Name: C:\Users\USER\Desktop\trabajo final trazado\TABLA.xls (sheet 'TABLA')X Column: AY Column: BZ Column: C
Data Counts
Active Data:57
Original Data:58Excluded Data:0Deleted Duplicates:1Retained Duplicates:1Artificial Data:0Superseded Data:0
Exclusion Filtering
Exclusion Filter String:Not In Use
Duplicate Filtering
Duplicate Points to Keep:FirstX Duplicate Tolerance:170 Y Duplicate Tolerance:77
Deleted Duplicates:1Retained Duplicates:1Artificial Data:0
XYZIDStatus1500000 650000 2850 44 Retained1500000 650000 2850 47 Deleted
Breakline Filtering
Breakline Filtering:Not In Use
Data Counts
Active Data:57
Univariate Statistics
XYZ Count: 575757
1%%-tile: 14999636500002850 5%%-tile: 1499964578649981039284688110%%-tile: 1499976417649993134284728625%%-tile: 1500005968650015712284826950%%-tile: 1500030653650032859284964475%%-tile: 1500052544650044068285020390%%-tile: 1500073808650055604285206195%%-tile: 1500078857650062432285367799%%-tile: 15000799856500836332853714
Minimum: 14999636500002850Maximum: 15000802496501084532853716
Mean: 1447450483.42638638326.5612799727.77193Median: 15000306536500328592849644Geometric Mean: 1177162542.46575840371.92524434.38521Harmonic Mean: 41605362.646435085315.9306153834.284949Root Mean Square: 1473479218.28644303724.6592824564.89906Trim Mean (10%%): 1500027655.19650028994.7692849492.96154Interquartile Mean: 1500029816.86650031139.8622849471.17241Midrange: 750790106325379226.51428283Winsorized Mean: 1500028591.47650029293.9652849501.21053TriMean: 1500029954.5650031374.52849440
Variance: 7.73857494837e+0167.39816991043e+015142185759104Standard Deviation: 278182942.47486012614.8331377075.269813Interquartile Range: 46576283561934Range: 14985802866494584532850866Mean Difference: 103316145.06122811415.881101876.273183Median Abs. Deviation: 24685154021093Average Abs. Deviation: 52603871.649111410828.087751298.8947368Quartile Dispersion: 1.55250305331e-0052.18113047078e-0050.000339389225743Relative Mean Diff.: 0.07137801689580.03571883323030.0363879210702
Standard Error: 36846230.849111392649.146249944.8395916Coef. of Variation: 0.1921882272730.1346812605130.134682833664Skewness: -4.9209536565-7.15712131626-7.15685764281Kurtosis: 25.613430052453.104331272653.1018174631
Sum: 8250467755536402384614159584483Sum Absolute: 8250467755536402384614159584483Sum Squares: 1.23755037383e+0202.36622555077e+0194.54755511534e+014Mean Square: 2.17114100671e+0184.15127289609e+0177.97816686902e+012
Inter-Variable Covariance
XYZX: 7.7385749e+0161.6768383e+0167.3507455e+013Y: 1.6768383e+0167.3981699e+0153.2432849e+013Z: 7.3507455e+0133.2432849e+0131.4218576e+011
Inter-Variable Correlation
XYZX: 1.0000.7010.701Y: 0.7011.0001.000Z: 0.7011.0001.000
Inter-Variable Rank Correlation
XYZX: 1.0000.537-0.471Y: 0.5371.0000.262Z: -0.4710.2621.000
Principal Component Analysis
PC1PC2PC3X: -0.221575281851-0.2215752818518.85710601057e-008Y: 0.975133897440.97513389744-0.00438406027368Z: 0.004275106490390.00427510649039-0.00438406027368
Lambda: 8.11959536646e+0163.58810791197e+0153337289.46482
Planar Regression: Z = AX+BY+C
Fitted ParametersABCParameter Value: -8.85710691568e-0080.004384102401190.153196360916Standard Error: 1.25276789538e-0064.05171567045e-0061862.22745023
Inter-Parameter CorrelationsABCA:1.000-0.7010.000B:-0.7011.000-0.707C:0.000-0.7071.000
ANOVA TableSource df Sum of Squares Mean SquareF Regression:27.96221561803e+0123.98110780902e+0121150290.27107Residual: 54186891802.093460959.29796Total: 567.96240250983e+012
Coefficient of Multiple Determination (R^2): 0.999976528215
Nearest Neighbor Statistics
Separation|Delta Z| 1%%-tile: 194.1648783898 5%%-tile: 209.5065631431110%%-tile: 211.2865353021325%%-tile: 3566.189282698350%%-tile: 5837.400877132075%%-tile: 8554.62728586311290%%-tile: 12606.3362243372195%%-tile: 19356.809267377899%%-tile: 6493431342846785
Minimum: 194.1648783898Maximum: 6493431342846785
Mean: 22789919.6174101101.017544Median: 5837.4008771320Geometric Mean: 5247.32414455420.383301358Harmonic Mean: 1017.2151893451.6932873521Root Mean Square: 121633113.48533255.063944Trim Mean (10%%): 6008.69817681257.57692308Interquartile Mean: 5805.63910484891.620689655Midrange: 324671664.0821423396.5Winsorized Mean: 6020.722027071341.73684211TriMean: 5948.90458069958.75
Variance: 1.45301487489e+016279034896536Standard Deviation: 120541066.649528237.537984Interquartile Range: 4988.438003173029Range: 649342939.8352846777Mean Difference: 44758665.6257197575.700501Median Abs. Deviation: 2717.22640876307Average Abs. Deviation: 22787039.4916100997.929825Quartile Dispersion: 0.4115595657230.948043818466Relative Mean Diff.: 1.963967682951.95424047454
Standard Error: 15966054.313269966.7711277Coef. of Variation: 5.289227372125.22484887707Skewness: 4.920953744894.92089372565Kurtosis: 25.613430620525.6130448078
Sum: 1299025418.195762758Sum Absolute: 1299025418.195762758Sum Squares: 8.432930148e+0171.62085749037e+013Mean Square: 1.47946142947e+016284360963222
Complete Spatial Randomness
Lambda: 5.85657173074e-017Clark and Evans: 0.348814493963Skellam: 310.314334903
Gridding Rules
Gridding Method: Triangulation with Linear InterpolationAnisotropy Ratio: 1Anisotropy Angle: 0
Output Grid
Grid File Name: C:\Users\USER\Desktop\trabajo final trazado\TABLA.grdGrid Size: 44 rows x 100 columnsTotal Nodes:4400Filled Nodes:2058Blanked Nodes:2342Blank Value:1.70141E+038
Grid Geometry
X Minimum:1499963X Maximum:1500080249X Spacing:15137174.606061
Y Minimum:650000Y Maximum:650108453Y Spacing:15103684.953488
Univariate Grid Statistics
Z Count: 2058
1%%-tile: 267723.962914 5%%-tile: 665014.9193810%%-tile: 929878.07802125%%-tile: 1393431.5526450%%-tile: 1989377.1709775%%-tile: 2452874.4633690%%-tile: 2651574.5031895%%-tile: 2717802.4476599%%-tile: 2784005.54229
Minimum: 69067.1401921Maximum: 2784028.23127
Mean: 1883447.42794Median: 1989377.71119Geometric Mean: 1718514.35179Harmonic Mean: 1446066.80515Root Mean Square: 1995691.29201Trim Mean (10%%): 1913467.67846Interquartile Mean: 1974889.67338Midrange: 1426547.68573Winsorized Mean: 1906518.77616TriMean: 1956265.08948
Variance: 435621191306Standard Deviation: 660016.053824Interquartile Range: 1059442.91072Range: 2714961.09108Mean Difference: 746529.075355Median Abs. Deviation: 529684.180606Average Abs. Deviation: 546341.605463Quartile Dispersion: 0.275444259066Relative Mean Diff.: 0.396363107503
Standard Error: 14548.9554477Coef. of Variation: 0.350429772572Skewness: -0.565846325988Kurtosis: 2.3962714662
Sum: 3876134806.69Sum Absolute: 3876134806.69Sum Squares: 8.19656892252e+015Mean Square: 3.982783733e+012