ERROR IN COR-supply both 'x' and 'y' or a matrix-like 'x'

why am i getting this error??

Well, at first glance you have a data set (tibble) called variables and you are running a correlation on a data set called dat. I do not see any variable in the screenshot called "Perfs" but if it exists then

cor(variables$Perfs, variables$Clusters)

should work.

Screenshots tend to be close to useless. See

A handy way to supply some sample data is the dput() function. In the case of a large dataset something like dput(head(mydata, 100)) should supply the data we need. Just do dput(mydata) where mydata is your data. Copy the output and paste it here.

that worked... now i getting the same error on a different line. "Error in cor(variables) : 'x' must be numeric" on correlation for all variables


title: "correlationdata"
output: html_document
date: "2023-01-22"


title: "Correlation between IP and production variables"
#By:John Riley
output: html_document
date: "2023-01-22"

library(readxl)
variables <- read_excel("data/variables.xlsx")
# display first 5 observations
head(variables, 205)
# Pearson correlation between 2 variables
cor(variables$Perfs, variables$Clusters)
# Spearman correlation between 2 variables
cor(variables$Perfs, variables$Clusters,
  method = "spearman")
# correlation for all variables
round(cor(variables),
  digits = 2 # rounded to 2 decimals
)

Basically we need a REPREX and some or all of your data. And the exact error messages

dput(head(variables, 100)) structure(list(WellName = c("AFFIRMED 23 STATE UNIT 2H", "AFFIRMED 23 STATE UNIT 1H", "AMERICAN PHAROAH 43 STATE UNIT 1H", "ANACONDA STATE 55-2 7H", "ANACONDA STATE 55-2 6H", "ANACONDA STATE 55-2 5H", "ANACONDA STATE 55-2 4H", "ANACONDA STATE 55-2 3H", "ANACONDA STATE 55-2 2H", "ANACONDA STATE 55-2 1H", "ANIMAL KINGDOM 44 A 3H", "ANIMAL KINGDOM 44 FEE 2H", "APOLLO 48 UNIT 2H", "ARISTIDES 2 UNIT 1H", "ARVINE 28A-2H", "ARVINE 28-1H (R/E)", "ASSAULT 14 UNIT 2H (FKA 1H)", "BADEN BADEN 7 STATE UNIT 1H", "BARBARO 23 UNIT 4H", "BARBARO 23 UNIT 3H", "BARBARO 23 UNIT 2H", "BARBARO 23 UNIT 1H", "BARNES DE ESTATE 3H", "BEAVERHEAD STATE 2-24 UNIT 1H", "BIG BROWN 30 FEE 1H", "BIG SKY STATE 55-16 1H R/E", "BIG TIMBER STATE 57-25 UNIT 1H", "BIGFOOT C21-6 UNIT 1H", "BIGHORN NORTH UNIT 1-31 1H", "BIGHORN SOUTH UNIT 1-31 2H", "BLACK GOLD 26 FEE 1H", "BLACKTAIL 1-34 UNIT 1H", "BOULDER STATE 57-32 1H", "BRIDGER 1-36 2H", "BRIDGER 1-36 1H", "BROKERS TIP 24 STATE UNIT 1H", "CABINET STATE 55-2 UNIT 1H", "CALIFORNIA CHROME 39 STATE UNIT 1H", "CANNONADE 4 FEE 1XH", "CASTLE 57-27 1H", "CATHEDRAL STATE 57-6 UNIT 2H", "CAVALCADE 25 UNIT 1H", "CHOSA DRAW 27 FEDERAL 3H", "CHUPACABRA 51 STATE 2H", "CITATION 32 FEE 1H", "CITATION 32 FEE 3H", "CLEVELAND STATE 57-23 1H", "CLEVELAND STATE 57-23 2H", "CLEVELAND STATE 57-23 3H", "CLEVELAND STATE 57-23 4H", "COTTONWOOD HILLS 32 STATE 1H", "COUNT FLEET 48 STATE 2H", "COUNT TURF 38 STATE 1H", "COURTHOUSE 57-27 1H", "DARK STAR 21 FEE 1", "DAY STAR 20 UNIT 1H", "DUST COMMANDER 26 STATE 1", "EIGHTEENMILE 56-18 1H", "ELECTRIC STATE 57-33 UNIT 1H", "ELKHORN 2-17 1H", "ELWOOD 29 UNIT 2H", "FERDINAND 27 UNIT 1H", "FLATHEAD 2-15 2H", "FLATHEAD 2-15 1H", "FLATHEAD 2-15 4H", "FLYING EBONY 19 STATE A 5H", "FOOLISH PLEASURE 6 FEE 2H", "FORWARD PASS 25 UNIT 2H", "FUNNY CIDE 32 A-2H", "FUNNY CIDE 32 FEE 1H", "GALLANT FOX 37 UNIT 1H", "GATO DEL SOL 34 UNIT 4H", "GATO DEL SOL 34 UNIT 3H", "GATO DEL SOL 34 UNIT 2H", "GATO DEL SOL 34 UNIT 1H", "GREATHOUSE C21-6 UNIT 4H", "GREATHOUSE C21-6 UNIT 3H", "GREATHOUSE C21-6 UNIT 2H", "GREATHOUSE C21-6 UNIT 1H", "GREENHORN NORTH UNIT 1-35 3H", "GREENHORN SOUTH UNIT 1-35 1H", "GREENHORN SOUTH UNIT 1-35 2H", "GRINDSTONE 2 FEE 1H", "HALLERTAU 5 FEDERAL COM 3H", "HARDSCRABBLE STATE 57-34 UNIT 1H", "HAYDUKE 34 FEDERAL COM 3H", "HINDOO 2 STATE UNIT 1H", "HIS EMINENCE 27 UNIT 1H", "HOOP JR 9 UNIT 1H", "HORNSBY 35 FEDERAL 3H", "HUCKLEBERRY C21-9 UNIT 1H", "JET PILOT 24 FEE 1H", "JET PILOT 24 UNIT A 5H", "JUDITH 2-16 UNIT 1H", "KINGMAN 45 STATE UNIT 2H", "KLEIN 33 FEDERAL COM 6H", "LEONATUS 11 UNIT 1H", "LIVINGSTON 2-12 1H", "LOOKOUT 18 FEE 1H", "LORD MURPHY 10 STATE 1H"), IP180DayBOE = c(1134.30333333333, 1060.66666666667, 1373, 252.666666666667, 381.833333333333, 301.833333333333, 337.166666666667, 294.166666666667, 342.666666666667, 296.666666666667, 1092.83333333333, 534.5, 1050.83333333333, 1101.33333333333, 791.287, 336.5, 980.333333333333, 983.333333333333, 514.666666666667, 455, 440.333333333333, 444.5, 175.235305555556, 311.666666666667, 370.166666666667, 371, 900.5, 950.666666666667, 720.666666666667, 811.333333333333, 366.833333333333, 660.5, 599.166666666667, 483.333333333333, 494.5, 862.582416666667, 637.5, 656.666666666667, 285.833333333333, 493.333333333333, 472.166666666667, 650.333333333333, 361.666666666667, 115.166666666667, 434, 653, 336.166666666667, 351.833333333333, 359, 392.333333333333, 284.666666666667, 761, 648, 535.666666666667, 539.833333333333, 661.666666666667, 234.666666666667, 342, 798.666666666667, 310.5, 987.030095238095, 470.333333333333, 542.5, 200.5, 249.666666666667, 1563, 519.833333333333, 526.333333333333, 963, 405.166666666667, 1308.33333333333, 793, 554.666666666667, 685.333333333333, 607.333333333333, 587, 744.5, 535.666666666667, 666.666666666667, 792.666666666667, 431.166666666667, 370.333333333333, 342.333333333333, 447.666666666667, 951, 734.166666666667, 1101.16666666667, 875.666666666667, 1344.66666666667, 612, 496.333333333333, 330.333333333333, 1093.16666666667, 334.833333333333, 734.5, 852.166666666667, 1136.33333333333, 328.333333333333, 339.833333333333, 518.333333333333 ), InitialReservoirPressure = c(3900, 4300, 4100, 7700, 7347, 7635, 7452, 7489, 7143, 8096, 5250, 6473, 6235, 6955, 4600, 6745, 7594, 3900, 7056, 7061, 6805, 6851, 6310, 7886, 6338, 7042, 6625, 7465, 8211, 7641, 5335, 7581, 6987, 8151, 8429, 4500, 7826, 5800, 5385, 7683, 6606, 5749, 6683, 5755, 6500, 6750, 7286, 7430, 7228, 7081, 6818, 6311, 6273, 7420, 6583, 6422, 6190, 7719, 6913, 8334, 4800, 6575, 7692, 8314, 8188, 6718, 6275, 7250, 4750, 5000, 7050, 4600, 4700, 4600, 5347, 6484, 7411, 6364, 7507, 8032, 8234, 8177, 6591, 8900, 7189, 6705, 6237, 5400, 6600, 7257, 6561, 5592, 6766, 8068, 4600, 7305, 7079, 8143, 6729, 5200), CompletedFeet = c(10092, 9207, 10015, 4348, 4329, 4310, 4727, 4740, 4785, 4358, 10084, 4734, 8318, 9892, 10124, 4094, 7245, 7373, 4510, 4517, 4686, 4420, 9637, 4345, 4509, 4301, 9938, 7673, 9013, 11208, 4605, 9494, 4574, 5571, 5990, 10301, 4522, 7139, 4567, 4151, 4552, 10336, 3777, 4739, 4497, 4474, 4855, 4868, 4895, 4915, 3973, 4624, 4443, 4359, 4848, 7190, 3601, 4033, 9799, 4223, 9758, 4521, 4729, 4143, 4268, 10094, 4597, 4568, 9568, 4482, 9959, 7339, 7204, 7273, 7132, 7851, 7814, 7843, 7544, 10254, 6036, 4892, 4434, 4754, 10422, 6483, 10035, 10166, 10131, 6754, 7597, 4563, 10319, 6569, 10407, 6753, 9825, 4484, 4581, 4537), Clusters = c(424, 312, 384, 80, 80, 80, 88, 88, 88, 80, 392, 36, 120, 172, 384, 36, 120, 280, 80, 80, 80, 80, 376, 80, 36, 100, 180, 175, 172, 798, 36, 270, 80, 104, 112, 392, 105, 125, 36, 76, 84, 170, 30, 88, 36, 80, 92, 92, 92, 92, 30, 120, 80, 80, 36, 54, 36, 80, 470, 80, 392, 80, 168, 36, 80, 384, 36, 80, 672, 80, 172, 240, 240, 240, 120, 256, 280, 280, 140, 276, 112, 88, 36, 92, 500, 112, 172, 240, 172, 116, 175, 36, 195, 120, 240, 116, 172, 84, 36, 80), Perfs = c(2120, 1372.8, 1689.6, 480, 480, 480, 528, 528, 528, 480, 1724.8, 576, 720, 1032, 1689.6, 576, 720, 1232, 480, 480, 480, 480, 1654.4, 480, 576, 700, 1080, 1225, 1032, 2154.6, 576, 1701, 560, 624, 672, 1136.8, 735, 800, 576, 456, 504, 1224, 420, 528, 576, 480, 552, 552, 552, 552, 480, 720, 480, 480, 576, 864, 648, 480, 1880, 480, 1136.8, 480, 453.6, 576, 480, 1689.6, 576, 560, 1814.4, 480, 1032, 1512, 1512, 1512, 720, 1126.4, 812, 812, 840, 1738.8, 672, 528, 576, 579.6, 2000, 672, 1032, 1680, 1118, 696, 1225, 576, 1365, 720, 1680, 696, 1083.6, 504, 576, 480), numberofStages = c(53, 39, 48, 20, 20, 20, 22, 22, 22, 20, 49, 12, 30, 43, 48, 12, 30, 35, 20, 20, 20, 20, 47, 20, 12, 20, 45, 35, 43, 57, 12, 45, 16, 26, 28, 28, 21, 25, 12, 19, 21, 34, 10, 22, 12, 20, 23, 23, 23, 23, 10, 30, 20, 20, 12, 18, 9, 20, 47, 20, 28, 20, 12, 12, 20, 48, 12, 16, 48, 20, 43, 40, 40, 40, 30, 32, 20, 20, 35, 46, 28, 22, 12, 23, 50, 28, 43, 48, 43, 29, 35, 12, 39, 30, 48, 29, 43, 21, 12, 20), StageLength = c(204, 193, 209, 217, 217, 216, 217, 217, 217, 219, 209, 395, 277, 229, 211, 341, 241, 209, 225, 225, 236, 220, 204, 219, 377, 216, 220, 222, 209, 198, 383, 210, 286, 213, 213, 368, 216, 285, 380, 219, 217, 306, 381, 216, 374, 225, 212, 212, 212, 212, 398, 156, 224, 217, 404, 387, 400, 204, 207, 211, 349, 227, 394, 353, 212, 214, 383, 286, 198, 225, 233, 184, 181, 181, 236, 248, 394, 394, 216, 222, 216, 220, 370, 204, 207, 233, 233, 212, 236, 233, 216, 380, 272, 219, 216, 233, 228, 213, 383, 226), PerfsperCluster = c(5, 4.4, 4.4, 6, 6, 6, 6, 6, 6, 6, 4.4, 16, 6, 6, 4.4, 16, 6, 4.4, 6, 6, 6, 6, 4.4, 6, 16, 7, 6, 7, 6, 2.7, 16, 6.3, 7, 6, 6, 2.9, 7, 6.4, 16, 6, 6, 7.2, 14, 6, 16, 6, 6, 6, 6, 6, 16, 6, 6, 6, 16, 16, 18, 6, 4, 6, 2.9, 6, 2.7, 16, 6, 4.4, 16, 7, 2.7, 6, 6, 6.3, 6.3, 6.3, 6, 4.4, 2.9, 2.9, 6, 6.3, 6, 6, 16, 6.3, 4, 6, 6, 7, 6.5, 6, 7, 16, 7, 6, 7, 6, 6.3, 6, 16, 6), ClustersperStage = c(8, 8, 8, 4, 4, 4, 4, 4, 4, 4, 8, 3, 4, 4, 8, 3, 4, 8, 4, 4, 4, 4, 8, 4, 3, 5, 4, 5, 4, 14, 3, 6, 5, 4, 4, 14, 5, 5, 3, 4, 4, 5, 3, 4, 3, 4, 4, 4, 4, 4, 3, 4, 4, 4, 3, 3, 4, 4, 10, 4, 14, 4, 14, 3, 4, 8, 3, 5, 14, 4, 4, 6, 6, 6, 4, 8, 14, 14, 4, 6, 4, 4, 3, 4, 10, 4, 4, 5, 4, 4, 5, 3, 5, 4, 5, 4, 4, 4, 3, 4), AvgRate = c(78.2, 69.4, 70.1, 38.85, 64.15, 51.4, 63.35, 53.9, 65.25, 55.6, 71.7, 65.7, 71.5, 66.1, 70.1, 68.65, 54.7, 71.9, 63, 59, 55.15, 61.65, 61.8, 61.3, 69.85, 69.8, 70, 68.3, 69.3, 78.3, 78.45, 69.6, 69.65, 65.25, 62.7, 78, 65.6, 70, 69.75, 58.9, 68.7, 69.5, 69.1, 38, 65.15, 62.6, 59, 57.8, 57, 58, 69.95, 54.85, 62.6, 72, 69.35, 66.9, 56.4, 49.55, 69.1, 68.85, 77.65, 67.05, 79.95, 68.4, 50.2, 68.8, 62.2, 67.6, 79.2, 54.95, 54.9, 68.35, 69.25, 68.9, 67.95, 70.25, 70.25, 78.5, 60.5, 64.9, 55.5, 61.1, 70.4, 68.8, 68.55, 67.15, 68.5, 69.6, 68, 66, 69.9, 69.95, 69.8, 58, 70.3, 64.2, 67.9, 61.6, 66.75, 60), LinearGel = c(182960, 22679, 0, 1705708, 1431430, 4876145, 792667, 3171196, 143789, 1529525, 0, 2317752, 937178, 1749577, 0, 2225649, 1469464, 0, 1184725, 969548, 1330691, 1663617, 0, 3652866, 323375, 0, 0, 64759, 0, 0, 2067358, 0, 86421, 5128117, 1716235, 0, 0, 718739, 2285988, 4676260, 0, 506961, 318590, 4047025, 2729357, 573492, 4328930, 4754471, 4440845, 4493551, 319107, 1944047, 811607, 0, 293927, 4215908, 0, 1109161, 0, 4964487, 0, 958048, 0, 2345143, 1531299, 0, 309869, 132721, 0, 1912405, 5035254, 47651, 0, 484803, 372681, 0, 0, 0, 7962213, 0, 3005433, 1220022, 2871871, 0, 0, 476720, 27745, 0, 756072, 913494, 0, 307321, 0, 4084651, 0, 1848751, 2384976, 3913542, 2610345, 1346381), HydrochloricAcid = c(0, 0, 0, 15500, 10000, 10500, 11000, 11000, 11000, 10000, 4000, 6010, 15000, 21500, 0, 6000, 15000, 3000, 10000, 10000, 10000, 10000, 50000, 10000, 12371, 10000, 22000, 17500, 21500, 0, 6000, 22500, 8000, 13000, 14000, 0, 10497, 12534, 6017, 10500, 10500, 17000, 10330, 11000, 6000, 10000, 11500, 11500, 11500, 11500, 10000, 15000, 9865, 10000, 12192, 8980, 9000, 10000, 0, 10000, 0, 10000, 0, 6000, 10000, 24000, 13212, 8000, 0, 10000, 21500, 20000, 19737, 20000, 15000, 0, 0, 0, 18500, 23000, 14000, 11000, 6000, 11500, 0, 14000, 21500, 24000, 21500, 14500, 17500, 12439, 19500, 15000, 24000, 15000, 21500, 10500, 6006, 10000), MudAcid = c(0, 0, 0, 60000, 40000, 42000, 44000, 44000, 44000, 40000, 0, 23987, 60000, 86000, 0, 24000, 60000, 0, 40000, 40000, 40000, 40000, 0, 40000, 48470, 40000, 88000, 70000, 86000, 0, 24000, 90000, 32000, 52000, 56000, 0, 42004, 50000, 24071, 40000, 42000, 68000, 49965, 44000, 24000, 40000, 46000, 46000, 46000, 46000, 40000, 60000, 38500, 40000, 48262, 35996, 35886, 40000, 0, 40000, 0, 40000, 0, 22500, 40000, 96000, 49023, 32000, 0, 40000, 86000, 80000, 79272, 80000, 60000, 0, 0, 0, 74000, 92000, 56000, 44000, 24000, 46000, 0, 56000, 86000, 96000, 86000, 58000, 70000, 48442, 78000, 60000, 96000, 60000, 86000, 42000, 24000, 40000 ), XLBorate = c(1668520, 31471, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2740512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2439778, 0, 0, 0, 0, 0, 0, 0, 2107204, 0, 0, 0, 2005797, 0, 1132512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2822701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2695897, 0, 0, 0, 0, 0, 0, 0, 0), PropLbs = c(25172117, 18809963, 23971758, 3370443, 5827682, 5277973, 6416735, 5029850, 6605794, 5672259, 24529832, 3785953, 8505605, 12051190, 23613720, 3500327, 8653443, 17167383, 5765342, 5722022, 5673210, 5709364, 18606143, 7180664, 4608034, 7316701, 12728718, 12321930, 12285970, 28539969, 3610840, 19192487, 5785397, 8161255, 7865629, 23979377, 7409244, 8901103, 3722446, 4689942, 6026124, 12023712, 3627715, 6586486, 3364644, 5555779, 6686801, 7118210, 6371647, 6729013, 3824679, 8789536, 5811289, 5779801, 4683931, 6810569, 2360937, 5467161, 23611847, 6251263, 24074779, 6009005, 9602564, 3891718, 5725058, 22882143, 4610225, 5675611, 23927864, 5777715, 12313418, 16109058, 17181343, 16583468, 8575407, 16455697, 15736471, 15963919, 9084234, 19537326, 7466984, 6294420, 4550810, 6522039, 24840315, 8101738, 12051226, 16896067, 11812251, 8329858, 12656552, 4233726, 13984849, 8650267, 16929558, 8270372, 12594448, 6534640, 3837364, 5814273), PropLbsperFt = c(2398, 1980, 2390, 724, 1429, 1435, 1419, 1321, 1424, 1307, 2398, 799, 1039, 1242, 2334, 939, 1207, 2374, 1279, 1280, 1221, 1309, 1958, 1762, 1020, 1691, 1312, 1616, 1374, 2528, 817, 2025, 1268, 1465, 1350, 2335, 1668, 1257, 818, 1396, 1324, 1180, 946, 1468, 842, 1275, 1489, 1497, 1402, 1418, 958, 1878, 1297, 1328, 977, 974, 622, 1411, 2418, 1480, 2473, 1281, 2032, 925, 1361, 2236, 1009, 1259, 2527, 1284, 1238, 2315, 2370, 2351, 1208, 2088, 2038, 2030, 1431, 1922, 1336, 1309, 1030, 1388, 2416, 1241, 1218, 1654, 1216, 1234, 1657, 931, 1300, 1330, 1648, 1246, 1284, 1480, 845, 1281), Prop LbsperCluster = c(61147, 63919, 62443, 39769, 77641, 77499, 76997, 73352, 77375, 71575, 62580, 105167, 71967, 71570, 61534, 107136, 72771, 61903, 71966, 72013, 72052, 71984, 49952, 96755, 127606, 72997, 72384, 71622, 71816, 35739, 104563, 71097, 72075, 78042, 71888, 61463, 71836, 71639, 103580, 76243, 71844, 72103, 119706, 79273, 104923, 71716, 78922, 79149, 75684, 75173, 126788, 73236, 72451, 72092, 131554, 125959, 62171, 71906, 50211, 78116, 61549, 72348, 57170, 108689, 72119, 59637, 128901, 72116, 35746, 72251, 72094, 71139, 71428, 71386, 72128, 64379, 57283, 57153, 77295, 71181, 72121, 72034, 126636, 70933, 50084, 72270, 70934, 70402, 71667, 71852, 71873, 117970, 70493, 72924, 71417, 72600, 73142, 79031, 107243, 72769), Prop LbsperPerf = c(12281, 13794, 14273, 6628, 12940, 12917, 12833, 12225, 12896, 11929, 14304, 6573, 11994, 11928, 14065, 6696, 12128, 14149, 11994, 12002, 12009, 11997, 11418, 16126, 7975, 10428, 12064, 10232, 11969, 13167, 6535, 11226, 10296, 13007, 11981, 21512, 10262, 11194, 6474, 12707, 11974, 10014, 8550, 13212, 6558, 11953, 13154, 13191, 12614, 12529, 7924, 12206, 12075, 12015, 8222, 7872, 3454, 11984, 12553, 13019, 21542, 12054, 21063, 6793, 12020, 13631, 8056, 10302, 13158, 12042, 12016, 11232, 11278, 11271, 12021, 14715, 20049, 20004, 12883, 11239, 12020, 12006, 7915, 11349, 12521, 12045, 11822, 10057, 11041, 11975, 10268, 7373, 10112, 12154, 10202, 12100, 11703, 13172, 6703, 12128 ), AvgPressure = c(7241, 5738, 5684.5, 6608, 6222.5, 6852, 6589, 6844, 6418.5, 6326.5, 6111, 6181, 7217.5, 7607, 6540, 5982, 6014.5, 5516, 5995.5, 6285.5, 5911, 5917, 8571, 6553.5, 6163.5, 6374, 6253, 6515, 7269, 7800, 5147.5, 6832, 6243.5, 6835.5, 6627, 7138.5, 6168, 5608, 5417.5, 6989, 5612, 7015.5, 5957.5, 7320.5, 7962, 6372, 6530, 6670, 6733, 6670, 5490, 5673, 5678.15, 5878.5, 6300, 6492, 5312, 6214, 6867, 6940, 7299.5, 6388, 5776, 6444.5, 6031.5, 7376.5, 5681, 6497.5, 6780, 4760, 6436, 5733, 5361.5, 5396.5, 5937, 7171, 7671.5, 7325.5, 6782, 7807, 7015, 6965, 6041.5, 7544, 7706.5, 6086.5, 6662, 5859.5, 6750, 6928, 6348, 5446.5, 6532, 6797.5, 5445.5, 7026, 7669, 6506, 5834.5, 4761.5), fluidgal = c(19932486, 16069158, 18762828, 6079836, 6837012, 8567328, 8052282, 7131684, 7980672, 4764270, 18892146, 4204368, 8650320, 15571962, 18607302, 3874752, 10604412, 13416438, 6929706, 6915972, 6813534, 6997704, 15407574, 6976578, 4580646, 7656768, 15475740, 13596786, 14709114, 22177722, 3888066, 20816460, 5902344, 9247770, 9801120, 18590292, 7905072, 10119564, 4022340, 6659688, 6473418, 13213326, 3649716, 7660968, 4466742, 7326144, 7659456, 7929558, 7733586, 7890540, 3868410, 10675854, 7011858, 6980820, 5270202, 7248612, 2112810, 5043990, 18284616, 6941844, 18308094, 5926032, 7435344, 4144392, 4853982, 18565344, 4902114, 5864544, 19068504, 5687052, 12192558, 18393480, 18129174, 18347658, 10518144, 12843852, 12443760, 12442878, 13484142, 21350238, 8186010, 6457836, 4639152, 6851964, 19312566, 9728292, 13166370, 17934798, 14627130, 8596098, 13539582, 4564980, 14618898, 10912524, 17869782, 9023574, 12863046, 7271208, 4447758, 6888336)), row.names = c(NA, -100L), class = c("tbl_df", "tbl", "data.frame"))

Environment

History

Files

Plots

Packages

Help

Tutorial

Viewer

[image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image]

[image]Go to project directory...

Cloud project data

|||Ascending sort

Name|Size||
| --- | --- |

[image] ..
[image] model_summary.txt 1.8 KB
[image] Yield_data.csv 5.1 KB
[image] variables.xlsx 37.7 KB

[image] correlation between ip and production variables.Rmd [image]

[image] Untitled1 * [image]

[image] variables1 [image]

[image] variables [image]

[image] correlation exercise template.Rmd [image]

[image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] Knit [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] Run [image] [image] [image] [image]

Source Visual [image] Outline

|38:8|[image]|Chunk 5

[image]||R Markdown

[image]|
| --- | --- |

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43


```{r}

# Spearman correlation between 2 variables

cor(variables$Perfs, variables$Clusters,

method = "spearman")


# correlation for all variables

cor(dat)

[image][image][image]

[image][image][image]

[image][image][image]

[image][image][image]

I could not get your dput () output to work and I cannot see why. Everything looks fine. Maybe an errant invisible character? Anyway I extracted what I think are all the variables and created a new tibble.
In any case, the problem with

cor(variables)

is that WellName is a character variable. You need to drop it before running the correlation.

My "new" version of your dataset looks like this

dat1  <- tibble(WellName, AvgPressure, AvgRate, Clusters, ClustersperStage, CompletedFeet, fluidgal,
            HydrochloricAcid, InitialReservoirPressure, IP180DayBOE, LinearGel,
            MudAcid, numberofStages, Perfs, PerfsperCluster, PropLbs, PropLbsperCluster,
            PropLbsperFt, StageLength, XLBorate)

Therefore we can do this

round(cor(dat1[,-1]), 2)

where I am using indexing to drop the first column of dat1 (i.e. WellName) from the analysis. All the other variables in dat1 are numeric so we were good to go.

It is always a good idea to do

str(dat1)  # base R 

#or

glimpse(dat1)

As a check that R is giving you the data types you think it is.

Anyway here is what I have extracted from your data set.

structure(list(WellName = c("AFFIRMED 23 STATE UNIT 2H", "AFFIRMED 23 STATE UNIT 1H", 
"AMERICAN PHAROAH 43 STATE UNIT 1H", "ANACONDA STATE 55-2 7H", 
"ANACONDA STATE 55-2 6H", "ANACONDA STATE 55-2 5H", "ANACONDA STATE 55-2 4H", 
"ANACONDA STATE 55-2 3H", "ANACONDA STATE 55-2 2H", "ANACONDA STATE 55-2 1H", 
"ANIMAL KINGDOM 44 A 3H", "ANIMAL KINGDOM 44 FEE 2H", "APOLLO 48 UNIT 2H", 
"ARISTIDES 2 UNIT 1H", "ARVINE 28A-2H", "ARVINE 28-1H (R/E)", 
"ASSAULT 14 UNIT 2H (FKA 1H)", "BADEN BADEN 7 STATE UNIT 1H", 
"BARBARO 23 UNIT 4H", "BARBARO 23 UNIT 3H", "BARBARO 23 UNIT 2H", 
"BARBARO 23 UNIT 1H", "BARNES DE ESTATE 3H", "BEAVERHEAD STATE 2-24 UNIT 1H", 
"BIG BROWN 30 FEE 1H", "BIG SKY STATE 55-16 1H R/E", "BIG TIMBER STATE 57-25 UNIT 1H", 
"BIGFOOT C21-6 UNIT 1H", "BIGHORN NORTH UNIT 1-31 1H", "BIGHORN SOUTH UNIT 1-31 2H", 
"BLACK GOLD 26 FEE 1H", "BLACKTAIL 1-34 UNIT 1H", "BOULDER STATE 57-32 1H", 
"BRIDGER 1-36 2H", "BRIDGER 1-36 1H", "BROKERS TIP 24 STATE UNIT 1H", 
"CABINET STATE 55-2 UNIT 1H", "CALIFORNIA CHROME 39 STATE UNIT 1H", 
"CANNONADE 4 FEE 1XH", "CASTLE 57-27 1H", "CATHEDRAL STATE 57-6 UNIT 2H", 
"CAVALCADE 25 UNIT 1H", "CHOSA DRAW 27 FEDERAL 3H", "CHUPACABRA 51 STATE 2H", 
"CITATION 32 FEE 1H", "CITATION 32 FEE 3H", "CLEVELAND STATE 57-23 1H", 
"CLEVELAND STATE 57-23 2H", "CLEVELAND STATE 57-23 3H", "CLEVELAND STATE 57-23 4H", 
"COTTONWOOD HILLS 32 STATE 1H", "COUNT FLEET 48 STATE 2H", "COUNT TURF 38 STATE 1H", 
"COURTHOUSE 57-27 1H", "DARK STAR 21 FEE 1", "DAY STAR 20 UNIT 1H", 
"DUST COMMANDER 26 STATE 1", "EIGHTEENMILE 56-18 1H", "ELECTRIC STATE 57-33 UNIT 1H", 
"ELKHORN 2-17 1H", "ELWOOD 29 UNIT 2H", "FERDINAND 27 UNIT 1H", 
"FLATHEAD 2-15 2H", "FLATHEAD 2-15 1H", "FLATHEAD 2-15 4H", "FLYING EBONY 19 STATE A 5H", 
"FOOLISH PLEASURE 6 FEE 2H", "FORWARD PASS 25 UNIT 2H", "FUNNY CIDE 32 A-2H", 
"FUNNY CIDE 32 FEE 1H", "GALLANT FOX 37 UNIT 1H", "GATO DEL SOL 34 UNIT 4H", 
"GATO DEL SOL 34 UNIT 3H", "GATO DEL SOL 34 UNIT 2H", "GATO DEL SOL 34 UNIT 1H", 
"GREATHOUSE C21-6 UNIT 4H", "GREATHOUSE C21-6 UNIT 3H", "GREATHOUSE C21-6 UNIT 2H", 
"GREATHOUSE C21-6 UNIT 1H", "GREENHORN NORTH UNIT 1-35 3H", "GREENHORN SOUTH UNIT 1-35 1H", 
"GREENHORN SOUTH UNIT 1-35 2H", "GRINDSTONE 2 FEE 1H", "HALLERTAU 5 FEDERAL COM 3H", 
"HARDSCRABBLE STATE 57-34 UNIT 1H", "HAYDUKE 34 FEDERAL COM 3H", 
"HINDOO 2 STATE UNIT 1H", "HIS EMINENCE 27 UNIT 1H", "HOOP JR 9 UNIT 1H", 
"HORNSBY 35 FEDERAL 3H", "HUCKLEBERRY C21-9 UNIT 1H", "JET PILOT 24 FEE 1H", 
"JET PILOT 24 UNIT A 5H", "JUDITH 2-16 UNIT 1H", "KINGMAN 45 STATE UNIT 2H", 
"KLEIN 33 FEDERAL COM 6H", "LEONATUS 11 UNIT 1H", "LIVINGSTON 2-12 1H", 
"LOOKOUT 18 FEE 1H", "LORD MURPHY 10 STATE 1H"), AvgPressure = c(7241, 
5738, 5684.5, 6608, 6222.5, 6852, 6589, 6844, 6418.5, 6326.5, 
6111, 6181, 7217.5, 7607, 6540, 5982, 6014.5, 5516, 5995.5, 6285.5, 
5911, 5917, 8571, 6553.5, 6163.5, 6374, 6253, 6515, 7269, 7800, 
5147.5, 6832, 6243.5, 6835.5, 6627, 7138.5, 6168, 5608, 5417.5, 
6989, 5612, 7015.5, 5957.5, 7320.5, 7962, 6372, 6530, 6670, 6733, 
6670, 5490, 5673, 5678.15, 5878.5, 6300, 6492, 5312, 6214, 6867, 
6940, 7299.5, 6388, 5776, 6444.5, 6031.5, 7376.5, 5681, 6497.5, 
6780, 4760, 6436, 5733, 5361.5, 5396.5, 5937, 7171, 7671.5, 7325.5, 
6782, 7807, 7015, 6965, 6041.5, 7544, 7706.5, 6086.5, 6662, 5859.5, 
6750, 6928, 6348, 5446.5, 6532, 6797.5, 5445.5, 7026, 7669, 6506, 
5834.5, 4761.5), AvgRate = c(78.2, 69.4, 70.1, 38.85, 64.15, 
51.4, 63.35, 53.9, 65.25, 55.6, 71.7, 65.7, 71.5, 66.1, 70.1, 
68.65, 54.7, 71.9, 63, 59, 55.15, 61.65, 61.8, 61.3, 69.85, 69.8, 
70, 68.3, 69.3, 78.3, 78.45, 69.6, 69.65, 65.25, 62.7, 78, 65.6, 
70, 69.75, 58.9, 68.7, 69.5, 69.1, 38, 65.15, 62.6, 59, 57.8, 
57, 58, 69.95, 54.85, 62.6, 72, 69.35, 66.9, 56.4, 49.55, 69.1, 
68.85, 77.65, 67.05, 79.95, 68.4, 50.2, 68.8, 62.2, 67.6, 79.2, 
54.95, 54.9, 68.35, 69.25, 68.9, 67.95, 70.25, 70.25, 78.5, 60.5, 
64.9, 55.5, 61.1, 70.4, 68.8, 68.55, 67.15, 68.5, 69.6, 68, 66, 
69.9, 69.95, 69.8, 58, 70.3, 64.2, 67.9, 61.6, 66.75, 60), Clusters = c(424, 
312, 384, 80, 80, 80, 88, 88, 88, 80, 392, 36, 120, 172, 384, 
36, 120, 280, 80, 80, 80, 80, 376, 80, 36, 100, 180, 175, 172, 
798, 36, 270, 80, 104, 112, 392, 105, 125, 36, 76, 84, 170, 30, 
88, 36, 80, 92, 92, 92, 92, 30, 120, 80, 80, 36, 54, 36, 80, 
470, 80, 392, 80, 168, 36, 80, 384, 36, 80, 672, 80, 172, 240, 
240, 240, 120, 256, 280, 280, 140, 276, 112, 88, 36, 92, 500, 
112, 172, 240, 172, 116, 175, 36, 195, 120, 240, 116, 172, 84, 
36, 80), ClustersperStage = c(8, 8, 8, 4, 4, 4, 4, 4, 4, 4, 8, 
3, 4, 4, 8, 3, 4, 8, 4, 4, 4, 4, 8, 4, 3, 5, 4, 5, 4, 14, 3, 
6, 5, 4, 4, 14, 5, 5, 3, 4, 4, 5, 3, 4, 3, 4, 4, 4, 4, 4, 3, 
4, 4, 4, 3, 3, 4, 4, 10, 4, 14, 4, 14, 3, 4, 8, 3, 5, 14, 4, 
4, 6, 6, 6, 4, 8, 14, 14, 4, 6, 4, 4, 3, 4, 10, 4, 4, 5, 4, 4, 
5, 3, 5, 4, 5, 4, 4, 4, 3, 4), CompletedFeet = c(10092, 9207, 
10015, 4348, 4329, 4310, 4727, 4740, 4785, 4358, 10084, 4734, 
8318, 9892, 10124, 4094, 7245, 7373, 4510, 4517, 4686, 4420, 
9637, 4345, 4509, 4301, 9938, 7673, 9013, 11208, 4605, 9494, 
4574, 5571, 5990, 10301, 4522, 7139, 4567, 4151, 4552, 10336, 
3777, 4739, 4497, 4474, 4855, 4868, 4895, 4915, 3973, 4624, 4443, 
4359, 4848, 7190, 3601, 4033, 9799, 4223, 9758, 4521, 4729, 4143, 
4268, 10094, 4597, 4568, 9568, 4482, 9959, 7339, 7204, 7273, 
7132, 7851, 7814, 7843, 7544, 10254, 6036, 4892, 4434, 4754, 
10422, 6483, 10035, 10166, 10131, 6754, 7597, 4563, 10319, 6569, 
10407, 6753, 9825, 4484, 4581, 4537), fluidgal = c(19932486, 
16069158, 18762828, 6079836, 6837012, 8567328, 8052282, 7131684, 
7980672, 4764270, 18892146, 4204368, 8650320, 15571962, 18607302, 
3874752, 10604412, 13416438, 6929706, 6915972, 6813534, 6997704, 
15407574, 6976578, 4580646, 7656768, 15475740, 13596786, 14709114, 
22177722, 3888066, 20816460, 5902344, 9247770, 9801120, 18590292, 
7905072, 10119564, 4022340, 6659688, 6473418, 13213326, 3649716, 
7660968, 4466742, 7326144, 7659456, 7929558, 7733586, 7890540, 
3868410, 10675854, 7011858, 6980820, 5270202, 7248612, 2112810, 
5043990, 18284616, 6941844, 18308094, 5926032, 7435344, 4144392, 
4853982, 18565344, 4902114, 5864544, 19068504, 5687052, 12192558, 
18393480, 18129174, 18347658, 10518144, 12843852, 12443760, 12442878, 
13484142, 21350238, 8186010, 6457836, 4639152, 6851964, 19312566, 
9728292, 13166370, 17934798, 14627130, 8596098, 13539582, 4564980, 
14618898, 10912524, 17869782, 9023574, 12863046, 7271208, 4447758, 
6888336), HydrochloricAcid = c(0, 0, 0, 15500, 10000, 10500, 
11000, 11000, 11000, 10000, 4000, 6010, 15000, 21500, 0, 6000, 
15000, 3000, 10000, 10000, 10000, 10000, 50000, 10000, 12371, 
10000, 22000, 17500, 21500, 0, 6000, 22500, 8000, 13000, 14000, 
0, 10497, 12534, 6017, 10500, 10500, 17000, 10330, 11000, 6000, 
10000, 11500, 11500, 11500, 11500, 10000, 15000, 9865, 10000, 
12192, 8980, 9000, 10000, 0, 10000, 0, 10000, 0, 6000, 10000, 
24000, 13212, 8000, 0, 10000, 21500, 20000, 19737, 20000, 15000, 
0, 0, 0, 18500, 23000, 14000, 11000, 6000, 11500, 0, 14000, 21500, 
24000, 21500, 14500, 17500, 12439, 19500, 15000, 24000, 15000, 
21500, 10500, 6006, 10000), InitialReservoirPressure = c(3900, 
4300, 4100, 7700, 7347, 7635, 7452, 7489, 7143, 8096, 5250, 6473, 
6235, 6955, 4600, 6745, 7594, 3900, 7056, 7061, 6805, 6851, 6310, 
7886, 6338, 7042, 6625, 7465, 8211, 7641, 5335, 7581, 6987, 8151, 
8429, 4500, 7826, 5800, 5385, 7683, 6606, 5749, 6683, 5755, 6500, 
6750, 7286, 7430, 7228, 7081, 6818, 6311, 6273, 7420, 6583, 6422, 
6190, 7719, 6913, 8334, 4800, 6575, 7692, 8314, 8188, 6718, 6275, 
7250, 4750, 5000, 7050, 4600, 4700, 4600, 5347, 6484, 7411, 6364, 
7507, 8032, 8234, 8177, 6591, 8900, 7189, 6705, 6237, 5400, 6600, 
7257, 6561, 5592, 6766, 8068, 4600, 7305, 7079, 8143, 6729, 5200
), IP180DayBOE = c(1134.30333333333, 1060.66666666667, 1373, 
252.666666666667, 381.833333333333, 301.833333333333, 337.166666666667, 
294.166666666667, 342.666666666667, 296.666666666667, 1092.83333333333, 
534.5, 1050.83333333333, 1101.33333333333, 791.287, 336.5, 980.333333333333, 
983.333333333333, 514.666666666667, 455, 440.333333333333, 444.5, 
175.235305555556, 311.666666666667, 370.166666666667, 371, 900.5, 
950.666666666667, 720.666666666667, 811.333333333333, 366.833333333333, 
660.5, 599.166666666667, 483.333333333333, 494.5, 862.582416666667, 
637.5, 656.666666666667, 285.833333333333, 493.333333333333, 
472.166666666667, 650.333333333333, 361.666666666667, 115.166666666667, 
434, 653, 336.166666666667, 351.833333333333, 359, 392.333333333333, 
284.666666666667, 761, 648, 535.666666666667, 539.833333333333, 
661.666666666667, 234.666666666667, 342, 798.666666666667, 310.5, 
987.030095238095, 470.333333333333, 542.5, 200.5, 249.666666666667, 
1563, 519.833333333333, 526.333333333333, 963, 405.166666666667, 
1308.33333333333, 793, 554.666666666667, 685.333333333333, 607.333333333333, 
587, 744.5, 535.666666666667, 666.666666666667, 792.666666666667, 
431.166666666667, 370.333333333333, 342.333333333333, 447.666666666667, 
951, 734.166666666667, 1101.16666666667, 875.666666666667, 1344.66666666667, 
612, 496.333333333333, 330.333333333333, 1093.16666666667, 334.833333333333, 
734.5, 852.166666666667, 1136.33333333333, 328.333333333333, 
339.833333333333, 518.333333333333), LinearGel = c(182960, 22679, 
0, 1705708, 1431430, 4876145, 792667, 3171196, 143789, 1529525, 
0, 2317752, 937178, 1749577, 0, 2225649, 1469464, 0, 1184725, 
969548, 1330691, 1663617, 0, 3652866, 323375, 0, 0, 64759, 0, 
0, 2067358, 0, 86421, 5128117, 1716235, 0, 0, 718739, 2285988, 
4676260, 0, 506961, 318590, 4047025, 2729357, 573492, 4328930, 
4754471, 4440845, 4493551, 319107, 1944047, 811607, 0, 293927, 
4215908, 0, 1109161, 0, 4964487, 0, 958048, 0, 2345143, 1531299, 
0, 309869, 132721, 0, 1912405, 5035254, 47651, 0, 484803, 372681, 
0, 0, 0, 7962213, 0, 3005433, 1220022, 2871871, 0, 0, 476720, 
27745, 0, 756072, 913494, 0, 307321, 0, 4084651, 0, 1848751, 
2384976, 3913542, 2610345, 1346381), MudAcid = c(0, 0, 0, 60000, 
40000, 42000, 44000, 44000, 44000, 40000, 0, 23987, 60000, 86000, 
0, 24000, 60000, 0, 40000, 40000, 40000, 40000, 0, 40000, 48470, 
40000, 88000, 70000, 86000, 0, 24000, 90000, 32000, 52000, 56000, 
0, 42004, 50000, 24071, 40000, 42000, 68000, 49965, 44000, 24000, 
40000, 46000, 46000, 46000, 46000, 40000, 60000, 38500, 40000, 
48262, 35996, 35886, 40000, 0, 40000, 0, 40000, 0, 22500, 40000, 
96000, 49023, 32000, 0, 40000, 86000, 80000, 79272, 80000, 60000, 
0, 0, 0, 74000, 92000, 56000, 44000, 24000, 46000, 0, 56000, 
86000, 96000, 86000, 58000, 70000, 48442, 78000, 60000, 96000, 
60000, 86000, 42000, 24000, 40000), numberofStages = c(53, 39, 
48, 20, 20, 20, 22, 22, 22, 20, 49, 12, 30, 43, 48, 12, 30, 35, 
20, 20, 20, 20, 47, 20, 12, 20, 45, 35, 43, 57, 12, 45, 16, 26, 
28, 28, 21, 25, 12, 19, 21, 34, 10, 22, 12, 20, 23, 23, 23, 23, 
10, 30, 20, 20, 12, 18, 9, 20, 47, 20, 28, 20, 12, 12, 20, 48, 
12, 16, 48, 20, 43, 40, 40, 40, 30, 32, 20, 20, 35, 46, 28, 22, 
12, 23, 50, 28, 43, 48, 43, 29, 35, 12, 39, 30, 48, 29, 43, 21, 
12, 20), Perfs = c(2120, 1372.8, 1689.6, 480, 480, 480, 528, 
528, 528, 480, 1724.8, 576, 720, 1032, 1689.6, 576, 720, 1232, 
480, 480, 480, 480, 1654.4, 480, 576, 700, 1080, 1225, 1032, 
2154.6, 576, 1701, 560, 624, 672, 1136.8, 735, 800, 576, 456, 
504, 1224, 420, 528, 576, 480, 552, 552, 552, 552, 480, 720, 
480, 480, 576, 864, 648, 480, 1880, 480, 1136.8, 480, 453.6, 
576, 480, 1689.6, 576, 560, 1814.4, 480, 1032, 1512, 1512, 1512, 
720, 1126.4, 812, 812, 840, 1738.8, 672, 528, 576, 579.6, 2000, 
672, 1032, 1680, 1118, 696, 1225, 576, 1365, 720, 1680, 696, 
1083.6, 504, 576, 480), PerfsperCluster = c(5, 4.4, 4.4, 6, 6, 
6, 6, 6, 6, 6, 4.4, 16, 6, 6, 4.4, 16, 6, 4.4, 6, 6, 6, 6, 4.4, 
6, 16, 7, 6, 7, 6, 2.7, 16, 6.3, 7, 6, 6, 2.9, 7, 6.4, 16, 6, 
6, 7.2, 14, 6, 16, 6, 6, 6, 6, 6, 16, 6, 6, 6, 16, 16, 18, 6, 
4, 6, 2.9, 6, 2.7, 16, 6, 4.4, 16, 7, 2.7, 6, 6, 6.3, 6.3, 6.3, 
6, 4.4, 2.9, 2.9, 6, 6.3, 6, 6, 16, 6.3, 4, 6, 6, 7, 6.5, 6, 
7, 16, 7, 6, 7, 6, 6.3, 6, 16, 6), PropLbs = c(25172117, 18809963, 
23971758, 3370443, 5827682, 5277973, 6416735, 5029850, 6605794, 
5672259, 24529832, 3785953, 8505605, 12051190, 23613720, 3500327, 
8653443, 17167383, 5765342, 5722022, 5673210, 5709364, 18606143, 
7180664, 4608034, 7316701, 12728718, 12321930, 12285970, 28539969, 
3610840, 19192487, 5785397, 8161255, 7865629, 23979377, 7409244, 
8901103, 3722446, 4689942, 6026124, 12023712, 3627715, 6586486, 
3364644, 5555779, 6686801, 7118210, 6371647, 6729013, 3824679, 
8789536, 5811289, 5779801, 4683931, 6810569, 2360937, 5467161, 
23611847, 6251263, 24074779, 6009005, 9602564, 3891718, 5725058, 
22882143, 4610225, 5675611, 23927864, 5777715, 12313418, 16109058, 
17181343, 16583468, 8575407, 16455697, 15736471, 15963919, 9084234, 
19537326, 7466984, 6294420, 4550810, 6522039, 24840315, 8101738, 
12051226, 16896067, 11812251, 8329858, 12656552, 4233726, 13984849, 
8650267, 16929558, 8270372, 12594448, 6534640, 3837364, 5814273
), PropLbsperCluster = c(61147, 63919, 62443, 39769, 77641, 77499, 
76997, 73352, 77375, 71575, 62580, 105167, 71967, 71570, 61534, 
107136, 72771, 61903, 71966, 72013, 72052, 71984, 49952, 96755, 
127606, 72997, 72384, 71622, 71816, 35739, 104563, 71097, 72075, 
78042, 71888, 61463, 71836, 71639, 103580, 76243, 71844, 72103, 
119706, 79273, 104923, 71716, 78922, 79149, 75684, 75173, 126788, 
73236, 72451, 72092, 131554, 125959, 62171, 71906, 50211, 78116, 
61549, 72348, 57170, 108689, 72119, 59637, 128901, 72116, 35746, 
72251, 72094, 71139, 71428, 71386, 72128, 64379, 57283, 57153, 
77295, 71181, 72121, 72034, 126636, 70933, 50084, 72270, 70934, 
70402, 71667, 71852, 71873, 117970, 70493, 72924, 71417, 72600, 
73142, 79031, 107243, 72769), PropLbsperFt = c(2398, 1980, 2390, 
724, 1429, 1435, 1419, 1321, 1424, 1307, 2398, 799, 1039, 1242, 
2334, 939, 1207, 2374, 1279, 1280, 1221, 1309, 1958, 1762, 1020, 
1691, 1312, 1616, 1374, 2528, 817, 2025, 1268, 1465, 1350, 2335, 
1668, 1257, 818, 1396, 1324, 1180, 946, 1468, 842, 1275, 1489, 
1497, 1402, 1418, 958, 1878, 1297, 1328, 977, 974, 622, 1411, 
2418, 1480, 2473, 1281, 2032, 925, 1361, 2236, 1009, 1259, 2527, 
1284, 1238, 2315, 2370, 2351, 1208, 2088, 2038, 2030, 1431, 1922, 
1336, 1309, 1030, 1388, 2416, 1241, 1218, 1654, 1216, 1234, 1657, 
931, 1300, 1330, 1648, 1246, 1284, 1480, 845, 1281), StageLength = c(204, 
193, 209, 217, 217, 216, 217, 217, 217, 219, 209, 395, 277, 229, 
211, 341, 241, 209, 225, 225, 236, 220, 204, 219, 377, 216, 220, 
222, 209, 198, 383, 210, 286, 213, 213, 368, 216, 285, 380, 219, 
217, 306, 381, 216, 374, 225, 212, 212, 212, 212, 398, 156, 224, 
217, 404, 387, 400, 204, 207, 211, 349, 227, 394, 353, 212, 214, 
383, 286, 198, 225, 233, 184, 181, 181, 236, 248, 394, 394, 216, 
222, 216, 220, 370, 204, 207, 233, 233, 212, 236, 233, 216, 380, 
272, 219, 216, 233, 228, 213, 383, 226), XLBorate = c(1668520, 
31471, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 2740512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 2439778, 0, 0, 0, 0, 0, 0, 0, 2107204, 0, 0, 0, 2005797, 
0, 1132512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2822701, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2695897, 
0, 0, 0, 0, 0, 0, 0, 0)), class = c("tbl_df", "tbl", "data.frame"
), row.names = c(NA, -100L))