Hello all,
I am completely clueless as to what is going wrong; I have a dataset and I am using the anova_test function to complete an ANOVA on the data.
For one of my datasets, it works, for the other dataset is does not work:
When it does not work, it gives me the error:
Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, ...) :
0 (non-NA) cases
The non-working dataset:
install.packages('rstatix')
library('rstatix')
ANOVAtest <- anova_test(data=Dataovershootwithoutmeans, formula=Overshootextent~Condition*Targetdistance+Error(ID/Condition*Targetdistance), dv=Overshootextent , wid=ID,within=c(Condition,Targetdistance),effect.size = "pes")
structure(list(Targetdistance = c(63.207, 63.207, 63.207, 94.81,
94.81, 94.81, 142.215, 142.215, 142.215, 213.322, 213.322, 213.322,
319.983, 319.983, 319.983, 63.207, 94.81, 94.81, 94.81, 142.215,
142.215, 142.215, 213.322, 213.322, 213.322, 319.983, 319.983,
319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 94.81, 142.215,
142.215, 142.215, 213.322, 213.322, 213.322, 319.983, 319.983,
319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 142.215, 142.215,
142.215, 213.322, 213.322, 213.322, 319.983, 319.983, 319.983,
63.207, 63.207, 63.207, 94.81, 94.81, 94.81, 142.215, 142.215,
142.215, 213.322, 213.322, 213.322, 319.983, 319.983, 319.983,
63.207, 94.81, 94.81, 94.81, 142.215, 142.215, 213.322, 213.322,
213.322, 319.983, 319.983, 319.983, 63.207, 63.207, 63.207, 94.81,
94.81, 142.215, 142.215, 142.215, 213.322, 213.322, 213.322,
319.983, 319.983, 319.983, 63.207, 63.207, 63.207, 94.81, 94.81,
142.215, 142.215, 142.215, 213.322, 213.322, 213.322, 319.983,
319.983, 319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 94.81,
142.215, 142.215, 142.215, 213.322, 213.322, 213.322, 319.983,
319.983, 319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 142.215,
213.322, 213.322, 213.322, 319.983, 319.983, 319.983, 63.207,
63.207, 94.81, 142.215, 142.215, 213.322, 213.322, 319.983, 319.983,
319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 94.81, 142.215,
142.215, 213.322, 213.322, 213.322, 319.983, 319.983, 319.983,
63.207, 63.207, 94.81, 94.81, 94.81, 142.215, 142.215, 142.215,
213.322, 213.322, 213.322, 319.983, 319.983, 319.983, 63.207,
63.207, 63.207, 94.81, 94.81, 94.81, 142.215, 142.215, 142.215,
213.322, 213.322, 213.322, 319.983, 319.983, 319.983, 63.207,
63.207, 63.207, 94.81, 94.81, 142.215, 142.215, 142.215, 213.322,
213.322, 213.322, 319.983, 319.983, 319.983), Condition = c("0",
"0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2",
"0", "0.5", "2", "0", "0", "0.5", "2", "0", "0.5", "2", "0",
"0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2",
"0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0",
"0.5", "2", "0", "0.5", "2", "0", "0", "0.5", "2", "0.5", "2",
"0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "2",
"0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0",
"0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2",
"0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "0.5", "0", "0.5",
"0", "0.5", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2",
"0", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "0",
"0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2",
"0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0", "0.5", "2", "0", "0.5", "2", "0", "2", "0", "0.5",
"2", "0", "0.5", "2", "0", "0.5", "2"), ID = c("P_200214103155",
"P_200214103155", "P_200214103155", "P_200214103155", "P_200214103155",
"P_200214103155", "P_200214103155", "P_200214103155", "P_200214103155",
"P_200214103155", "P_200214103155", "P_200214103155", "P_200214103155",
"P_200214103155", "P_200214103155", "P_200214123342", "P_200214123342",
"P_200214123342", "P_200214123342", "P_200214123342", "P_200214123342",
"P_200214123342", "P_200214123342", "P_200214123342", "P_200214123342",
"P_200214123342", "P_200214123342", "P_200214123342", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200217101213", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200217101213", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200217101213", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200219091823", "P_200219091823",
"P_200219091823", "P_200219091823", "P_200219091823", "P_200219091823",
"P_200219091823", "P_200219091823", "P_200219091823", "P_200219091823",
"P_200219091823", "P_200219091823", "P_200219091823", "P_200219091823",
"P_200219102411", "P_200219102411", "P_200219102411", "P_200219102411",
"P_200219102411", "P_200219102411", "P_200219102411", "P_200219102411",
"P_200219102411", "P_200219102411", "P_200219102411", "P_200219102411",
"P_200219102411", "P_200219102411", "P_200219102411", "P_200219111605",
"P_200219111605", "P_200219111605", "P_200219111605", "P_200219111605",
"P_200219111605", "P_200219111605", "P_200219111605", "P_200219111605",
"P_200219111605", "P_200219111605", "P_200219111605", "P_200219123120",
"P_200219123120", "P_200219123120", "P_200219123120", "P_200219123120",
"P_200219123120", "P_200219123120", "P_200219123120", "P_200219123120",
"P_200219123120", "P_200219123120", "P_200219123120", "P_200219123120",
"P_200219123120", "P_200219163622", "P_200219163622", "P_200219163622",
"P_200219163622", "P_200219163622", "P_200219163622", "P_200219163622",
"P_200219163622", "P_200219163622", "P_200219163622", "P_200219163622",
"P_200219163622", "P_200219163622", "P_200219163622", "P_200219175102",
"P_200219175102", "P_200219175102", "P_200219175102", "P_200219175102",
"P_200219175102", "P_200219175102", "P_200219175102", "P_200219175102",
"P_200219175102", "P_200219175102", "P_200219175102", "P_200219175102",
"P_200219175102", "P_200219175102", "P_200220130332", "P_200220130332",
"P_200220130332", "P_200220130332", "P_200220130332", "P_200220130332",
"P_200220130332", "P_200220130332", "P_200220130332", "P_200220130332",
"P_200220130332", "P_200220130332", "P_200220145557", "P_200220145557",
"P_200220145557", "P_200220145557", "P_200220145557", "P_200220145557",
"P_200220145557", "P_200220145557", "P_200220145557", "P_200220145557",
"P_200221101028", "P_200221101028", "P_200221101028", "P_200221101028",
"P_200221101028", "P_200221101028", "P_200221101028", "P_200221101028",
"P_200221101028", "P_200221101028", "P_200221101028", "P_200221101028",
"P_200221101028", "P_200221101028", "P_200224092247", "P_200224092247",
"P_200224092247", "P_200224092247", "P_200224092247", "P_200224092247",
"P_200224092247", "P_200224092247", "P_200224092247", "P_200224092247",
"P_200224092247", "P_200224092247", "P_200224092247", "P_200224092247",
"P_200225171612", "P_200225171612", "P_200225171612", "P_200225171612",
"P_200225171612", "P_200225171612", "P_200225171612", "P_200225171612",
"P_200225171612", "P_200225171612", "P_200225171612", "P_200225171612",
"P_200225171612", "P_200225171612", "P_200225171612", "P_200225184226",
"P_200225184226", "P_200225184226", "P_200225184226", "P_200225184226",
"P_200225184226", "P_200225184226", "P_200225184226", "P_200225184226",
"P_200225184226", "P_200225184226", "P_200225184226", "P_200225184226",
"P_200225184226"), Undershootextent = c(3.498, 6.16125, 10.4203333333333,
15.85225, 10.553, 10.441, 17.495, 38.3326666666667, 40.32075,
45.7898, 45.947, 8.86733333333333, 30.8794, 26.6903333333333,
41.7653333333333, 9.67633333333333, 37.7395, 1.98700000000001,
19.793, 80.312, 38.4063333333333, 9.03900000000002, 31.1623333333333,
72.099, 63.8242, 48.59725, 50.873, 88.283, 1.23, 4.307, 12.9515,
15.071, 24.0473333333333, 31.722, 10.974, 15.467, 38.7466666666667,
39.025, 13.446, 23.621, 13.705, 34.7716666666667, 58.126, 17.166,
8.551, 23.984, 14.267, 17.2785, 23.461, 12.11, 15.6366666666667,
27.68975, 7.08275, 11.905, 88.3576, 48.83, 51.4953333333333,
5.809, 14.72725, 6.7255, 14.2435, 17.7566666666667, 7.4355, 5.97999999999999,
41.1263333333333, 59.1706666666667, 58.339, 47.0502, 39.5298,
59.125, 56.8878, 111.4515, 6.39833333333333, 10.3656666666667,
14.344, 21.827, 32.7473333333333, 21.956, 29.3793333333333, 5.214,
31.332, 6.09733333333332, 18.956, 50.84075, 16.9006666666667,
17.027, 13.2853333333333, 10.139, 19.9755, 52.38275, 24.9088,
45.3246666666667, 79.93425, 44.52575, 59.9216, 157.786, 36.7193333333333,
109.3215, 9.3225, 10.923, 10.159, 13.38, 35.9125, 4.642, 10.5175,
44.429, 26.8053333333333, 25.546, 20.56575, 33.372, 43.037, 23.36975,
11.352, 11.6883333333333, 5.439, 24.542, 11.773, 33.4775, 21.554,
3.774, 32.7606666666667, 21.839, 29.4696666666667, 47.863, 22.743,
20.0143333333334, 29.36925, 3.092, 1.4685, 1.593, 2.89100000000001,
9.961, 19.197, 26.56, 9.94850000000002, 36.6005, 72.539, 70.0685,
46.867, 0.411999999999999, 1.908, 2.521, 4.399, 1.18199999999999,
0.188999999999993, 1.8775, 0.65300000000002, 18.665, 3.22250000000003,
21.145, 8.93333333333334, 5.864, 22.4505, 2.73699999999999, 11.1146666666667,
26.01475, 16.44, 24.6734, 1.18200000000002, 36.77175, 34.325,
121.487333333333, 43.02575, 1.696, 3.105, 7.744, 1.726, 5.773,
17.8083333333333, 6.93133333333333, 25.0695, 50.695, 26.888,
59.3085, 21.4113333333333, 53.429, 49.6993333333333, -31.7734,
-31.9482, -48.082, -28.8608, -57.6672, -38.3734, 9.07919999999999,
-32.3834, -16.6084, 1.1782, 9.62379999999999, -13.735, 33.1458,
3.75200000000001, 3.68419999999998, 2.03, 8.2665, 18.9225, 8.333,
23.5608, 48.684, 22.4245, 34.215, 8.04750000000001, 26.381, 53.8994,
30.104, 62.651, 44.6344)), class = "data.frame", row.names = c(NA,
-206L))
#> Targetdistance Condition ID Undershootextent
#> 1 63.207 0 P_200214103155 3.498000
#> 2 63.207 0.5 P_200214103155 6.161250
#> 3 63.207 2 P_200214103155 10.420333
#> 4 94.810 0 P_200214103155 15.852250
#> 5 94.810 0.5 P_200214103155 10.553000
#> 6 94.810 2 P_200214103155 10.441000
#> 7 142.215 0 P_200214103155 17.495000
#> 8 142.215 0.5 P_200214103155 38.332667
#> 9 142.215 2 P_200214103155 40.320750
#> 10 213.322 0 P_200214103155 45.789800
#> 11 213.322 0.5 P_200214103155 45.947000
#> 12 213.322 2 P_200214103155 8.867333
#> 13 319.983 0 P_200214103155 30.879400
#> 14 319.983 0.5 P_200214103155 26.690333
#> 15 319.983 2 P_200214103155 41.765333
#> 16 63.207 0 P_200214123342 9.676333
#> 17 94.810 0 P_200214123342 37.739500
#> 18 94.810 0.5 P_200214123342 1.987000
#> 19 94.810 2 P_200214123342 19.793000
#> 20 142.215 0 P_200214123342 80.312000
#> 21 142.215 0.5 P_200214123342 38.406333
#> 22 142.215 2 P_200214123342 9.039000
#> 23 213.322 0 P_200214123342 31.162333
#> 24 213.322 0.5 P_200214123342 72.099000
#> 25 213.322 2 P_200214123342 63.824200
#> 26 319.983 0 P_200214123342 48.597250
#> 27 319.983 0.5 P_200214123342 50.873000
#> 28 319.983 2 P_200214123342 88.283000
#> 29 63.207 0 P_200217101213 1.230000
#> 30 63.207 0.5 P_200217101213 4.307000
#> 31 63.207 2 P_200217101213 12.951500
#> 32 94.810 0 P_200217101213 15.071000
#> 33 94.810 0.5 P_200217101213 24.047333
#> 34 94.810 2 P_200217101213 31.722000
#> 35 142.215 0 P_200217101213 10.974000
#> 36 142.215 0.5 P_200217101213 15.467000
#> 37 142.215 2 P_200217101213 38.746667
#> 38 213.322 0 P_200217101213 39.025000
#> 39 213.322 0.5 P_200217101213 13.446000
#> 40 213.322 2 P_200217101213 23.621000
#> 41 319.983 0 P_200217101213 13.705000
#> 42 319.983 0.5 P_200217101213 34.771667
#> 43 319.983 2 P_200217101213 58.126000
#> 44 63.207 0 P_200219091823 17.166000
#> 45 63.207 0.5 P_200219091823 8.551000
#> 46 63.207 2 P_200219091823 23.984000
#> 47 94.810 0.5 P_200219091823 14.267000
#> 48 94.810 2 P_200219091823 17.278500
#> 49 142.215 0 P_200219091823 23.461000
#> 50 142.215 0.5 P_200219091823 12.110000
#> 51 142.215 2 P_200219091823 15.636667
#> 52 213.322 0 P_200219091823 27.689750
#> 53 213.322 0.5 P_200219091823 7.082750
#> 54 213.322 2 P_200219091823 11.905000
#> 55 319.983 0 P_200219091823 88.357600
#> 56 319.983 0.5 P_200219091823 48.830000
#> 57 319.983 2 P_200219091823 51.495333
#> 58 63.207 0 P_200219102411 5.809000
#> 59 63.207 0.5 P_200219102411 14.727250
#> 60 63.207 2 P_200219102411 6.725500
#> 61 94.810 0 P_200219102411 14.243500
#> 62 94.810 0.5 P_200219102411 17.756667
#> 63 94.810 2 P_200219102411 7.435500
#> 64 142.215 0 P_200219102411 5.980000
#> 65 142.215 0.5 P_200219102411 41.126333
#> 66 142.215 2 P_200219102411 59.170667
#> 67 213.322 0 P_200219102411 58.339000
#> 68 213.322 0.5 P_200219102411 47.050200
#> 69 213.322 2 P_200219102411 39.529800
#> 70 319.983 0 P_200219102411 59.125000
#> 71 319.983 0.5 P_200219102411 56.887800
#> 72 319.983 2 P_200219102411 111.451500
#> 73 63.207 0 P_200219111605 6.398333
#> 74 94.810 0 P_200219111605 10.365667
#> 75 94.810 0.5 P_200219111605 14.344000
#> 76 94.810 2 P_200219111605 21.827000
#> 77 142.215 0.5 P_200219111605 32.747333
#> 78 142.215 2 P_200219111605 21.956000
#> 79 213.322 0 P_200219111605 29.379333
#> 80 213.322 0.5 P_200219111605 5.214000
#> 81 213.322 2 P_200219111605 31.332000
#> 82 319.983 0 P_200219111605 6.097333
#> 83 319.983 0.5 P_200219111605 18.956000
#> 84 319.983 2 P_200219111605 50.840750
#> 85 63.207 0 P_200219123120 16.900667
#> 86 63.207 0.5 P_200219123120 17.027000
#> 87 63.207 2 P_200219123120 13.285333
#> 88 94.810 0 P_200219123120 10.139000
#> 89 94.810 2 P_200219123120 19.975500
#> 90 142.215 0 P_200219123120 52.382750
#> 91 142.215 0.5 P_200219123120 24.908800
#> 92 142.215 2 P_200219123120 45.324667
#> 93 213.322 0 P_200219123120 79.934250
#> 94 213.322 0.5 P_200219123120 44.525750
#> 95 213.322 2 P_200219123120 59.921600
#> 96 319.983 0 P_200219123120 157.786000
#> 97 319.983 0.5 P_200219123120 36.719333
#> 98 319.983 2 P_200219123120 109.321500
#> 99 63.207 0 P_200219163622 9.322500
#> 100 63.207 0.5 P_200219163622 10.923000
#> 101 63.207 2 P_200219163622 10.159000
#> 102 94.810 0 P_200219163622 13.380000
#> 103 94.810 2 P_200219163622 35.912500
#> 104 142.215 0 P_200219163622 4.642000
#> 105 142.215 0.5 P_200219163622 10.517500
#> 106 142.215 2 P_200219163622 44.429000
#> 107 213.322 0 P_200219163622 26.805333
#> 108 213.322 0.5 P_200219163622 25.546000
#> 109 213.322 2 P_200219163622 20.565750
#> 110 319.983 0 P_200219163622 33.372000
#> 111 319.983 0.5 P_200219163622 43.037000
#> 112 319.983 2 P_200219163622 23.369750
#> 113 63.207 0 P_200219175102 11.352000
#> 114 63.207 0.5 P_200219175102 11.688333
#> 115 63.207 2 P_200219175102 5.439000
#> 116 94.810 0 P_200219175102 24.542000
#> 117 94.810 0.5 P_200219175102 11.773000
#> 118 94.810 2 P_200219175102 33.477500
#> 119 142.215 0 P_200219175102 21.554000
#> 120 142.215 0.5 P_200219175102 3.774000
#> 121 142.215 2 P_200219175102 32.760667
#> 122 213.322 0 P_200219175102 21.839000
#> 123 213.322 0.5 P_200219175102 29.469667
#> 124 213.322 2 P_200219175102 47.863000
#> 125 319.983 0 P_200219175102 22.743000
#> 126 319.983 0.5 P_200219175102 20.014333
#> 127 319.983 2 P_200219175102 29.369250
#> 128 63.207 0 P_200220130332 3.092000
#> 129 63.207 0.5 P_200220130332 1.468500
#> 130 63.207 2 P_200220130332 1.593000
#> 131 94.810 0 P_200220130332 2.891000
#> 132 94.810 0.5 P_200220130332 9.961000
#> 133 142.215 2 P_200220130332 19.197000
#> 134 213.322 0 P_200220130332 26.560000
#> 135 213.322 0.5 P_200220130332 9.948500
#> 136 213.322 2 P_200220130332 36.600500
#> 137 319.983 0 P_200220130332 72.539000
#> 138 319.983 0.5 P_200220130332 70.068500
#> 139 319.983 2 P_200220130332 46.867000
#> 140 63.207 0 P_200220145557 0.412000
#> 141 63.207 0.5 P_200220145557 1.908000
#> 142 94.810 0.5 P_200220145557 2.521000
#> 143 142.215 0 P_200220145557 4.399000
#> 144 142.215 0.5 P_200220145557 1.182000
#> 145 213.322 0 P_200220145557 0.189000
#> 146 213.322 0.5 P_200220145557 1.877500
#> 147 319.983 0 P_200220145557 0.653000
#> 148 319.983 0.5 P_200220145557 18.665000
#> 149 319.983 2 P_200220145557 3.222500
#> 150 63.207 0 P_200221101028 21.145000
#> 151 63.207 0.5 P_200221101028 8.933333
#> 152 63.207 2 P_200221101028 5.864000
#> 153 94.810 0 P_200221101028 22.450500
#> 154 94.810 0.5 P_200221101028 2.737000
#> 155 94.810 2 P_200221101028 11.114667
#> 156 142.215 0 P_200221101028 26.014750
#> 157 142.215 2 P_200221101028 16.440000
#> 158 213.322 0 P_200221101028 24.673400
#> 159 213.322 0.5 P_200221101028 1.182000
#> 160 213.322 2 P_200221101028 36.771750
#> 161 319.983 0 P_200221101028 34.325000
#> 162 319.983 0.5 P_200221101028 121.487333
#> 163 319.983 2 P_200221101028 43.025750
#> 164 63.207 0 P_200224092247 1.696000
#> 165 63.207 0.5 P_200224092247 3.105000
#> 166 94.810 0 P_200224092247 7.744000
#> 167 94.810 0.5 P_200224092247 1.726000
#> 168 94.810 2 P_200224092247 5.773000
#> 169 142.215 0 P_200224092247 17.808333
#> 170 142.215 0.5 P_200224092247 6.931333
#> 171 142.215 2 P_200224092247 25.069500
#> 172 213.322 0 P_200224092247 50.695000
#> 173 213.322 0.5 P_200224092247 26.888000
#> 174 213.322 2 P_200224092247 59.308500
#> 175 319.983 0 P_200224092247 21.411333
#> 176 319.983 0.5 P_200224092247 53.429000
#> 177 319.983 2 P_200224092247 49.699333
#> 178 63.207 0 P_200225171612 -31.773400
#> 179 63.207 0.5 P_200225171612 -31.948200
#> 180 63.207 2 P_200225171612 -48.082000
#> 181 94.810 0 P_200225171612 -28.860800
#> 182 94.810 0.5 P_200225171612 -57.667200
#> 183 94.810 2 P_200225171612 -38.373400
#> 184 142.215 0 P_200225171612 9.079200
#> 185 142.215 0.5 P_200225171612 -32.383400
#> 186 142.215 2 P_200225171612 -16.608400
#> 187 213.322 0 P_200225171612 1.178200
#> 188 213.322 0.5 P_200225171612 9.623800
#> 189 213.322 2 P_200225171612 -13.735000
#> 190 319.983 0 P_200225171612 33.145800
#> 191 319.983 0.5 P_200225171612 3.752000
#> 192 319.983 2 P_200225171612 3.684200
#> 193 63.207 0 P_200225184226 2.030000
#> 194 63.207 0.5 P_200225184226 8.266500
#> 195 63.207 2 P_200225184226 18.922500
#> 196 94.810 0 P_200225184226 8.333000
#> 197 94.810 2 P_200225184226 23.560800
#> 198 142.215 0 P_200225184226 48.684000
#> 199 142.215 0.5 P_200225184226 22.424500
#> 200 142.215 2 P_200225184226 34.215000
#> 201 213.322 0 P_200225184226 8.047500
#> 202 213.322 0.5 P_200225184226 26.381000
#> 203 213.322 2 P_200225184226 53.899400
#> 204 319.983 0 P_200225184226 30.104000
#> 205 319.983 0.5 P_200225184226 62.651000
#> 206 319.983 2 P_200225184226 44.634400
The working dataset:
ANOVAtest <- anova_test(data=Dataundershootwithoutmeans, formula=Undershootextent~Condition*Distancetotarget+Error(ID/Condition*Distancetotarget), dv=Undershootextent , wid=ID,within=c(Condition,Distancetotarget),effect.size = "pes")
structure(list(Distancetotarget = c(63.207, 63.207, 63.207, 94.81,
94.81, 94.81, 142.215, 142.215, 142.215, 213.322, 213.322, 213.322,
319.983, 319.983, 319.983, 63.207, 94.81, 94.81, 94.81, 142.215,
142.215, 142.215, 213.322, 213.322, 213.322, 319.983, 319.983,
319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 94.81, 142.215,
142.215, 142.215, 213.322, 213.322, 213.322, 319.983, 319.983,
319.983, 63.207, 63.207, 63.207, 94.81, 94.81, 142.215, 142.215
), Condition = c("0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0", "0.5", "2", "0", "0.5", "2", "0", "0", "0.5", "2",
"0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5",
"2", "0", "0.5", "2", "0", "0.5", "2", "0", "0.5", "2", "0",
"0.5", "2", "0", "0.5", "2", "0.5", "2", "0", "0.5"), ID = c("P_200214103155",
"P_200214103155", "P_200214103155", "P_200214103155", "P_200214103155",
"P_200214103155", "P_200214103155", "P_200214103155", "P_200214103155",
"P_200214103155", "P_200214103155", "P_200214103155", "P_200214103155",
"P_200214103155", "P_200214103155", "P_200214123342", "P_200214123342",
"P_200214123342", "P_200214123342", "P_200214123342", "P_200214123342",
"P_200214123342", "P_200214123342", "P_200214123342", "P_200214123342",
"P_200214123342", "P_200214123342", "P_200214123342", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200217101213", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200217101213", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200217101213", "P_200217101213",
"P_200217101213", "P_200217101213", "P_200219091823", "P_200219091823",
"P_200219091823", "P_200219091823", "P_200219091823", "P_200219091823",
"P_200219091823"), Stopdistancefromstart = c(59.709, 57.04575,
52.7866666666667, 78.95775, 84.257, 84.369, 124.72, 103.882333333333,
101.89425, 167.5322, 167.375, 204.454666666667, 289.1036, 293.292666666667,
278.217666666667, 53.5306666666667, 57.0705, 92.823, 75.017,
61.903, 103.808666666667, 133.176, 182.159666666667, 141.223,
149.4978, 271.38575, 269.11, 231.7, 61.977, 58.9, 50.2555, 79.739,
70.7626666666667, 63.088, 131.241, 126.748, 103.468333333333,
174.297, 199.876, 189.701, 306.278, 285.211333333333, 261.857,
46.041, 54.656, 39.223, 80.543, 77.5315, 118.754, 130.105), Undershootextent = c(3.498,
6.16125, 10.4203333333333, 15.85225, 10.553, 10.441, 17.495,
38.3326666666667, 40.32075, 45.7898, 45.947, 8.86733333333333,
30.8794, 26.6903333333333, 41.7653333333333, 9.67633333333333,
37.7395, 1.98700000000001, 19.793, 80.312, 38.4063333333333,
9.03900000000002, 31.1623333333333, 72.099, 63.8242, 48.59725,
50.873, 88.283, 1.23, 4.307, 12.9515, 15.071, 24.0473333333333,
31.722, 10.974, 15.467, 38.7466666666667, 39.025, 13.446, 23.621,
13.705, 34.7716666666667, 58.126, 17.166, 8.551, 23.984, 14.267,
17.2785, 23.461, 12.11)), row.names = c(NA, -50L), class = "data.frame")
#> Distancetotarget Condition ID Stopdistancefromstart
#> 1 63.207 0 P_200214103155 59.70900
#> 2 63.207 0.5 P_200214103155 57.04575
#> 3 63.207 2 P_200214103155 52.78667
#> 4 94.810 0 P_200214103155 78.95775
#> 5 94.810 0.5 P_200214103155 84.25700
#> 6 94.810 2 P_200214103155 84.36900
#> 7 142.215 0 P_200214103155 124.72000
#> 8 142.215 0.5 P_200214103155 103.88233
#> 9 142.215 2 P_200214103155 101.89425
#> 10 213.322 0 P_200214103155 167.53220
#> 11 213.322 0.5 P_200214103155 167.37500
#> 12 213.322 2 P_200214103155 204.45467
#> 13 319.983 0 P_200214103155 289.10360
#> 14 319.983 0.5 P_200214103155 293.29267
#> 15 319.983 2 P_200214103155 278.21767
#> 16 63.207 0 P_200214123342 53.53067
#> 17 94.810 0 P_200214123342 57.07050
#> 18 94.810 0.5 P_200214123342 92.82300
#> 19 94.810 2 P_200214123342 75.01700
#> 20 142.215 0 P_200214123342 61.90300
#> 21 142.215 0.5 P_200214123342 103.80867
#> 22 142.215 2 P_200214123342 133.17600
#> 23 213.322 0 P_200214123342 182.15967
#> 24 213.322 0.5 P_200214123342 141.22300
#> 25 213.322 2 P_200214123342 149.49780
#> 26 319.983 0 P_200214123342 271.38575
#> 27 319.983 0.5 P_200214123342 269.11000
#> 28 319.983 2 P_200214123342 231.70000
#> 29 63.207 0 P_200217101213 61.97700
#> 30 63.207 0.5 P_200217101213 58.90000
#> 31 63.207 2 P_200217101213 50.25550
#> 32 94.810 0 P_200217101213 79.73900
#> 33 94.810 0.5 P_200217101213 70.76267
#> 34 94.810 2 P_200217101213 63.08800
#> 35 142.215 0 P_200217101213 131.24100
#> 36 142.215 0.5 P_200217101213 126.74800
#> 37 142.215 2 P_200217101213 103.46833
#> 38 213.322 0 P_200217101213 174.29700
#> 39 213.322 0.5 P_200217101213 199.87600
#> 40 213.322 2 P_200217101213 189.70100
#> 41 319.983 0 P_200217101213 306.27800
#> 42 319.983 0.5 P_200217101213 285.21133
#> 43 319.983 2 P_200217101213 261.85700
#> 44 63.207 0 P_200219091823 46.04100
#> 45 63.207 0.5 P_200219091823 54.65600
#> 46 63.207 2 P_200219091823 39.22300
#> 47 94.810 0.5 P_200219091823 80.54300
#> 48 94.810 2 P_200219091823 77.53150
#> 49 142.215 0 P_200219091823 118.75400
#> 50 142.215 0.5 P_200219091823 130.10500
#> Undershootextent
#> 1 3.498000
#> 2 6.161250
#> 3 10.420333
#> 4 15.852250
#> 5 10.553000
#> 6 10.441000
#> 7 17.495000
#> 8 38.332667
#> 9 40.320750
#> 10 45.789800
#> 11 45.947000
#> 12 8.867333
#> 13 30.879400
#> 14 26.690333
#> 15 41.765333
#> 16 9.676333
#> 17 37.739500
#> 18 1.987000
#> 19 19.793000
#> 20 80.312000
#> 21 38.406333
#> 22 9.039000
#> 23 31.162333
#> 24 72.099000
#> 25 63.824200
#> 26 48.597250
#> 27 50.873000
#> 28 88.283000
#> 29 1.230000
#> 30 4.307000
#> 31 12.951500
#> 32 15.071000
#> 33 24.047333
#> 34 31.722000
#> 35 10.974000
#> 36 15.467000
#> 37 38.746667
#> 38 39.025000
#> 39 13.446000
#> 40 23.621000
#> 41 13.705000
#> 42 34.771667
#> 43 58.126000
#> 44 17.166000
#> 45 8.551000
#> 46 23.984000
#> 47 14.267000
#> 48 17.278500
#> 49 23.461000
#> 50 12.110000
I will do so right away