datos_originales <- readr::read_delim(ruta, delim=delimitador, trim_ws=TRUE, show_col_types=FALSE, name_repair="minimal")
## Carga exitosa: 47.501 registros.
# La limpieza es únicamente para el análisis: el archivo CSV no se modifica.
zona_limpia <- datos_originales |>
dplyr::transmute(Zona=stringr::str_squish(as.character(.data[[columna_zona]]))) |>
dplyr::filter(!is.na(Zona), Zona != "",
!toupper(Zona) %in% c("NA", "N/A", "NULL"))
N <- nrow(zona_limpia)
if (N == 0L) stop("No se encontraron zonas cartográficas válidas en QUAD.")
k_zonas <- dplyr::n_distinct(zona_limpia$Zona)
cat("Registros válidos:", fmt_entero(N),
" | Zonas distintas:", fmt_entero(k_zonas), "\n")
## Registros válidos: 46.559 | Zonas distintas: 434
| VARIABLE | TIPO | ESCALA DE MEDICIÓN | UNIDAD DE ANÁLISIS | CATEGORÍAS (k) | REGISTROS VÁLIDOS (N) |
|---|---|---|---|---|---|
| QUAD (Zona cartográfica) | Cualitativa nominal | Nominal | Pozo regulado | 434 | 46.559 |
El Cuadro N° 1 presenta la frecuencia absoluta (nᵢ), la frecuencia relativa (hᵢ) y el porcentaje de pozos regulados de cada una de las 434 zonas cartográficas, sobre un total de 46.559 registros válidos.
cat(crear_cuadro(tabla_frecuencias, 1,
"Distribución de frecuencias de los pozos regulados según la zona cartográfica, Nueva York, 1860 - 2026",
desplazamiento=(k_zonas > 15L)))
| ZONA CARTOGRÁFICA | FRECUENCIA ABSOLUTA (nᵢ) | FRECUENCIA RELATIVA (hᵢ) | FRECUENCIA RELATIVA PORCENTUAL (%) |
|---|---|---|---|
| Lisle | 1 | 0.0000 | 0.00% |
| Dunkirk | 427 | 0.0092 | 0.92% |
| Owego | 41 | 0.0009 | 0.09% |
| Bradford PA | 2 | 0.0000 | 0.00% |
| Dale | 224 | 0.0048 | 0.48% |
| Scipio Center | 26 | 0.0006 | 0.06% |
| Cowlesville | 214 | 0.0046 | 0.46% |
| Groton | 18 | 0.0004 | 0.04% |
| Hartfield | 264 | 0.0057 | 0.57% |
| Unadilla Forks | 1 | 0.0000 | 0.00% |
| Oswayo, PA-NY | 2 | 0.0000 | 0.00% |
| Penn Yan | 31 | 0.0007 | 0.07% |
| Pulteney | 29 | 0.0006 | 0.06% |
| Sherman | 333 | 0.0072 | 0.72% |
| Savona | 33 | 0.0007 | 0.07% |
| Wattsburg, PA-NY | 12 | 0.0003 | 0.03% |
| Castle Creek | 1 | 0.0000 | 0.00% |
| Seeley Creek | 42 | 0.0009 | 0.09% |
| Cuyler | 1 | 0.0000 | 0.00% |
| Stafford | 103 | 0.0022 | 0.22% |
| Van Hornesville | 1 | 0.0000 | 0.00% |
| Watertown | 2 | 0.0000 | 0.00% |
| Treadwell | 2 | 0.0000 | 0.00% |
| Otisville | 2 | 0.0000 | 0.00% |
| Skaneateles | 5 | 0.0001 | 0.01% |
| Andover | 176 | 0.0038 | 0.38% |
| Prattsburg | 16 | 0.0003 | 0.03% |
| Macedon | 4 | 0.0001 | 0.01% |
| Phoenicia | 3 | 0.0001 | 0.01% |
| Binghamton West | 2 | 0.0000 | 0.00% |
| Wellsville North | 575 | 0.0123 | 1.23% |
| New Berlin South | 1 | 0.0000 | 0.00% |
| Boonville | 1 | 0.0000 | 0.00% |
| Ransomville | 2 | 0.0000 | 0.00% |
| Collins Center | 228 | 0.0049 | 0.49% |
| Niagara Falls | 2 | 0.0000 | 0.00% |
| Remsen | 1 | 0.0000 | 0.00% |
| Hancock | 2 | 0.0000 | 0.00% |
| Mount Vernon | 15 | 0.0003 | 0.03% |
| Yonkers | 25 | 0.0005 | 0.05% |
| South Canisteo | 51 | 0.0011 | 0.11% |
| Mecklenburg | 14 | 0.0003 | 0.03% |
| Endicott | 4 | 0.0001 | 0.01% |
| Ivory | 146 | 0.0031 | 0.31% |
| Salamanca | 12 | 0.0003 | 0.03% |
| Marcellus | 18 | 0.0004 | 0.04% |
| Ripley | 166 | 0.0036 | 0.36% |
| Pitcher | 1 | 0.0000 | 0.00% |
| West Bainbridge | 16 | 0.0003 | 0.03% |
| Columbus PA-NY | 1 | 0.0000 | 0.00% |
| Richfield Springs | 1 | 0.0000 | 0.00% |
| Mcgraw | 10 | 0.0002 | 0.02% |
| Gerry | 323 | 0.0069 | 0.69% |
| Canandaigua | 22 | 0.0005 | 0.05% |
| Reading Center | 172 | 0.0037 | 0.37% |
| Seneca Falls | 52 | 0.0011 | 0.11% |
| Norwich | 10 | 0.0002 | 0.02% |
| Farnham | 359 | 0.0077 | 0.77% |
| Hornell | 22 | 0.0005 | 0.05% |
| West Winfield | 1 | 0.0000 | 0.00% |
| Warsaw | 14 | 0.0003 | 0.03% |
| Hensonville | 1 | 0.0000 | 0.00% |
| Corinth | 1 | 0.0000 | 0.00% |
| Conesus | 3 | 0.0001 | 0.01% |
| Belden | 8 | 0.0002 | 0.02% |
| West Valley | 20 | 0.0004 | 0.04% |
| Tonawanda West | 4 | 0.0001 | 0.01% |
| Camillus | 9 | 0.0002 | 0.02% |
| Lancaster | 101 | 0.0022 | 0.22% |
| South Trenton | 2 | 0.0000 | 0.00% |
| Pennellville | 12 | 0.0003 | 0.03% |
| Akron | 84 | 0.0018 | 0.18% |
| Vernon | 2 | 0.0000 | 0.00% |
| Napanoch | 1 | 0.0000 | 0.00% |
| Voorheesville | 1 | 0.0000 | 0.00% |
| Smithville Flats | 19 | 0.0004 | 0.04% |
| Rushville | 35 | 0.0008 | 0.08% |
| Canaseraga | 5 | 0.0001 | 0.01% |
| Verona | 3 | 0.0001 | 0.01% |
| Haskinville | 6 | 0.0001 | 0.01% |
| Oneida | 1 | 0.0000 | 0.00% |
| New Albion | 159 | 0.0034 | 0.34% |
| Ticonderoga | 3 | 0.0001 | 0.01% |
| Cazenovia | 1 | 0.0000 | 0.00% |
| Stanley | 19 | 0.0004 | 0.04% |
| Delevan | 19 | 0.0004 | 0.04% |
| Otselic | 32 | 0.0007 | 0.07% |
| Freehold | 1 | 0.0000 | 0.00% |
| Corfu | 335 | 0.0072 | 0.72% |
| Ogdensburg East | 1 | 0.0000 | 0.00% |
| Portageville | 14 | 0.0003 | 0.03% |
| Cementon | 1 | 0.0000 | 0.00% |
| Victor | 30 | 0.0006 | 0.06% |
| Sugar Grove, PA-NY | 20 | 0.0004 | 0.04% |
| Beaver Dams | 28 | 0.0006 | 0.06% |
| Saugerties | 1 | 0.0000 | 0.00% |
| Clinton | 1 | 0.0000 | 0.00% |
| Geneva South | 132 | 0.0028 | 0.28% |
| Woodstock | 1 | 0.0000 | 0.00% |
| East Pharsalia | 9 | 0.0002 | 0.02% |
| Deposit | 1 | 0.0000 | 0.00% |
| Port Jervis North | 2 | 0.0000 | 0.00% |
| Belmont | 70 | 0.0015 | 0.15% |
| Oakfield | 82 | 0.0018 | 0.18% |
| Corning | 41 | 0.0009 | 0.09% |
| Batavia South | 36 | 0.0008 | 0.08% |
| Schroon Lake | 1 | 0.0000 | 0.00% |
| Big Flats | 39 | 0.0008 | 0.08% |
| Hudson Falls | 1 | 0.0000 | 0.00% |
| Weedsport | 20 | 0.0004 | 0.04% |
| Fort Ann | 1 | 0.0000 | 0.00% |
| Byron | 21 | 0.0005 | 0.05% |
| Pulaski | 94 | 0.0020 | 0.20% |
| Otisco Valley | 180 | 0.0039 | 0.39% |
| Kendall | 4 | 0.0001 | 0.01% |
| Chenango Forks | 29 | 0.0006 | 0.06% |
| Angelica | 17 | 0.0004 | 0.04% |
| Willseyville | 3 | 0.0001 | 0.01% |
| Rochester East | 3 | 0.0001 | 0.01% |
| Nunda | 6 | 0.0001 | 0.01% |
| White Plains | 16 | 0.0003 | 0.03% |
| Dundee | 18 | 0.0004 | 0.04% |
| Hamilton | 67 | 0.0014 | 0.14% |
| Lyons | 8 | 0.0002 | 0.02% |
| Pike | 5 | 0.0001 | 0.01% |
| Lyndonville | 3 | 0.0001 | 0.01% |
| Margaretville | 1 | 0.0000 | 0.00% |
| Jamaica | 5 | 0.0001 | 0.01% |
| Clarence | 262 | 0.0056 | 0.56% |
| Angola | 66 | 0.0014 | 0.14% |
| Little Valley | 6 | 0.0001 | 0.01% |
| Herkimer | 8 | 0.0002 | 0.02% |
| Black River | 2 | 0.0000 | 0.00% |
| Hammondsport | 19 | 0.0004 | 0.04% |
| Clifton Springs | 3 | 0.0001 | 0.01% |
| Sugar Grove PA | 3 | 0.0001 | 0.01% |
| Addison | 15 | 0.0003 | 0.03% |
| Whitesville | 1.457 | 0.0313 | 3.13% |
| Brooklyn | 70 | 0.0015 | 0.15% |
| Greene | 2 | 0.0000 | 0.00% |
| Hinsdale | 112 | 0.0024 | 0.24% |
| Arkport | 2 | 0.0000 | 0.00% |
| South Ripley | 210 | 0.0045 | 0.45% |
| Lysander | 4 | 0.0001 | 0.01% |
| Fulton | 10 | 0.0002 | 0.02% |
| Middleburgh | 1 | 0.0000 | 0.00% |
| Auburn | 54 | 0.0012 | 0.12% |
| Perrysburg | 308 | 0.0066 | 0.66% |
| Ossian | 8 | 0.0002 | 0.02% |
| Ellery Center | 275 | 0.0059 | 0.59% |
| Nyack | 5 | 0.0001 | 0.01% |
| Medina | 2 | 0.0000 | 0.00% |
| Canajoharie | 3 | 0.0001 | 0.01% |
| Camden West | 9 | 0.0002 | 0.02% |
| Newark | 1 | 0.0000 | 0.00% |
| Wellsville South | 1.236 | 0.0265 | 2.65% |
| Kent | 5 | 0.0001 | 0.01% |
| Apalachin | 40 | 0.0009 | 0.09% |
| Mount Vision | 1 | 0.0000 | 0.00% |
| Westernville | 4 | 0.0001 | 0.01% |
| Buffalo NW | 42 | 0.0009 | 0.09% |
| Ashford | 37 | 0.0008 | 0.08% |
| Ilion | 2 | 0.0000 | 0.00% |
| Tyner | 20 | 0.0004 | 0.04% |
| Ossining | 3 | 0.0001 | 0.01% |
| Dryden | 1 | 0.0000 | 0.00% |
| Horton | 18 | 0.0004 | 0.04% |
| Troy South | 1 | 0.0000 | 0.00% |
| Sandy Creek | 57 | 0.0012 | 0.12% |
| Ellisburg | 5 | 0.0001 | 0.01% |
| Bristol Springs | 10 | 0.0002 | 0.02% |
| Camden East | 7 | 0.0002 | 0.02% |
| Romulus | 203 | 0.0044 | 0.44% |
| Red House | 32 | 0.0007 | 0.07% |
| Le Roy | 134 | 0.0029 | 0.29% |
| Erin | 45 | 0.0010 | 0.10% |
| Avoca | 20 | 0.0004 | 0.04% |
| Bradford NY | 43 | 0.0009 | 0.09% |
| Barton | 6 | 0.0001 | 0.01% |
| Newfane | 2 | 0.0000 | 0.00% |
| West Groton | 17 | 0.0004 | 0.04% |
| Jordan | 4 | 0.0001 | 0.01% |
| West Danby | 16 | 0.0003 | 0.03% |
| Ithaca West | 8 | 0.0002 | 0.02% |
| Silver Creek | 183 | 0.0039 | 0.39% |
| Rodman | 1 | 0.0000 | 0.00% |
| Baldwinsville | 68 | 0.0015 | 0.15% |
| Alfred | 15 | 0.0003 | 0.03% |
| Fort Plain | 1 | 0.0000 | 0.00% |
| Springville | 137 | 0.0029 | 0.29% |
| Strykersville | 108 | 0.0023 | 0.23% |
| Utica West | 2 | 0.0000 | 0.00% |
| Morrisville | 3 | 0.0001 | 0.01% |
| Cortland | 2 | 0.0000 | 0.00% |
| Savannah | 21 | 0.0005 | 0.05% |
| Ellicottville | 33 | 0.0007 | 0.07% |
| Brockport | 2 | 0.0000 | 0.00% |
| West Almond | 10 | 0.0002 | 0.02% |
| Horseheads | 16 | 0.0003 | 0.03% |
| Orchard Park | 151 | 0.0032 | 0.32% |
| Homer | 3 | 0.0001 | 0.01% |
| Panama | 251 | 0.0054 | 0.54% |
| Wayland | 2 | 0.0000 | 0.00% |
| East Aurora | 163 | 0.0035 | 0.35% |
| Campbell | 35 | 0.0008 | 0.08% |
| Forestport | 1 | 0.0000 | 0.00% |
| Jersey City | 80 | 0.0017 | 0.17% |
| Holland | 193 | 0.0041 | 0.41% |
| Sardinia | 59 | 0.0013 | 0.13% |
| Rathbone | 37 | 0.0008 | 0.08% |
| Honeoye Falls | 4 | 0.0001 | 0.01% |
| Newark Valley | 5 | 0.0001 | 0.01% |
| Adams | 3 | 0.0001 | 0.01% |
| Geneseo | 109 | 0.0023 | 0.23% |
| West Henrietta | 1 | 0.0000 | 0.00% |
| Cherry Creek | 282 | 0.0061 | 0.61% |
| Richland | 12 | 0.0003 | 0.03% |
| Greenwood | 581 | 0.0125 | 1.25% |
| Montour Falls | 28 | 0.0006 | 0.06% |
| Bliss | 24 | 0.0005 | 0.05% |
| West Eaton | 40 | 0.0009 | 0.09% |
| Fillmore | 36 | 0.0008 | 0.08% |
| Oneonta | 3 | 0.0001 | 0.01% |
| Erieville | 2 | 0.0000 | 0.00% |
| Franklinville | 9 | 0.0002 | 0.02% |
| Freedom | 10 | 0.0002 | 0.02% |
| Williamstown | 3 | 0.0001 | 0.01% |
| Allentown | 6.154 | 0.1322 | 13.22% |
| North Collins | 381 | 0.0082 | 0.82% |
| Brocton | 148 | 0.0032 | 0.32% |
| Quaker Springs | 1 | 0.0000 | 0.00% |
| Knowlesville | 5 | 0.0001 | 0.01% |
| Bloomville | 1 | 0.0000 | 0.00% |
| North Clymer | 278 | 0.0060 | 0.60% |
| Pattersonville | 1 | 0.0000 | 0.00% |
| North Of Westfield | 1 | 0.0000 | 0.00% |
| Waverly | 10 | 0.0002 | 0.02% |
| Hicksville | 2 | 0.0000 | 0.00% |
| Afton | 10 | 0.0002 | 0.02% |
| Friendship | 285 | 0.0061 | 0.61% |
| Buffalo SE | 118 | 0.0025 | 0.25% |
| Genoa | 17 | 0.0004 | 0.04% |
| Montezuma | 4 | 0.0001 | 0.01% |
| Burnt Hills | 1 | 0.0000 | 0.00% |
| Ashford Hollow | 58 | 0.0012 | 0.12% |
| South Valley | 1 | 0.0000 | 0.00% |
| Gilbertsville | 1 | 0.0000 | 0.00% |
| Cannonsville Reservoir | 2 | 0.0000 | 0.00% |
| South Onondaga | 5 | 0.0001 | 0.01% |
| Middle Grove | 1 | 0.0000 | 0.00% |
| New Berlin North | 1 | 0.0000 | 0.00% |
| Forestville | 365 | 0.0078 | 0.78% |
| Phelps | 13 | 0.0003 | 0.03% |
| Cato | 10 | 0.0002 | 0.02% |
| Cameron | 32 | 0.0007 | 0.07% |
| Leicester | 107 | 0.0023 | 0.23% |
| Park Ridge | 2 | 0.0000 | 0.00% |
| Livonia | 33 | 0.0007 | 0.07% |
| Hartford | 1 | 0.0000 | 0.00% |
| Wellsburg | 12 | 0.0003 | 0.03% |
| Roxbury | 1 | 0.0000 | 0.00% |
| North Of Dunkirk | 24 | 0.0005 | 0.05% |
| Borden | 43 | 0.0009 | 0.09% |
| Saratoga Springs | 1 | 0.0000 | 0.00% |
| Eden | 218 | 0.0047 | 0.47% |
| West Lowville | 6 | 0.0001 | 0.01% |
| Tribes Hill | 3 | 0.0001 | 0.01% |
| Guilford | 1 | 0.0000 | 0.00% |
| Chautauqua | 246 | 0.0053 | 0.53% |
| Clymer | 170 | 0.0037 | 0.37% |
| Caledonia | 66 | 0.0014 | 0.14% |
| Naples | 20 | 0.0004 | 0.04% |
| Gowanda | 285 | 0.0061 | 0.61% |
| Middlesex | 11 | 0.0002 | 0.02% |
| Albion | 1 | 0.0000 | 0.00% |
| Steamburg | 33 | 0.0007 | 0.07% |
| Monticello | 1 | 0.0000 | 0.00% |
| Seager | 1 | 0.0000 | 0.00% |
| Cooperstown | 1 | 0.0000 | 0.00% |
| Oran | 1 | 0.0000 | 0.00% |
| Clarence Center | 3 | 0.0001 | 0.01% |
| Castile | 89 | 0.0019 | 0.19% |
| Batavia North | 23 | 0.0005 | 0.05% |
| North East PA | 4 | 0.0001 | 0.01% |
| Stamford | 2 | 0.0000 | 0.00% |
| Whitney Point | 3 | 0.0001 | 0.01% |
| Sylvan Beach | 2 | 0.0000 | 0.00% |
| Flushing | 2 | 0.0000 | 0.00% |
| Middletown | 1 | 0.0000 | 0.00% |
| Bolivar | 5.998 | 0.1288 | 12.88% |
| Sonyea | 26 | 0.0006 | 0.06% |
| Oxford | 3 | 0.0001 | 0.01% |
| Willet | 3 | 0.0001 | 0.01% |
| Barker | 1 | 0.0000 | 0.00% |
| Rush | 21 | 0.0005 | 0.05% |
| Cattaraugus | 35 | 0.0008 | 0.08% |
| Shandaken | 1 | 0.0000 | 0.00% |
| Moravia | 5 | 0.0001 | 0.01% |
| Birdsall | 9 | 0.0002 | 0.02% |
| Unadilla | 1 | 0.0000 | 0.00% |
| Wyoming | 349 | 0.0075 | 0.75% |
| Gulf Summit | 2 | 0.0000 | 0.00% |
| Hobart | 1 | 0.0000 | 0.00% |
| Humphrey | 154 | 0.0033 | 0.33% |
| Ashwood | 3 | 0.0001 | 0.01% |
| Broadalbin | 1 | 0.0000 | 0.00% |
| Cambria | 4 | 0.0001 | 0.01% |
| Harford | 8 | 0.0002 | 0.02% |
| Durham | 1 | 0.0000 | 0.00% |
| Cassadaga | 225 | 0.0048 | 0.48% |
| Wayne | 186 | 0.0040 | 0.40% |
| Alpine | 8 | 0.0002 | 0.02% |
| Morrisonville | 1 | 0.0000 | 0.00% |
| Buffalo NE | 66 | 0.0014 | 0.14% |
| Lakewood | 871 | 0.0187 | 1.87% |
| Portville | 51 | 0.0011 | 0.11% |
| Florence | 4 | 0.0001 | 0.01% |
| Wappingers Falls | 26 | 0.0006 | 0.06% |
| Sidney | 3 | 0.0001 | 0.01% |
| Munnsville | 1 | 0.0000 | 0.00% |
| Canandaigua Lake | 7 | 0.0002 | 0.02% |
| Rawson | 22 | 0.0005 | 0.05% |
| Dexter | 1 | 0.0000 | 0.00% |
| Oriskany Falls | 6 | 0.0001 | 0.01% |
| Elmira | 33 | 0.0007 | 0.07% |
| Rome | 18 | 0.0004 | 0.04% |
| North Western | 2 | 0.0000 | 0.00% |
| Dansville | 25 | 0.0005 | 0.05% |
| Burdett | 43 | 0.0009 | 0.09% |
| Trumansburg | 10 | 0.0002 | 0.02% |
| Jamestown | 300 | 0.0064 | 0.64% |
| Caton | 24 | 0.0005 | 0.05% |
| Wolcottsville | 15 | 0.0003 | 0.03% |
| Johnsonburg | 21 | 0.0005 | 0.05% |
| Altamont | 1 | 0.0000 | 0.00% |
| Westdale | 3 | 0.0001 | 0.01% |
| Churchville | 8 | 0.0002 | 0.02% |
| Ludlowville | 39 | 0.0008 | 0.08% |
| Utica East | 1 | 0.0000 | 0.00% |
| Cuba | 31 | 0.0007 | 0.07% |
| Maine | 4 | 0.0001 | 0.01% |
| Keuka Park | 38 | 0.0008 | 0.08% |
| Lodi | 7 | 0.0002 | 0.02% |
| Limestone | 563 | 0.0121 | 1.21% |
| Franklin | 1 | 0.0000 | 0.00% |
| Dresden | 3 | 0.0001 | 0.01% |
| Spencer | 14 | 0.0003 | 0.03% |
| Central Park | 92 | 0.0020 | 0.20% |
| Geneva North | 85 | 0.0018 | 0.18% |
| Langford | 402 | 0.0086 | 0.86% |
| Brisben | 2 | 0.0000 | 0.00% |
| Brookfield | 4 | 0.0001 | 0.01% |
| Carthage | 1 | 0.0000 | 0.00% |
| Bristol Center | 110 | 0.0024 | 0.24% |
| Bath | 27 | 0.0006 | 0.06% |
| Derrick City PA-NY | 10 | 0.0002 | 0.02% |
| Van Etten | 34 | 0.0007 | 0.07% |
| Holley | 7 | 0.0002 | 0.02% |
| Knapp Creek | 6.650 | 0.1428 | 14.28% |
| Jewell | 1 | 0.0000 | 0.00% |
| Westfield | 309 | 0.0066 | 0.66% |
| Olean | 2.966 | 0.0637 | 6.37% |
| Gloversville | 2 | 0.0000 | 0.00% |
| Carlisle | 3 | 0.0001 | 0.01% |
| Victory | 2 | 0.0000 | 0.00% |
| Black Creek | 17 | 0.0004 | 0.04% |
| Troupsburg | 49 | 0.0011 | 0.11% |
| Glenville, CT-NY | 2 | 0.0000 | 0.00% |
| Sprout Brook | 2 | 0.0000 | 0.00% |
| Canisteo | 35 | 0.0008 | 0.08% |
| Union Springs | 105 | 0.0023 | 0.23% |
| Sackets Harbor | 1 | 0.0000 | 0.00% |
| Hamlin | 2 | 0.0000 | 0.00% |
| Attica | 86 | 0.0018 | 0.18% |
| Wolcott | 11 | 0.0002 | 0.02% |
| Potter | 14 | 0.0003 | 0.03% |
| Peck Lake | 1 | 0.0000 | 0.00% |
| Sempronius | 4 | 0.0001 | 0.01% |
| Hamden | 1 | 0.0000 | 0.00% |
| North East | 9 | 0.0002 | 0.02% |
| Mexico | 3 | 0.0001 | 0.01% |
| Mount Morris | 38 | 0.0008 | 0.08% |
| Point Rock | 1 | 0.0000 | 0.00% |
| Woodhull | 56 | 0.0012 | 0.12% |
| Fishs Eddy | 6 | 0.0001 | 0.01% |
| Syracuse West | 3 | 0.0001 | 0.01% |
| Schuylerville | 1 | 0.0000 | 0.00% |
| Orwell | 1 | 0.0000 | 0.00% |
| Milford | 4 | 0.0001 | 0.01% |
| New Boston | 1 | 0.0000 | 0.00% |
| Hartwick | 2 | 0.0000 | 0.00% |
| Belfort | 1 | 0.0000 | 0.00% |
| Dugway | 2 | 0.0000 | 0.00% |
| Ithaca East | 2 | 0.0000 | 0.00% |
| Rheims | 10 | 0.0002 | 0.02% |
| Houghton | 25 | 0.0005 | 0.05% |
| Oswego East | 4 | 0.0001 | 0.01% |
| Central Square | 1 | 0.0000 | 0.00% |
| High Market | 1 | 0.0000 | 0.00% |
| Earlville | 86 | 0.0018 | 0.18% |
| Tonawanda East | 48 | 0.0010 | 0.10% |
| Canastota | 1 | 0.0000 | 0.00% |
| Colden | 295 | 0.0063 | 0.63% |
| Rexville | 982 | 0.0211 | 2.11% |
| East Springfield | 4 | 0.0001 | 0.01% |
| Rotterdam Junction | 1 | 0.0000 | 0.00% |
| Sodus | 1 | 0.0000 | 0.00% |
| Mallory | 3 | 0.0001 | 0.01% |
| Hamburg | 218 | 0.0047 | 0.47% |
| North Sanford | 4 | 0.0001 | 0.01% |
| Owasco | 1 | 0.0000 | 0.00% |
| Albany | 15 | 0.0003 | 0.03% |
| Arcade | 95 | 0.0020 | 0.20% |
| Sheldrake | 6 | 0.0001 | 0.01% |
| Hubbardsville | 17 | 0.0004 | 0.04% |
| Ovid | 3 | 0.0001 | 0.01% |
| Hannibal | 1 | 0.0000 | 0.00% |
| Jordanville | 1 | 0.0000 | 0.00% |
| Alexander | 188 | 0.0040 | 0.40% |
| Cayuga | 233 | 0.0050 | 0.50% |
| Ellisburg, PA-NY | 2 | 0.0000 | 0.00% |
| Clifton | 16 | 0.0003 | 0.03% |
| Kennedy | 243 | 0.0052 | 0.52% |
| Towlesville | 32 | 0.0007 | 0.07% |
| Candor | 13 | 0.0003 | 0.03% |
| Morris | 2 | 0.0000 | 0.00% |
| Hamlet | 246 | 0.0053 | 0.53% |
| Roscoe | 1 | 0.0000 | 0.00% |
| Gasport | 1 | 0.0000 | 0.00% |
| Marathon | 1 | 0.0000 | 0.00% |
| Gardiner | 2 | 0.0000 | 0.00% |
| Honeoye | 37 | 0.0008 | 0.08% |
| Randolph | 70 | 0.0015 | 0.15% |
| Cincinnatus | 2 | 0.0000 | 0.00% |
| TOTAL GENERAL | 46.559 | 1.0000 | 100.00% |
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
Interpretación: la zona cartográfica con mayor frecuencia es Knapp Creek, con 6.650 pozos (14.28% del total). La frecuencia mínima es de 1 pozo(s) y corresponde a 90 zonas cartográficas.
# La segunda TDF solo se muestra cuando hay más de diez categorías.
# Si existen diez o menos zonas, la primera TDF es suficiente.
if (k_zonas > 10L) {
cat("## Top 10 de categorías con mayor frecuencia absoluta {-}\n\n")
cat("El Cuadro N° 2 presenta las 10 zonas cartográficas más frecuentes ",
"ordenadas de mayor a menor y agrupa las restantes en Otras zonas cartográficas ",
"(siempre al final), conservando los ",
fmt_entero(N), " registros válidos (",
sprintf("%.2f%%", pct_top10), " en el Top 10).\n\n", sep="")
cat(crear_cuadro(tabla_resumen, 2,
"Distribución de frecuencias de los pozos regulados: 10 zonas cartográficas más frecuentes y Otras, Nueva York, 1860 - 2026"))
}
El Cuadro N° 2 presenta las 10 zonas cartográficas más frecuentes ordenadas de mayor a menor y agrupa las restantes en Otras zonas cartográficas (siempre al final), conservando los 46.559 registros válidos (59.00% en el Top 10).
| ZONA CARTOGRÁFICA | FRECUENCIA ABSOLUTA (nᵢ) | FRECUENCIA RELATIVA (hᵢ) | FRECUENCIA RELATIVA PORCENTUAL (%) |
|---|---|---|---|
| Knapp Creek | 6.650 | 0.1428 | 14.28% |
| Allentown | 6.154 | 0.1322 | 13.22% |
| Bolivar | 5.998 | 0.1288 | 12.88% |
| Olean | 2.966 | 0.0637 | 6.37% |
| Whitesville | 1.457 | 0.0313 | 3.13% |
| Wellsville South | 1.236 | 0.0265 | 2.65% |
| Rexville | 982 | 0.0211 | 2.11% |
| Lakewood | 871 | 0.0187 | 1.87% |
| Greenwood | 581 | 0.0125 | 1.25% |
| Wellsville North | 575 | 0.0123 | 1.23% |
| Otras zonas cartográficas | 19.089 | 0.4100 | 41.00% |
| TOTAL GENERAL | 46.559 | 1.0000 | 100.00% |
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
ggplot2::ggplot(tabla_local, ggplot2::aes(x=Zona,y=ni,fill=Zona)) +
ggplot2::geom_col(width=.72,color="#244861",linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=fmt_entero(ni)),vjust=-.48,
size=4.5,fontface="bold",color="#15364C") +
ggplot2::scale_fill_manual(values=colores) +
escala_zonas +
ggplot2::scale_y_continuous(limits=c(0,limite_ni_local),
labels=fmt_entero,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::labs(title="Gráfica N° 1: Frecuencia absoluta (nᵢ) local",
x="Zona cartográfica",y="Frecuencia absoluta (nᵢ)",caption=fuente_graficas) +
tema_barras
ggplot2::ggplot(tabla_global, ggplot2::aes(x=Zona,y=ni)) +
ggplot2::geom_col(fill="#286492",color="#244861",width=.72,linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=fmt_entero(ni)),vjust=-.48,
size=4.5,fontface="bold",color="#15364C") +
escala_zonas +
ggplot2::scale_y_continuous(limits=c(0,limite_ni_global),
labels=fmt_entero,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::labs(title="Gráfica N° 2: Frecuencia absoluta (nᵢ) global",
x="Zona cartográfica",y="Frecuencia absoluta (nᵢ)",caption=fuente_graficas) +
tema_barras
ggplot2::ggplot(tabla_local, ggplot2::aes(x=Zona,y=hi,fill=Zona)) +
ggplot2::geom_col(width=.72,color="#244861",linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=sprintf("%.2f%%",100*hi)),vjust=-.48,
size=4.3,fontface="bold",color="#15364C") +
ggplot2::scale_fill_manual(values=colores) +
escala_zonas +
ggplot2::scale_y_continuous(limits=c(0,limite_hi_local),labels=etiqueta_pct,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::labs(title="Gráfica N° 3: Frecuencia relativa (hᵢ) local",
x="Zona cartográfica",y="Frecuencia relativa (%)",caption=fuente_graficas) +
tema_barras
ggplot2::ggplot(tabla_global, ggplot2::aes(x=Zona,y=hi)) +
ggplot2::geom_col(fill="#286492",color="#244861",width=.72,linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=sprintf("%.2f%%",100*hi)),vjust=-.48,
size=4.3,fontface="bold",color="#15364C") +
escala_zonas +
ggplot2::scale_y_continuous(limits=c(0,limite_hi_global),
breaks=seq(0,1,by=.2),labels=etiqueta_pct,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::labs(title="Gráfica N° 4: Frecuencia relativa (hᵢ) global",
x="Zona cartográfica",y="Frecuencia relativa (%)",caption=fuente_graficas) +
tema_barras
leyenda <- paste0(stringr::str_wrap(as.character(tabla_local$Zona),width=23),
" — ",sprintf("%.2f%%",tabla_local$porcentaje))
ggplot2::ggplot(tabla_local,ggplot2::aes(x=1,y=ni,fill=Zona)) +
ggplot2::geom_col(width=1,color="#244861",linewidth=.48) +
ggplot2::coord_polar(theta="y",start=0) +
ggplot2::scale_fill_manual(values=colores,labels=leyenda) +
ggplot2::labs(title="Gráfica N° 5: Distribución porcentual según la zona cartográfica",
fill="Zona cartográfica — porcentaje",caption=fuente_graficas) +
ggplot2::theme_void(base_size=15) +
ggplot2::theme(
plot.title=ggplot2::element_text(hjust=.5,face="bold",size=17,color="#15364C"),
plot.subtitle=ggplot2::element_text(hjust=.5,size=12,color="#49657A",
margin=ggplot2::margin(t=7,b=12)),
legend.position="right",
legend.title=ggplot2::element_text(face="bold",size=13,color="#15364C"),
legend.text=ggplot2::element_text(size=12,color="#253B4B",lineheight=1.05),
legend.key.size=grid::unit(.56,"cm"),
plot.caption=ggplot2::element_text(hjust=0,face="italic",size=10.5,
color="#546775",margin=ggplot2::margin(t=14)),
plot.margin=ggplot2::margin(18,30,25,24)
)
cat(crear_indicadores())
| VARIABLE ANALIZADA | Media (X̄) | Mediana (Me) | Moda (Mo) | Desviación estándar (Sd) | Coeficiente de variación (CV %) | Asimetría (As) | Curtosis (K) | Valores atípicos (Outliers) |
|---|---|---|---|---|---|---|---|---|
| QUAD (Zona cartográfica) | N/A | N/A | Knapp Creek | N/A | N/A | N/A | N/A | N/A |
N/A: No aplicable a una variable cualitativa nominal.
Registros válidos (N): 46.559 | Categorías: 434 | Frecuencia modal: 6.650 | Porcentaje modal: 14.28%.
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
La variable QUAD (Zona cartográfica) es cualitativa nominal y presenta 434 categorías en 46.559 registros válidos. La moda corresponde a Knapp Creek, con una frecuencia de 6.650 pozos (14.28% del total), lo que evidencia una concentración de los registros en determinadas zonas cartográficas del estado de Nueva York.
Autor: Jennifer Cordones | Análisis Estadístico — Oil, Gas & Other Regulated Wells - NY State