ruta <- "C:/Users/cordo/OneDrive/Desktop/ESTADISITCA/Oil__Gas____Other_Regulated_Wells__Beginning_1860.csv"
datos_originales <- readr::read_delim(
ruta, delim=";", trim_ws=TRUE, show_col_types=FALSE,
name_repair="minimal", locale=readr::locale(encoding="UTF-8")
)
cat("Carga exitosa:", fmt_entero(nrow(datos_originales)), "registros.\n")
## Carga exitosa: 47.407 registros.
quad_limpio <- datos_originales |>
dplyr::transmute(Zona=stringr::str_squish(as.character(.data[[columna_quad]]))) |>
dplyr::filter(!is.na(Zona), Zona != "", !toupper(Zona) %in% c("NA", "N/A", "NULL"))
set.seed(2026)
quad_limpio$Zona <- factor(quad_limpio$Zona,
levels=sample(unique(quad_limpio$Zona)))
N <- nrow(quad_limpio)
if (N == 0L) stop("No existen registros válidos de Quad.")
cat("Registros válidos:", fmt_entero(N),
" | Zonas cartográficas distintas:", nlevels(quad_limpio$Zona), "\n")
## Registros válidos: 46.444 | Zonas cartográficas distintas: 434
La variable Quad (Zona cartográfica) es cualitativa nominal: identifica las zonas cartográficas donde se ubican los pozos regulados, sin establecer un orden jerárquico natural entre sus categorías.
tipo_variable <- "Cualitativa nominal"
cat(crear_cuadro(tabla_frecuencias, 1,
"Distribución de frecuencias de los pozos regulados según la zona cartográfica en el estado de Nueva York, 1860 - Actualidad",
desplazamiento=nrow(tabla_frecuencias)>20))
| ZONA CARTOGRÁFICA | FRECUENCIA ABSOLUTA (nᵢ) | FRECUENCIA RELATIVA (hᵢ) | FRECUENCIA RELATIVA PORCENTUAL (%) |
|---|---|---|---|
| Canajoharie | 3 | 0.0001 | 0.01% |
| Hamburg | 217 | 0.0047 | 0.47% |
| Derrick City PA-NY | 10 | 0.0002 | 0.02% |
| Candor | 13 | 0.0003 | 0.03% |
| Ripley | 166 | 0.0036 | 0.36% |
| Park Ridge | 2 | 0.0000 | 0.00% |
| Lakewood | 871 | 0.0188 | 1.88% |
| Brockport | 2 | 0.0000 | 0.00% |
| Batavia North | 23 | 0.0005 | 0.05% |
| Cortland | 2 | 0.0000 | 0.00% |
| Maine | 4 | 0.0001 | 0.01% |
| Hartfield | 264 | 0.0057 | 0.57% |
| North East PA | 4 | 0.0001 | 0.01% |
| Westdale | 3 | 0.0001 | 0.01% |
| Treadwell | 2 | 0.0000 | 0.00% |
| Verona | 3 | 0.0001 | 0.01% |
| Seager | 1 | 0.0000 | 0.00% |
| Rochester East | 3 | 0.0001 | 0.01% |
| Westfield | 309 | 0.0067 | 0.67% |
| Middleburgh | 1 | 0.0000 | 0.00% |
| Broadalbin | 1 | 0.0000 | 0.00% |
| Marathon | 1 | 0.0000 | 0.00% |
| Hancock | 2 | 0.0000 | 0.00% |
| Greene | 2 | 0.0000 | 0.00% |
| Hensonville | 1 | 0.0000 | 0.00% |
| Big Flats | 39 | 0.0008 | 0.08% |
| Sheldrake | 6 | 0.0001 | 0.01% |
| Adams | 3 | 0.0001 | 0.01% |
| Auburn | 54 | 0.0012 | 0.12% |
| Leicester | 107 | 0.0023 | 0.23% |
| Mount Vision | 1 | 0.0000 | 0.00% |
| Rawson | 22 | 0.0005 | 0.05% |
| West Groton | 17 | 0.0004 | 0.04% |
| Sugar Grove PA | 3 | 0.0001 | 0.01% |
| Portville | 51 | 0.0011 | 0.11% |
| Freedom | 10 | 0.0002 | 0.02% |
| Fishs Eddy | 6 | 0.0001 | 0.01% |
| Forestville | 365 | 0.0079 | 0.79% |
| Altamont | 1 | 0.0000 | 0.00% |
| Margaretville | 1 | 0.0000 | 0.00% |
| Jordan | 4 | 0.0001 | 0.01% |
| Oneonta | 3 | 0.0001 | 0.01% |
| Jamaica | 5 | 0.0001 | 0.01% |
| Lysander | 4 | 0.0001 | 0.01% |
| Cambria | 4 | 0.0001 | 0.01% |
| Canandaigua Lake | 7 | 0.0002 | 0.02% |
| Kent | 5 | 0.0001 | 0.01% |
| Owasco | 1 | 0.0000 | 0.00% |
| Canastota | 1 | 0.0000 | 0.00% |
| Knapp Creek | 6.622 | 0.1426 | 14.26% |
| Camillus | 9 | 0.0002 | 0.02% |
| Lodi | 7 | 0.0002 | 0.02% |
| Jersey City | 80 | 0.0017 | 0.17% |
| Dresden | 3 | 0.0001 | 0.01% |
| Erieville | 2 | 0.0000 | 0.00% |
| Mexico | 3 | 0.0001 | 0.01% |
| Red House | 32 | 0.0007 | 0.07% |
| Orchard Park | 149 | 0.0032 | 0.32% |
| Rush | 21 | 0.0005 | 0.05% |
| Richfield Springs | 1 | 0.0000 | 0.00% |
| Freehold | 1 | 0.0000 | 0.00% |
| Herkimer | 8 | 0.0002 | 0.02% |
| Randolph | 70 | 0.0015 | 0.15% |
| Limestone | 557 | 0.0120 | 1.20% |
| Bradford NY | 43 | 0.0009 | 0.09% |
| Morrisonville | 1 | 0.0000 | 0.00% |
| Hicksville | 2 | 0.0000 | 0.00% |
| Ithaca East | 2 | 0.0000 | 0.00% |
| Camden West | 9 | 0.0002 | 0.02% |
| East Springfield | 4 | 0.0001 | 0.01% |
| Cassadaga | 225 | 0.0048 | 0.48% |
| Wyoming | 349 | 0.0075 | 0.75% |
| Hannibal | 1 | 0.0000 | 0.00% |
| Angelica | 17 | 0.0004 | 0.04% |
| Hobart | 1 | 0.0000 | 0.00% |
| Clinton | 1 | 0.0000 | 0.00% |
| Gilbertsville | 1 | 0.0000 | 0.00% |
| Trumansburg | 10 | 0.0002 | 0.02% |
| Ransomville | 2 | 0.0000 | 0.00% |
| Sonyea | 26 | 0.0006 | 0.06% |
| Lisle | 1 | 0.0000 | 0.00% |
| Canaseraga | 5 | 0.0001 | 0.01% |
| Newfane | 2 | 0.0000 | 0.00% |
| Geneva South | 132 | 0.0028 | 0.28% |
| West Henrietta | 1 | 0.0000 | 0.00% |
| Chautauqua | 246 | 0.0053 | 0.53% |
| Deposit | 1 | 0.0000 | 0.00% |
| Pulaski | 94 | 0.0020 | 0.20% |
| Olean | 2.966 | 0.0639 | 6.39% |
| Willet | 3 | 0.0001 | 0.01% |
| Wattsburg, PA-NY | 12 | 0.0003 | 0.03% |
| Hartford | 1 | 0.0000 | 0.00% |
| Fort Plain | 1 | 0.0000 | 0.00% |
| Ticonderoga | 3 | 0.0001 | 0.01% |
| Avoca | 20 | 0.0004 | 0.04% |
| Clarence Center | 3 | 0.0001 | 0.01% |
| Cuba | 31 | 0.0007 | 0.07% |
| Victor | 30 | 0.0006 | 0.06% |
| Hamden | 1 | 0.0000 | 0.00% |
| North Collins | 380 | 0.0082 | 0.82% |
| Gerry | 323 | 0.0070 | 0.70% |
| Weedsport | 20 | 0.0004 | 0.04% |
| Towlesville | 32 | 0.0007 | 0.07% |
| Delevan | 19 | 0.0004 | 0.04% |
| Dunkirk | 427 | 0.0092 | 0.92% |
| Potter | 14 | 0.0003 | 0.03% |
| North Western | 2 | 0.0000 | 0.00% |
| Castile | 89 | 0.0019 | 0.19% |
| Oxford | 3 | 0.0001 | 0.01% |
| New Boston | 1 | 0.0000 | 0.00% |
| Alexander | 188 | 0.0040 | 0.40% |
| Glenville, CT-NY | 2 | 0.0000 | 0.00% |
| Montezuma | 4 | 0.0001 | 0.01% |
| West Valley | 20 | 0.0004 | 0.04% |
| Angola | 65 | 0.0014 | 0.14% |
| Barton | 6 | 0.0001 | 0.01% |
| Rushville | 35 | 0.0008 | 0.08% |
| Ogdensburg East | 1 | 0.0000 | 0.00% |
| East Pharsalia | 9 | 0.0002 | 0.02% |
| Chenango Forks | 29 | 0.0006 | 0.06% |
| High Market | 1 | 0.0000 | 0.00% |
| Langford | 399 | 0.0086 | 0.86% |
| Morris | 2 | 0.0000 | 0.00% |
| Medina | 2 | 0.0000 | 0.00% |
| South Ripley | 210 | 0.0045 | 0.45% |
| West Eaton | 40 | 0.0009 | 0.09% |
| Central Square | 1 | 0.0000 | 0.00% |
| Canandaigua | 22 | 0.0005 | 0.05% |
| Napanoch | 1 | 0.0000 | 0.00% |
| Strykersville | 108 | 0.0023 | 0.23% |
| Ellery Center | 275 | 0.0059 | 0.59% |
| Oakfield | 82 | 0.0018 | 0.18% |
| Van Etten | 34 | 0.0007 | 0.07% |
| Hamlet | 246 | 0.0053 | 0.53% |
| Alfred | 15 | 0.0003 | 0.03% |
| Sprout Brook | 2 | 0.0000 | 0.00% |
| Wellsville South | 1.220 | 0.0263 | 2.63% |
| Barker | 1 | 0.0000 | 0.00% |
| Bath | 27 | 0.0006 | 0.06% |
| Dansville | 25 | 0.0005 | 0.05% |
| Seneca Falls | 52 | 0.0011 | 0.11% |
| Pike | 5 | 0.0001 | 0.01% |
| Munnsville | 1 | 0.0000 | 0.00% |
| Tonawanda East | 48 | 0.0010 | 0.10% |
| East Aurora | 163 | 0.0035 | 0.35% |
| North Of Dunkirk | 24 | 0.0005 | 0.05% |
| Owego | 41 | 0.0009 | 0.09% |
| Scipio Center | 26 | 0.0006 | 0.06% |
| Gulf Summit | 2 | 0.0000 | 0.00% |
| Lancaster | 100 | 0.0022 | 0.22% |
| Cherry Creek | 282 | 0.0061 | 0.61% |
| Sidney | 3 | 0.0001 | 0.01% |
| Borden | 43 | 0.0009 | 0.09% |
| Johnsonburg | 23 | 0.0005 | 0.05% |
| Durham | 1 | 0.0000 | 0.00% |
| Gasport | 1 | 0.0000 | 0.00% |
| Gloversville | 2 | 0.0000 | 0.00% |
| South Canisteo | 51 | 0.0011 | 0.11% |
| Black Creek | 17 | 0.0004 | 0.04% |
| Ashwood | 3 | 0.0001 | 0.01% |
| Naples | 20 | 0.0004 | 0.04% |
| Wayne | 186 | 0.0040 | 0.40% |
| Jordanville | 1 | 0.0000 | 0.00% |
| West Winfield | 1 | 0.0000 | 0.00% |
| Ellicottville | 33 | 0.0007 | 0.07% |
| Earlville | 86 | 0.0019 | 0.19% |
| Caledonia | 66 | 0.0014 | 0.14% |
| Nyack | 5 | 0.0001 | 0.01% |
| Flushing | 2 | 0.0000 | 0.00% |
| Brooklyn | 70 | 0.0015 | 0.15% |
| Keuka Park | 38 | 0.0008 | 0.08% |
| Mecklenburg | 14 | 0.0003 | 0.03% |
| Pennellville | 12 | 0.0003 | 0.03% |
| Conesus | 3 | 0.0001 | 0.01% |
| Camden East | 7 | 0.0002 | 0.02% |
| Romulus | 203 | 0.0044 | 0.44% |
| Cowlesville | 214 | 0.0046 | 0.46% |
| Apalachin | 40 | 0.0009 | 0.09% |
| Hornell | 22 | 0.0005 | 0.05% |
| Salamanca | 12 | 0.0003 | 0.03% |
| South Valley | 1 | 0.0000 | 0.00% |
| Niagara Falls | 2 | 0.0000 | 0.00% |
| Forestport | 1 | 0.0000 | 0.00% |
| Waverly | 10 | 0.0002 | 0.02% |
| Ilion | 2 | 0.0000 | 0.00% |
| Ellisburg | 5 | 0.0001 | 0.01% |
| Pulteney | 29 | 0.0006 | 0.06% |
| Dundee | 18 | 0.0004 | 0.04% |
| Stafford | 103 | 0.0022 | 0.22% |
| Tribes Hill | 3 | 0.0001 | 0.01% |
| Middletown | 1 | 0.0000 | 0.00% |
| Sylvan Beach | 2 | 0.0000 | 0.00% |
| Andover | 176 | 0.0038 | 0.38% |
| Silver Creek | 183 | 0.0039 | 0.39% |
| Homer | 3 | 0.0001 | 0.01% |
| Geneseo | 109 | 0.0023 | 0.23% |
| Caton | 24 | 0.0005 | 0.05% |
| Carthage | 1 | 0.0000 | 0.00% |
| Hubbardsville | 17 | 0.0004 | 0.04% |
| North Sanford | 4 | 0.0001 | 0.01% |
| Horton | 18 | 0.0004 | 0.04% |
| Union Springs | 105 | 0.0023 | 0.23% |
| Williamstown | 3 | 0.0001 | 0.01% |
| Colden | 295 | 0.0064 | 0.64% |
| Campbell | 35 | 0.0008 | 0.08% |
| Livonia | 33 | 0.0007 | 0.07% |
| Milford | 4 | 0.0001 | 0.01% |
| Honeoye Falls | 4 | 0.0001 | 0.01% |
| Oran | 1 | 0.0000 | 0.00% |
| Columbus PA-NY | 1 | 0.0000 | 0.00% |
| Baldwinsville | 67 | 0.0014 | 0.14% |
| Oswayo, PA-NY | 2 | 0.0000 | 0.00% |
| Belmont | 70 | 0.0015 | 0.15% |
| Sardinia | 58 | 0.0012 | 0.12% |
| Albion | 1 | 0.0000 | 0.00% |
| Wellsville North | 575 | 0.0124 | 1.24% |
| Dugway | 2 | 0.0000 | 0.00% |
| Norwich | 10 | 0.0002 | 0.02% |
| Woodstock | 1 | 0.0000 | 0.00% |
| Groton | 18 | 0.0004 | 0.04% |
| Cannonsville Reservoir | 2 | 0.0000 | 0.00% |
| Saratoga Springs | 1 | 0.0000 | 0.00% |
| New Albion | 159 | 0.0034 | 0.34% |
| Alpine | 8 | 0.0002 | 0.02% |
| Clarence | 261 | 0.0056 | 0.56% |
| Otisco Valley | 180 | 0.0039 | 0.39% |
| Cazenovia | 1 | 0.0000 | 0.00% |
| White Plains | 16 | 0.0003 | 0.03% |
| Troy South | 1 | 0.0000 | 0.00% |
| Rathbone | 37 | 0.0008 | 0.08% |
| Moravia | 5 | 0.0001 | 0.01% |
| Fulton | 10 | 0.0002 | 0.02% |
| Bliss | 24 | 0.0005 | 0.05% |
| Voorheesville | 1 | 0.0000 | 0.00% |
| Clymer | 170 | 0.0037 | 0.37% |
| Steamburg | 33 | 0.0007 | 0.07% |
| Carlisle | 3 | 0.0001 | 0.01% |
| Montour Falls | 28 | 0.0006 | 0.06% |
| Rexville | 982 | 0.0211 | 2.11% |
| Collins Center | 227 | 0.0049 | 0.49% |
| Ludlowville | 39 | 0.0008 | 0.08% |
| Stamford | 2 | 0.0000 | 0.00% |
| Saugerties | 1 | 0.0000 | 0.00% |
| Addison | 15 | 0.0003 | 0.03% |
| Warsaw | 14 | 0.0003 | 0.03% |
| Orwell | 1 | 0.0000 | 0.00% |
| Hartwick | 2 | 0.0000 | 0.00% |
| Savannah | 21 | 0.0005 | 0.05% |
| South Onondaga | 5 | 0.0001 | 0.01% |
| Tonawanda West | 4 | 0.0001 | 0.01% |
| Ellisburg, PA-NY | 2 | 0.0000 | 0.00% |
| Sandy Creek | 57 | 0.0012 | 0.12% |
| North East | 9 | 0.0002 | 0.02% |
| Monticello | 1 | 0.0000 | 0.00% |
| Savona | 33 | 0.0007 | 0.07% |
| Cementon | 1 | 0.0000 | 0.00% |
| Cayuga | 233 | 0.0050 | 0.50% |
| Smithville Flats | 19 | 0.0004 | 0.04% |
| Beaver Dams | 28 | 0.0006 | 0.06% |
| Cincinnatus | 2 | 0.0000 | 0.00% |
| Clifton Springs | 3 | 0.0001 | 0.01% |
| Perrysburg | 308 | 0.0066 | 0.66% |
| Lyons | 8 | 0.0002 | 0.02% |
| Kendall | 4 | 0.0001 | 0.01% |
| Farnham | 359 | 0.0077 | 0.77% |
| Franklin | 1 | 0.0000 | 0.00% |
| Brookfield | 4 | 0.0001 | 0.01% |
| Harford | 8 | 0.0002 | 0.02% |
| Gardiner | 2 | 0.0000 | 0.00% |
| Victory | 2 | 0.0000 | 0.00% |
| Mount Vernon | 15 | 0.0003 | 0.03% |
| Birdsall | 9 | 0.0002 | 0.02% |
| Geneva North | 85 | 0.0018 | 0.18% |
| Port Jervis North | 2 | 0.0000 | 0.00% |
| Greenwood | 579 | 0.0125 | 1.25% |
| Watertown | 2 | 0.0000 | 0.00% |
| Friendship | 285 | 0.0061 | 0.61% |
| Corinth | 1 | 0.0000 | 0.00% |
| Hinsdale | 111 | 0.0024 | 0.24% |
| Binghamton West | 2 | 0.0000 | 0.00% |
| Bolivar | 5.960 | 0.1283 | 12.83% |
| Endicott | 4 | 0.0001 | 0.01% |
| Middlesex | 11 | 0.0002 | 0.02% |
| Ashford | 37 | 0.0008 | 0.08% |
| Lyndonville | 3 | 0.0001 | 0.01% |
| Bloomville | 1 | 0.0000 | 0.00% |
| Dexter | 1 | 0.0000 | 0.00% |
| Burdett | 43 | 0.0009 | 0.09% |
| Arkport | 2 | 0.0000 | 0.00% |
| Mount Morris | 38 | 0.0008 | 0.08% |
| Morrisville | 3 | 0.0001 | 0.01% |
| Bradford PA | 2 | 0.0000 | 0.00% |
| Unadilla | 1 | 0.0000 | 0.00% |
| Rheims | 10 | 0.0002 | 0.02% |
| New Berlin South | 1 | 0.0000 | 0.00% |
| Ossining | 3 | 0.0001 | 0.01% |
| Cuyler | 1 | 0.0000 | 0.00% |
| Hudson Falls | 1 | 0.0000 | 0.00% |
| Corning | 41 | 0.0009 | 0.09% |
| Utica East | 1 | 0.0000 | 0.00% |
| Remsen | 1 | 0.0000 | 0.00% |
| Stanley | 19 | 0.0004 | 0.04% |
| Richland | 12 | 0.0003 | 0.03% |
| Afton | 10 | 0.0002 | 0.02% |
| Schroon Lake | 1 | 0.0000 | 0.00% |
| Seeley Creek | 42 | 0.0009 | 0.09% |
| Woodhull | 56 | 0.0012 | 0.12% |
| Central Park | 92 | 0.0020 | 0.20% |
| Eden | 217 | 0.0047 | 0.47% |
| Allentown | 6.154 | 0.1325 | 13.25% |
| Unadilla Forks | 1 | 0.0000 | 0.00% |
| Dale | 224 | 0.0048 | 0.48% |
| Houghton | 25 | 0.0005 | 0.05% |
| Penn Yan | 31 | 0.0007 | 0.07% |
| Otselic | 32 | 0.0007 | 0.07% |
| Cato | 10 | 0.0002 | 0.02% |
| Le Roy | 134 | 0.0029 | 0.29% |
| Peck Lake | 1 | 0.0000 | 0.00% |
| Van Hornesville | 1 | 0.0000 | 0.00% |
| Albany | 15 | 0.0003 | 0.03% |
| Ithaca West | 8 | 0.0002 | 0.02% |
| Sempronius | 4 | 0.0001 | 0.01% |
| Horseheads | 16 | 0.0003 | 0.03% |
| Castle Creek | 1 | 0.0000 | 0.00% |
| Oswego East | 4 | 0.0001 | 0.01% |
| Mallory | 3 | 0.0001 | 0.01% |
| Humphrey | 152 | 0.0033 | 0.33% |
| Sherman | 333 | 0.0072 | 0.72% |
| Prattsburg | 16 | 0.0003 | 0.03% |
| Pitcher | 1 | 0.0000 | 0.00% |
| Mcgraw | 10 | 0.0002 | 0.02% |
| Haskinville | 6 | 0.0001 | 0.01% |
| Guilford | 1 | 0.0000 | 0.00% |
| Clifton | 16 | 0.0003 | 0.03% |
| Spencer | 14 | 0.0003 | 0.03% |
| Burnt Hills | 1 | 0.0000 | 0.00% |
| Macedon | 4 | 0.0001 | 0.01% |
| Wolcottsville | 14 | 0.0003 | 0.03% |
| Otisville | 2 | 0.0000 | 0.00% |
| Brocton | 148 | 0.0032 | 0.32% |
| West Lowville | 6 | 0.0001 | 0.01% |
| West Bainbridge | 16 | 0.0003 | 0.03% |
| Pattersonville | 1 | 0.0000 | 0.00% |
| Vernon | 2 | 0.0000 | 0.00% |
| South Trenton | 2 | 0.0000 | 0.00% |
| Erin | 45 | 0.0010 | 0.10% |
| Jewell | 1 | 0.0000 | 0.00% |
| Newark Valley | 5 | 0.0001 | 0.01% |
| Wappingers Falls | 26 | 0.0006 | 0.06% |
| Bristol Springs | 10 | 0.0002 | 0.02% |
| Cameron | 32 | 0.0007 | 0.07% |
| West Danby | 16 | 0.0003 | 0.03% |
| Dryden | 1 | 0.0000 | 0.00% |
| Wolcott | 11 | 0.0002 | 0.02% |
| Hammondsport | 19 | 0.0004 | 0.04% |
| North Clymer | 278 | 0.0060 | 0.60% |
| Oneida | 1 | 0.0000 | 0.00% |
| Gowanda | 285 | 0.0061 | 0.61% |
| Buffalo NW | 42 | 0.0009 | 0.09% |
| Ashford Hollow | 58 | 0.0012 | 0.12% |
| Sackets Harbor | 1 | 0.0000 | 0.00% |
| Cattaraugus | 35 | 0.0008 | 0.08% |
| Rome | 18 | 0.0004 | 0.04% |
| Willseyville | 3 | 0.0001 | 0.01% |
| Knowlesville | 5 | 0.0001 | 0.01% |
| Yonkers | 25 | 0.0005 | 0.05% |
| Middle Grove | 1 | 0.0000 | 0.00% |
| Akron | 81 | 0.0017 | 0.17% |
| Rotterdam Junction | 1 | 0.0000 | 0.00% |
| Wayland | 2 | 0.0000 | 0.00% |
| Roxbury | 1 | 0.0000 | 0.00% |
| Utica West | 2 | 0.0000 | 0.00% |
| Jamestown | 300 | 0.0065 | 0.65% |
| Troupsburg | 49 | 0.0011 | 0.11% |
| Hamlin | 2 | 0.0000 | 0.00% |
| Skaneateles | 5 | 0.0001 | 0.01% |
| Panama | 251 | 0.0054 | 0.54% |
| Black River | 2 | 0.0000 | 0.00% |
| Buffalo SE | 117 | 0.0025 | 0.25% |
| Belden | 8 | 0.0002 | 0.02% |
| Oriskany Falls | 6 | 0.0001 | 0.01% |
| Fillmore | 36 | 0.0008 | 0.08% |
| Genoa | 17 | 0.0004 | 0.04% |
| Point Rock | 1 | 0.0000 | 0.00% |
| Buffalo NE | 66 | 0.0014 | 0.14% |
| New Berlin North | 1 | 0.0000 | 0.00% |
| Boonville | 1 | 0.0000 | 0.00% |
| Franklinville | 9 | 0.0002 | 0.02% |
| Schuylerville | 1 | 0.0000 | 0.00% |
| West Almond | 10 | 0.0002 | 0.02% |
| Syracuse West | 3 | 0.0001 | 0.01% |
| Reading Center | 170 | 0.0037 | 0.37% |
| Springville | 137 | 0.0029 | 0.29% |
| Batavia South | 36 | 0.0008 | 0.08% |
| Belfort | 1 | 0.0000 | 0.00% |
| Honeoye | 37 | 0.0008 | 0.08% |
| Whitney Point | 3 | 0.0001 | 0.01% |
| Phoenicia | 3 | 0.0001 | 0.01% |
| Sugar Grove, PA-NY | 20 | 0.0004 | 0.04% |
| Holland | 191 | 0.0041 | 0.41% |
| Ovid | 3 | 0.0001 | 0.01% |
| Portageville | 14 | 0.0003 | 0.03% |
| Newark | 1 | 0.0000 | 0.00% |
| Westernville | 4 | 0.0001 | 0.01% |
| Corfu | 335 | 0.0072 | 0.72% |
| Rodman | 1 | 0.0000 | 0.00% |
| Cooperstown | 1 | 0.0000 | 0.00% |
| Churchville | 8 | 0.0002 | 0.02% |
| Elmira | 33 | 0.0007 | 0.07% |
| Little Valley | 6 | 0.0001 | 0.01% |
| Kennedy | 243 | 0.0052 | 0.52% |
| Attica | 86 | 0.0019 | 0.19% |
| Canisteo | 35 | 0.0008 | 0.08% |
| Quaker Springs | 1 | 0.0000 | 0.00% |
| Marcellus | 18 | 0.0004 | 0.04% |
| Ivory | 146 | 0.0031 | 0.31% |
| Byron | 21 | 0.0005 | 0.05% |
| Wellsburg | 12 | 0.0003 | 0.03% |
| Arcade | 94 | 0.0020 | 0.20% |
| Roscoe | 1 | 0.0000 | 0.00% |
| Holley | 7 | 0.0002 | 0.02% |
| Whitesville | 1.457 | 0.0314 | 3.14% |
| Tyner | 20 | 0.0004 | 0.04% |
| Ossian | 8 | 0.0002 | 0.02% |
| Shandaken | 1 | 0.0000 | 0.00% |
| Sodus | 1 | 0.0000 | 0.00% |
| Bristol Center | 110 | 0.0024 | 0.24% |
| Florence | 4 | 0.0001 | 0.01% |
| Phelps | 13 | 0.0003 | 0.03% |
| Nunda | 6 | 0.0001 | 0.01% |
| Hamilton | 67 | 0.0014 | 0.14% |
| Brisben | 2 | 0.0000 | 0.00% |
| North Of Westfield | 1 | 0.0000 | 0.00% |
| Fort Ann | 1 | 0.0000 | 0.00% |
| Total | 46.444 | 1.0000 | 100.00% |
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
La tabla resume las 10 zonas cartográficas más frecuentes y agrupa las demás en Otros, conservando el total de 46.444 registros válidos.
cat(crear_cuadro(tabla_resumen, 2,
"Distribución de frecuencias de los pozos regulados: 10 zonas cartográficas más frecuentes y Otros, Nueva York, 1860 - Actualidad"))
| ZONA CARTOGRÁFICA | FRECUENCIA ABSOLUTA (nᵢ) | FRECUENCIA RELATIVA (hᵢ) | FRECUENCIA RELATIVA PORCENTUAL (%) |
|---|---|---|---|
| Knapp Creek | 6.622 | 0.1426 | 14.26% |
| Allentown | 6.154 | 0.1325 | 13.25% |
| Bolivar | 5.960 | 0.1283 | 12.83% |
| Olean | 2.966 | 0.0639 | 6.39% |
| Whitesville | 1.457 | 0.0314 | 3.14% |
| Wellsville South | 1.220 | 0.0263 | 2.63% |
| Rexville | 982 | 0.0211 | 2.11% |
| Lakewood | 871 | 0.0188 | 1.88% |
| Greenwood | 579 | 0.0125 | 1.25% |
| Wellsville North | 575 | 0.0124 | 1.24% |
| Otros | 19.058 | 0.4103 | 41.03% |
| Total | 46.444 | 1.0000 | 100.00% |
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
ggplot2::ggplot(tabla_plot, ggplot2::aes(Zona, ni, fill=Zona)) +
ggplot2::geom_col(width=.72) +
ggplot2::geom_text(ggplot2::aes(label=fmt_entero(ni)),vjust=-.4,size=3) +
ggplot2::scale_fill_manual(values=colores) +
ggplot2::scale_y_continuous(expand=ggplot2::expansion(mult=c(0,.14))) +
ggplot2::labs(title="Gráfica N° 1: Frecuencia absoluta por zona cartográfica",x="Zona",y="Frecuencia absoluta (nᵢ)") + tema_barras
ggplot2::ggplot(tabla_plot, ggplot2::aes(Zona, porcentaje, fill=Zona)) +
ggplot2::geom_col(width=.72) +
ggplot2::geom_text(ggplot2::aes(label=sprintf("%.2f%%",porcentaje)),vjust=-.4,size=3) +
ggplot2::scale_fill_manual(values=colores) +
ggplot2::scale_y_continuous(expand=ggplot2::expansion(mult=c(0,.14))) +
ggplot2::labs(title="Gráfica N° 2: Frecuencia porcentual por zona cartográfica",x="Zona",y="Frecuencia relativa porcentual (%)") + tema_barras
leyenda <- paste0(as.character(tabla_plot$Zona), " — ", sprintf("%.2f%%",tabla_plot$porcentaje))
ggplot2::ggplot(tabla_plot,ggplot2::aes(x=1,y=ni,fill=Zona)) +
ggplot2::geom_col(width=1,color="white",linewidth=.35) +
ggplot2::coord_polar(theta="y",start=0) +
ggplot2::scale_fill_manual(values=colores,labels=leyenda) +
ggplot2::labs(title="Gráfica N° 3: Distribución porcentual por zona cartográfica",fill="Zona — porcentaje") +
ggplot2::theme_void() + ggplot2::theme(plot.title=ggplot2::element_text(hjust=.5,face="bold"),legend.position="right")
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.444 | Categorías: 434 | Frecuencia modal: 6.622 | Porcentaje modal: 14.26%.
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
La variable Quad (Zona cartográfica) es cualitativa nominal policotómica y presenta 434 categorías en 46.444 registros válidos. La moda corresponde a Knapp Creek, con una frecuencia de 6.622 pozos (14.26% 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