rm(list=ls())
source("useful.R")
## Warning: package 'lubridate' was built under R version 3.2.3
## Warning: package 'tidyr' was built under R version 3.2.3
d <- read.csv("janiszewski_rep_exercise.csv")
We will fix this data programatically.
d <- read.csv("janiszewski_rep_cleaned.csv")
d.tidy <- d %>%
select(Input.condition:Answer.sushi_cost) %>%
rename(condition = Input.condition, price1 = Input.price1, price2 = Input.price2, price3 = Input.price3,
dogCost = Answer.dog_cost, plasmaCost = Answer.plasma_cost, sushiCost = Answer.sushi_cost)
d.tidy <- cbind(id = seq.int(nrow(d.tidy)), d.tidy)
print(d.tidy)
## id condition price1 price2 price3 dogCost plasmaCost sushiCost
## 1 1 over 5012 2508 9.36 2300.00 4800.00 8.70
## 2 2 over 5012 2508 9.36 2450.00 4850.00 9.00
## 3 3 over 5012 2508 9.36 800.00 1200.00 8.00
## 4 4 over 5012 2508 9.36 2000.00 4200.00 9.00
## 5 5 over 5012 2508 9.36 2000.00 4500.00 8.50
## 6 6 over 5012 2508 9.36 1600.00 4600.00 8.00
## 7 7 over 5012 2508 9.36 1750.00 4650.00 6.95
## 8 8 over 5012 2508 9.36 2200.00 4800.00 8.00
## 9 9 over 5012 2508 9.36 2000.00 4500.00 8.99
## 10 10 over 5012 2508 9.36 1000.00 3000.00 9.00
## 11 11 over 5012 2508 9.36 1600.00 4578.00 8.50
## 12 12 over 5012 2508 9.36 2250.00 4999.00 8.50
## 13 13 over 5012 2508 9.36 2000.00 4000.00 NA
## 14 14 over 5012 2508 9.36 2000.00 4500.00 8.50
## 15 15 over 5012 2508 9.36 2200.00 4500.00 8.00
## 16 16 over 5012 2508 9.36 2200.00 4700.00 8.00
## 17 17 over 5012 2508 9.36 1000.00 5000.00 7.75
## 18 18 over 5012 2508 9.36 2250.00 4899.00 8.00
## 19 19 over 5012 2508 9.36 1749.00 3499.00 8.99
## 20 20 over 5012 2508 9.36 1850.00 4999.99 7.99
## 21 21 over 5012 2508 9.36 2500.00 4999.00 9.30
## 22 22 over 5012 2508 9.36 2000.00 4500.00 8.50
## 23 23 over 5012 2508 9.36 1500.00 3200.00 7.35
## 24 24 over 5012 2508 9.36 2250.00 4500.00 8.50
## 25 25 over 5012 2508 9.36 1500.00 3000.00 8.00
## 26 26 over 5012 2508 9.36 1875.00 4699.00 7.89
## 27 27 over 5012 2508 9.36 2000.00 4540.00 8.95
## 28 28 over 5012 2508 9.36 1800.00 3800.00 7.00
## 29 29 over 5012 2508 9.36 2000.00 4000.00 8.50
## 30 30 over 5012 2508 9.36 2325.00 4997.00 8.99
## 31 31 under 4988 2492 8.64 1000.00 2500.00 7.50
## 32 32 under 4988 2492 8.64 2000.00 2500.00 7.80
## 33 33 under 4988 2492 8.64 2192.00 4888.00 7.50
## 34 34 under 4988 2492 8.64 2000.00 4400.00 7.99
## 35 35 under 4988 2492 8.64 2000.00 4500.00 8.00
## 36 36 under 4988 2492 8.64 2100.00 4300.00 7.99
## 37 37 under 4988 2492 8.64 2299.00 4500.00 7.80
## 38 38 under 4988 2492 8.64 2100.00 3500.00 6.99
## 39 39 under 4988 2492 8.64 2292.00 4888.00 7.50
## 40 40 under 4988 2492 8.64 2482.00 4968.00 8.46
## 41 41 under 4988 2492 8.64 1500.00 3000.00 7.50
## 42 42 under 4988 2492 8.64 2200.00 4000.00 6.99
## 43 43 under 4988 2492 8.64 1500.00 4000.00 7.99
## 44 44 under 4988 2492 8.64 1900.00 4700.00 7.99
## 45 45 under 4988 2492 8.64 2000.00 4500.00 6.99
## 46 46 under 4988 2492 8.64 2200.00 4750.00 7.50
## 47 47 under 4988 2492 8.64 1500.00 2500.00 7.58
## 48 48 under 4988 2492 8.64 1900.00 4120.00 7.75
## 49 49 under 4988 2492 8.64 2200.00 4900.00 8.00
## 50 50 under 4988 2492 8.64 2000.00 4000.00 7.56
## 51 51 under 4988 2492 8.64 1990.00 3250.00 7.75
## 52 52 under 4988 2492 8.64 2000.00 4000.00 7.99
## 53 53 under 4988 2492 8.64 1750.00 3500.00 7.99
## 54 54 under 4988 2492 8.64 1790.00 4350.00 7.50
## 55 55 under 4988 2492 8.64 2000.00 3200.00 8.50
## 56 56 under 4988 2492 8.64 500.00 4500.00 7.99
## 57 57 under 4988 2492 8.64 2000.00 4800.00 8.00
## 58 58 under 4988 2492 8.64 2000.00 3500.00 7.69
## 59 59 rounded 5000 2500 9.00 2300.00 4500.00 8.00
## 60 60 rounded 5000 2500 9.00 2000.00 4500.00 8.49
## 61 61 rounded 5000 2500 9.00 2200.00 4500.00 8.00
## 62 62 rounded 5000 2500 9.00 1900.00 3500.00 7.50
## 63 63 rounded 5000 2500 9.00 1000.00 2500.00 6.95
## 64 64 rounded 5000 2500 9.00 1700.00 4495.00 7.50
## 65 65 rounded 5000 2500 9.00 2400.00 4849.00 8.69
## 66 66 rounded 5000 2500 9.00 1700.00 3500.00 8.00
## 67 67 rounded 5000 2500 9.00 2000.00 4000.00 8.00
## 68 68 rounded 5000 2500 9.00 1800.00 1500.00 8.00
## 69 69 rounded 5000 2500 9.00 2000.00 4200.00 8.00
## 70 70 rounded 5000 2500 9.00 2000.00 2999.00 7.00
## 71 71 rounded 5000 2500 9.00 2450.00 4995.00 8.95
## 72 72 rounded 5000 2500 9.00 2300.00 4700.00 7.50
## 73 73 rounded 5000 2500 9.00 2000.00 4300.00 8.25
## 74 74 rounded 5000 2500 9.00 1000.00 3500.00 8.00
## 75 75 rounded 5000 2500 9.00 1950.00 4675.00 7.89
## 76 76 rounded 5000 2500 9.00 2000.00 4000.00 7.75
## 77 77 rounded 5000 2500 9.00 2000.00 4500.00 6.50
## 78 78 rounded 5000 2500 9.00 500.00 4500.00 8.00
## 79 79 rounded 5000 2500 9.00 1500.00 4500.00 7.00
## 80 80 rounded 5000 2500 9.00 2000.00 4700.00 8.50
## 81 81 rounded 5000 2500 9.00 1000.00 2000.00 7.50
## 82 82 rounded 5000 2500 9.00 2200.00 4700.00 8.00
## 83 83 rounded 5000 2500 9.00 2000.00 4000.00 8.50
## 84 84 rounded 5000 2500 9.00 2350.00 4750.00 8.25
## 85 85 rounded 5000 2500 9.00 2000.00 4000.00 8.50
## 86 86 rounded 5000 2500 9.00 1900.00 4800.00 8.50
## 87 87 rounded 5000 2500 9.00 2499.99 4995.00 8.99
d.gathered <- d.tidy %>%
gather(Type, Value, 3:8)
print(d.gathered)
## id condition Type Value
## 1 1 over price1 5012.00
## 2 2 over price1 5012.00
## 3 3 over price1 5012.00
## 4 4 over price1 5012.00
## 5 5 over price1 5012.00
## 6 6 over price1 5012.00
## 7 7 over price1 5012.00
## 8 8 over price1 5012.00
## 9 9 over price1 5012.00
## 10 10 over price1 5012.00
## 11 11 over price1 5012.00
## 12 12 over price1 5012.00
## 13 13 over price1 5012.00
## 14 14 over price1 5012.00
## 15 15 over price1 5012.00
## 16 16 over price1 5012.00
## 17 17 over price1 5012.00
## 18 18 over price1 5012.00
## 19 19 over price1 5012.00
## 20 20 over price1 5012.00
## 21 21 over price1 5012.00
## 22 22 over price1 5012.00
## 23 23 over price1 5012.00
## 24 24 over price1 5012.00
## 25 25 over price1 5012.00
## 26 26 over price1 5012.00
## 27 27 over price1 5012.00
## 28 28 over price1 5012.00
## 29 29 over price1 5012.00
## 30 30 over price1 5012.00
## 31 31 under price1 4988.00
## 32 32 under price1 4988.00
## 33 33 under price1 4988.00
## 34 34 under price1 4988.00
## 35 35 under price1 4988.00
## 36 36 under price1 4988.00
## 37 37 under price1 4988.00
## 38 38 under price1 4988.00
## 39 39 under price1 4988.00
## 40 40 under price1 4988.00
## 41 41 under price1 4988.00
## 42 42 under price1 4988.00
## 43 43 under price1 4988.00
## 44 44 under price1 4988.00
## 45 45 under price1 4988.00
## 46 46 under price1 4988.00
## 47 47 under price1 4988.00
## 48 48 under price1 4988.00
## 49 49 under price1 4988.00
## 50 50 under price1 4988.00
## 51 51 under price1 4988.00
## 52 52 under price1 4988.00
## 53 53 under price1 4988.00
## 54 54 under price1 4988.00
## 55 55 under price1 4988.00
## 56 56 under price1 4988.00
## 57 57 under price1 4988.00
## 58 58 under price1 4988.00
## 59 59 rounded price1 5000.00
## 60 60 rounded price1 5000.00
## 61 61 rounded price1 5000.00
## 62 62 rounded price1 5000.00
## 63 63 rounded price1 5000.00
## 64 64 rounded price1 5000.00
## 65 65 rounded price1 5000.00
## 66 66 rounded price1 5000.00
## 67 67 rounded price1 5000.00
## 68 68 rounded price1 5000.00
## 69 69 rounded price1 5000.00
## 70 70 rounded price1 5000.00
## 71 71 rounded price1 5000.00
## 72 72 rounded price1 5000.00
## 73 73 rounded price1 5000.00
## 74 74 rounded price1 5000.00
## 75 75 rounded price1 5000.00
## 76 76 rounded price1 5000.00
## 77 77 rounded price1 5000.00
## 78 78 rounded price1 5000.00
## 79 79 rounded price1 5000.00
## 80 80 rounded price1 5000.00
## 81 81 rounded price1 5000.00
## 82 82 rounded price1 5000.00
## 83 83 rounded price1 5000.00
## 84 84 rounded price1 5000.00
## 85 85 rounded price1 5000.00
## 86 86 rounded price1 5000.00
## 87 87 rounded price1 5000.00
## 88 1 over price2 2508.00
## 89 2 over price2 2508.00
## 90 3 over price2 2508.00
## 91 4 over price2 2508.00
## 92 5 over price2 2508.00
## 93 6 over price2 2508.00
## 94 7 over price2 2508.00
## 95 8 over price2 2508.00
## 96 9 over price2 2508.00
## 97 10 over price2 2508.00
## 98 11 over price2 2508.00
## 99 12 over price2 2508.00
## 100 13 over price2 2508.00
## 101 14 over price2 2508.00
## 102 15 over price2 2508.00
## 103 16 over price2 2508.00
## 104 17 over price2 2508.00
## 105 18 over price2 2508.00
## 106 19 over price2 2508.00
## 107 20 over price2 2508.00
## 108 21 over price2 2508.00
## 109 22 over price2 2508.00
## 110 23 over price2 2508.00
## 111 24 over price2 2508.00
## 112 25 over price2 2508.00
## 113 26 over price2 2508.00
## 114 27 over price2 2508.00
## 115 28 over price2 2508.00
## 116 29 over price2 2508.00
## 117 30 over price2 2508.00
## 118 31 under price2 2492.00
## 119 32 under price2 2492.00
## 120 33 under price2 2492.00
## 121 34 under price2 2492.00
## 122 35 under price2 2492.00
## 123 36 under price2 2492.00
## 124 37 under price2 2492.00
## 125 38 under price2 2492.00
## 126 39 under price2 2492.00
## 127 40 under price2 2492.00
## 128 41 under price2 2492.00
## 129 42 under price2 2492.00
## 130 43 under price2 2492.00
## 131 44 under price2 2492.00
## 132 45 under price2 2492.00
## 133 46 under price2 2492.00
## 134 47 under price2 2492.00
## 135 48 under price2 2492.00
## 136 49 under price2 2492.00
## 137 50 under price2 2492.00
## 138 51 under price2 2492.00
## 139 52 under price2 2492.00
## 140 53 under price2 2492.00
## 141 54 under price2 2492.00
## 142 55 under price2 2492.00
## 143 56 under price2 2492.00
## 144 57 under price2 2492.00
## 145 58 under price2 2492.00
## 146 59 rounded price2 2500.00
## 147 60 rounded price2 2500.00
## 148 61 rounded price2 2500.00
## 149 62 rounded price2 2500.00
## 150 63 rounded price2 2500.00
## 151 64 rounded price2 2500.00
## 152 65 rounded price2 2500.00
## 153 66 rounded price2 2500.00
## 154 67 rounded price2 2500.00
## 155 68 rounded price2 2500.00
## 156 69 rounded price2 2500.00
## 157 70 rounded price2 2500.00
## 158 71 rounded price2 2500.00
## 159 72 rounded price2 2500.00
## 160 73 rounded price2 2500.00
## 161 74 rounded price2 2500.00
## 162 75 rounded price2 2500.00
## 163 76 rounded price2 2500.00
## 164 77 rounded price2 2500.00
## 165 78 rounded price2 2500.00
## 166 79 rounded price2 2500.00
## 167 80 rounded price2 2500.00
## 168 81 rounded price2 2500.00
## 169 82 rounded price2 2500.00
## 170 83 rounded price2 2500.00
## 171 84 rounded price2 2500.00
## 172 85 rounded price2 2500.00
## 173 86 rounded price2 2500.00
## 174 87 rounded price2 2500.00
## 175 1 over price3 9.36
## 176 2 over price3 9.36
## 177 3 over price3 9.36
## 178 4 over price3 9.36
## 179 5 over price3 9.36
## 180 6 over price3 9.36
## 181 7 over price3 9.36
## 182 8 over price3 9.36
## 183 9 over price3 9.36
## 184 10 over price3 9.36
## 185 11 over price3 9.36
## 186 12 over price3 9.36
## 187 13 over price3 9.36
## 188 14 over price3 9.36
## 189 15 over price3 9.36
## 190 16 over price3 9.36
## 191 17 over price3 9.36
## 192 18 over price3 9.36
## 193 19 over price3 9.36
## 194 20 over price3 9.36
## 195 21 over price3 9.36
## 196 22 over price3 9.36
## 197 23 over price3 9.36
## 198 24 over price3 9.36
## 199 25 over price3 9.36
## 200 26 over price3 9.36
## 201 27 over price3 9.36
## 202 28 over price3 9.36
## 203 29 over price3 9.36
## 204 30 over price3 9.36
## 205 31 under price3 8.64
## 206 32 under price3 8.64
## 207 33 under price3 8.64
## 208 34 under price3 8.64
## 209 35 under price3 8.64
## 210 36 under price3 8.64
## 211 37 under price3 8.64
## 212 38 under price3 8.64
## 213 39 under price3 8.64
## 214 40 under price3 8.64
## 215 41 under price3 8.64
## 216 42 under price3 8.64
## 217 43 under price3 8.64
## 218 44 under price3 8.64
## 219 45 under price3 8.64
## 220 46 under price3 8.64
## 221 47 under price3 8.64
## 222 48 under price3 8.64
## 223 49 under price3 8.64
## 224 50 under price3 8.64
## 225 51 under price3 8.64
## 226 52 under price3 8.64
## 227 53 under price3 8.64
## 228 54 under price3 8.64
## 229 55 under price3 8.64
## 230 56 under price3 8.64
## 231 57 under price3 8.64
## 232 58 under price3 8.64
## 233 59 rounded price3 9.00
## 234 60 rounded price3 9.00
## 235 61 rounded price3 9.00
## 236 62 rounded price3 9.00
## 237 63 rounded price3 9.00
## 238 64 rounded price3 9.00
## 239 65 rounded price3 9.00
## 240 66 rounded price3 9.00
## 241 67 rounded price3 9.00
## 242 68 rounded price3 9.00
## 243 69 rounded price3 9.00
## 244 70 rounded price3 9.00
## 245 71 rounded price3 9.00
## 246 72 rounded price3 9.00
## 247 73 rounded price3 9.00
## 248 74 rounded price3 9.00
## 249 75 rounded price3 9.00
## 250 76 rounded price3 9.00
## 251 77 rounded price3 9.00
## 252 78 rounded price3 9.00
## 253 79 rounded price3 9.00
## 254 80 rounded price3 9.00
## 255 81 rounded price3 9.00
## 256 82 rounded price3 9.00
## 257 83 rounded price3 9.00
## 258 84 rounded price3 9.00
## 259 85 rounded price3 9.00
## 260 86 rounded price3 9.00
## 261 87 rounded price3 9.00
## 262 1 over dogCost 2300.00
## 263 2 over dogCost 2450.00
## 264 3 over dogCost 800.00
## 265 4 over dogCost 2000.00
## 266 5 over dogCost 2000.00
## 267 6 over dogCost 1600.00
## 268 7 over dogCost 1750.00
## 269 8 over dogCost 2200.00
## 270 9 over dogCost 2000.00
## 271 10 over dogCost 1000.00
## 272 11 over dogCost 1600.00
## 273 12 over dogCost 2250.00
## 274 13 over dogCost 2000.00
## 275 14 over dogCost 2000.00
## 276 15 over dogCost 2200.00
## 277 16 over dogCost 2200.00
## 278 17 over dogCost 1000.00
## 279 18 over dogCost 2250.00
## 280 19 over dogCost 1749.00
## 281 20 over dogCost 1850.00
## 282 21 over dogCost 2500.00
## 283 22 over dogCost 2000.00
## 284 23 over dogCost 1500.00
## 285 24 over dogCost 2250.00
## 286 25 over dogCost 1500.00
## 287 26 over dogCost 1875.00
## 288 27 over dogCost 2000.00
## 289 28 over dogCost 1800.00
## 290 29 over dogCost 2000.00
## 291 30 over dogCost 2325.00
## 292 31 under dogCost 1000.00
## 293 32 under dogCost 2000.00
## 294 33 under dogCost 2192.00
## 295 34 under dogCost 2000.00
## 296 35 under dogCost 2000.00
## 297 36 under dogCost 2100.00
## 298 37 under dogCost 2299.00
## 299 38 under dogCost 2100.00
## 300 39 under dogCost 2292.00
## 301 40 under dogCost 2482.00
## 302 41 under dogCost 1500.00
## 303 42 under dogCost 2200.00
## 304 43 under dogCost 1500.00
## 305 44 under dogCost 1900.00
## 306 45 under dogCost 2000.00
## 307 46 under dogCost 2200.00
## 308 47 under dogCost 1500.00
## 309 48 under dogCost 1900.00
## 310 49 under dogCost 2200.00
## 311 50 under dogCost 2000.00
## 312 51 under dogCost 1990.00
## 313 52 under dogCost 2000.00
## 314 53 under dogCost 1750.00
## 315 54 under dogCost 1790.00
## 316 55 under dogCost 2000.00
## 317 56 under dogCost 500.00
## 318 57 under dogCost 2000.00
## 319 58 under dogCost 2000.00
## 320 59 rounded dogCost 2300.00
## 321 60 rounded dogCost 2000.00
## 322 61 rounded dogCost 2200.00
## 323 62 rounded dogCost 1900.00
## 324 63 rounded dogCost 1000.00
## 325 64 rounded dogCost 1700.00
## 326 65 rounded dogCost 2400.00
## 327 66 rounded dogCost 1700.00
## 328 67 rounded dogCost 2000.00
## 329 68 rounded dogCost 1800.00
## 330 69 rounded dogCost 2000.00
## 331 70 rounded dogCost 2000.00
## 332 71 rounded dogCost 2450.00
## 333 72 rounded dogCost 2300.00
## 334 73 rounded dogCost 2000.00
## 335 74 rounded dogCost 1000.00
## 336 75 rounded dogCost 1950.00
## 337 76 rounded dogCost 2000.00
## 338 77 rounded dogCost 2000.00
## 339 78 rounded dogCost 500.00
## 340 79 rounded dogCost 1500.00
## 341 80 rounded dogCost 2000.00
## 342 81 rounded dogCost 1000.00
## 343 82 rounded dogCost 2200.00
## 344 83 rounded dogCost 2000.00
## 345 84 rounded dogCost 2350.00
## 346 85 rounded dogCost 2000.00
## 347 86 rounded dogCost 1900.00
## 348 87 rounded dogCost 2499.99
## 349 1 over plasmaCost 4800.00
## 350 2 over plasmaCost 4850.00
## 351 3 over plasmaCost 1200.00
## 352 4 over plasmaCost 4200.00
## 353 5 over plasmaCost 4500.00
## 354 6 over plasmaCost 4600.00
## 355 7 over plasmaCost 4650.00
## 356 8 over plasmaCost 4800.00
## 357 9 over plasmaCost 4500.00
## 358 10 over plasmaCost 3000.00
## 359 11 over plasmaCost 4578.00
## 360 12 over plasmaCost 4999.00
## 361 13 over plasmaCost 4000.00
## 362 14 over plasmaCost 4500.00
## 363 15 over plasmaCost 4500.00
## 364 16 over plasmaCost 4700.00
## 365 17 over plasmaCost 5000.00
## 366 18 over plasmaCost 4899.00
## 367 19 over plasmaCost 3499.00
## 368 20 over plasmaCost 4999.99
## 369 21 over plasmaCost 4999.00
## 370 22 over plasmaCost 4500.00
## 371 23 over plasmaCost 3200.00
## 372 24 over plasmaCost 4500.00
## 373 25 over plasmaCost 3000.00
## 374 26 over plasmaCost 4699.00
## 375 27 over plasmaCost 4540.00
## 376 28 over plasmaCost 3800.00
## 377 29 over plasmaCost 4000.00
## 378 30 over plasmaCost 4997.00
## 379 31 under plasmaCost 2500.00
## 380 32 under plasmaCost 2500.00
## 381 33 under plasmaCost 4888.00
## 382 34 under plasmaCost 4400.00
## 383 35 under plasmaCost 4500.00
## 384 36 under plasmaCost 4300.00
## 385 37 under plasmaCost 4500.00
## 386 38 under plasmaCost 3500.00
## 387 39 under plasmaCost 4888.00
## 388 40 under plasmaCost 4968.00
## 389 41 under plasmaCost 3000.00
## 390 42 under plasmaCost 4000.00
## 391 43 under plasmaCost 4000.00
## 392 44 under plasmaCost 4700.00
## 393 45 under plasmaCost 4500.00
## 394 46 under plasmaCost 4750.00
## 395 47 under plasmaCost 2500.00
## 396 48 under plasmaCost 4120.00
## 397 49 under plasmaCost 4900.00
## 398 50 under plasmaCost 4000.00
## 399 51 under plasmaCost 3250.00
## 400 52 under plasmaCost 4000.00
## 401 53 under plasmaCost 3500.00
## 402 54 under plasmaCost 4350.00
## 403 55 under plasmaCost 3200.00
## 404 56 under plasmaCost 4500.00
## 405 57 under plasmaCost 4800.00
## 406 58 under plasmaCost 3500.00
## 407 59 rounded plasmaCost 4500.00
## 408 60 rounded plasmaCost 4500.00
## 409 61 rounded plasmaCost 4500.00
## 410 62 rounded plasmaCost 3500.00
## 411 63 rounded plasmaCost 2500.00
## 412 64 rounded plasmaCost 4495.00
## 413 65 rounded plasmaCost 4849.00
## 414 66 rounded plasmaCost 3500.00
## 415 67 rounded plasmaCost 4000.00
## 416 68 rounded plasmaCost 1500.00
## 417 69 rounded plasmaCost 4200.00
## 418 70 rounded plasmaCost 2999.00
## 419 71 rounded plasmaCost 4995.00
## 420 72 rounded plasmaCost 4700.00
## 421 73 rounded plasmaCost 4300.00
## 422 74 rounded plasmaCost 3500.00
## 423 75 rounded plasmaCost 4675.00
## 424 76 rounded plasmaCost 4000.00
## 425 77 rounded plasmaCost 4500.00
## 426 78 rounded plasmaCost 4500.00
## 427 79 rounded plasmaCost 4500.00
## 428 80 rounded plasmaCost 4700.00
## 429 81 rounded plasmaCost 2000.00
## 430 82 rounded plasmaCost 4700.00
## 431 83 rounded plasmaCost 4000.00
## 432 84 rounded plasmaCost 4750.00
## 433 85 rounded plasmaCost 4000.00
## 434 86 rounded plasmaCost 4800.00
## 435 87 rounded plasmaCost 4995.00
## 436 1 over sushiCost 8.70
## 437 2 over sushiCost 9.00
## 438 3 over sushiCost 8.00
## 439 4 over sushiCost 9.00
## 440 5 over sushiCost 8.50
## 441 6 over sushiCost 8.00
## 442 7 over sushiCost 6.95
## 443 8 over sushiCost 8.00
## 444 9 over sushiCost 8.99
## 445 10 over sushiCost 9.00
## 446 11 over sushiCost 8.50
## 447 12 over sushiCost 8.50
## 448 13 over sushiCost NA
## 449 14 over sushiCost 8.50
## 450 15 over sushiCost 8.00
## 451 16 over sushiCost 8.00
## 452 17 over sushiCost 7.75
## 453 18 over sushiCost 8.00
## 454 19 over sushiCost 8.99
## 455 20 over sushiCost 7.99
## 456 21 over sushiCost 9.30
## 457 22 over sushiCost 8.50
## 458 23 over sushiCost 7.35
## 459 24 over sushiCost 8.50
## 460 25 over sushiCost 8.00
## 461 26 over sushiCost 7.89
## 462 27 over sushiCost 8.95
## 463 28 over sushiCost 7.00
## 464 29 over sushiCost 8.50
## 465 30 over sushiCost 8.99
## 466 31 under sushiCost 7.50
## 467 32 under sushiCost 7.80
## 468 33 under sushiCost 7.50
## 469 34 under sushiCost 7.99
## 470 35 under sushiCost 8.00
## 471 36 under sushiCost 7.99
## 472 37 under sushiCost 7.80
## 473 38 under sushiCost 6.99
## 474 39 under sushiCost 7.50
## 475 40 under sushiCost 8.46
## 476 41 under sushiCost 7.50
## 477 42 under sushiCost 6.99
## 478 43 under sushiCost 7.99
## 479 44 under sushiCost 7.99
## 480 45 under sushiCost 6.99
## 481 46 under sushiCost 7.50
## 482 47 under sushiCost 7.58
## 483 48 under sushiCost 7.75
## 484 49 under sushiCost 8.00
## 485 50 under sushiCost 7.56
## 486 51 under sushiCost 7.75
## 487 52 under sushiCost 7.99
## 488 53 under sushiCost 7.99
## 489 54 under sushiCost 7.50
## 490 55 under sushiCost 8.50
## 491 56 under sushiCost 7.99
## 492 57 under sushiCost 8.00
## 493 58 under sushiCost 7.69
## 494 59 rounded sushiCost 8.00
## 495 60 rounded sushiCost 8.49
## 496 61 rounded sushiCost 8.00
## 497 62 rounded sushiCost 7.50
## 498 63 rounded sushiCost 6.95
## 499 64 rounded sushiCost 7.50
## 500 65 rounded sushiCost 8.69
## 501 66 rounded sushiCost 8.00
## 502 67 rounded sushiCost 8.00
## 503 68 rounded sushiCost 8.00
## 504 69 rounded sushiCost 8.00
## 505 70 rounded sushiCost 7.00
## 506 71 rounded sushiCost 8.95
## 507 72 rounded sushiCost 7.50
## 508 73 rounded sushiCost 8.25
## 509 74 rounded sushiCost 8.00
## 510 75 rounded sushiCost 7.89
## 511 76 rounded sushiCost 7.75
## 512 77 rounded sushiCost 6.50
## 513 78 rounded sushiCost 8.00
## 514 79 rounded sushiCost 7.00
## 515 80 rounded sushiCost 8.50
## 516 81 rounded sushiCost 7.50
## 517 82 rounded sushiCost 8.00
## 518 83 rounded sushiCost 8.50
## 519 84 rounded sushiCost 8.25
## 520 85 rounded sushiCost 8.50
## 521 86 rounded sushiCost 8.50
## 522 87 rounded sushiCost 8.99
d.wide <- d.gathered %>%
spread(Type, Value)
d.wide <- d.wide[c(1:2, 5:7, 3:4, 8)]
print(d.wide)
## id condition price1 price2 price3 dogCost plasmaCost sushiCost
## 1 1 over 5012 2508 9.36 2300.00 4800.00 8.70
## 2 2 over 5012 2508 9.36 2450.00 4850.00 9.00
## 3 3 over 5012 2508 9.36 800.00 1200.00 8.00
## 4 4 over 5012 2508 9.36 2000.00 4200.00 9.00
## 5 5 over 5012 2508 9.36 2000.00 4500.00 8.50
## 6 6 over 5012 2508 9.36 1600.00 4600.00 8.00
## 7 7 over 5012 2508 9.36 1750.00 4650.00 6.95
## 8 8 over 5012 2508 9.36 2200.00 4800.00 8.00
## 9 9 over 5012 2508 9.36 2000.00 4500.00 8.99
## 10 10 over 5012 2508 9.36 1000.00 3000.00 9.00
## 11 11 over 5012 2508 9.36 1600.00 4578.00 8.50
## 12 12 over 5012 2508 9.36 2250.00 4999.00 8.50
## 13 13 over 5012 2508 9.36 2000.00 4000.00 NA
## 14 14 over 5012 2508 9.36 2000.00 4500.00 8.50
## 15 15 over 5012 2508 9.36 2200.00 4500.00 8.00
## 16 16 over 5012 2508 9.36 2200.00 4700.00 8.00
## 17 17 over 5012 2508 9.36 1000.00 5000.00 7.75
## 18 18 over 5012 2508 9.36 2250.00 4899.00 8.00
## 19 19 over 5012 2508 9.36 1749.00 3499.00 8.99
## 20 20 over 5012 2508 9.36 1850.00 4999.99 7.99
## 21 21 over 5012 2508 9.36 2500.00 4999.00 9.30
## 22 22 over 5012 2508 9.36 2000.00 4500.00 8.50
## 23 23 over 5012 2508 9.36 1500.00 3200.00 7.35
## 24 24 over 5012 2508 9.36 2250.00 4500.00 8.50
## 25 25 over 5012 2508 9.36 1500.00 3000.00 8.00
## 26 26 over 5012 2508 9.36 1875.00 4699.00 7.89
## 27 27 over 5012 2508 9.36 2000.00 4540.00 8.95
## 28 28 over 5012 2508 9.36 1800.00 3800.00 7.00
## 29 29 over 5012 2508 9.36 2000.00 4000.00 8.50
## 30 30 over 5012 2508 9.36 2325.00 4997.00 8.99
## 31 31 under 4988 2492 8.64 1000.00 2500.00 7.50
## 32 32 under 4988 2492 8.64 2000.00 2500.00 7.80
## 33 33 under 4988 2492 8.64 2192.00 4888.00 7.50
## 34 34 under 4988 2492 8.64 2000.00 4400.00 7.99
## 35 35 under 4988 2492 8.64 2000.00 4500.00 8.00
## 36 36 under 4988 2492 8.64 2100.00 4300.00 7.99
## 37 37 under 4988 2492 8.64 2299.00 4500.00 7.80
## 38 38 under 4988 2492 8.64 2100.00 3500.00 6.99
## 39 39 under 4988 2492 8.64 2292.00 4888.00 7.50
## 40 40 under 4988 2492 8.64 2482.00 4968.00 8.46
## 41 41 under 4988 2492 8.64 1500.00 3000.00 7.50
## 42 42 under 4988 2492 8.64 2200.00 4000.00 6.99
## 43 43 under 4988 2492 8.64 1500.00 4000.00 7.99
## 44 44 under 4988 2492 8.64 1900.00 4700.00 7.99
## 45 45 under 4988 2492 8.64 2000.00 4500.00 6.99
## 46 46 under 4988 2492 8.64 2200.00 4750.00 7.50
## 47 47 under 4988 2492 8.64 1500.00 2500.00 7.58
## 48 48 under 4988 2492 8.64 1900.00 4120.00 7.75
## 49 49 under 4988 2492 8.64 2200.00 4900.00 8.00
## 50 50 under 4988 2492 8.64 2000.00 4000.00 7.56
## 51 51 under 4988 2492 8.64 1990.00 3250.00 7.75
## 52 52 under 4988 2492 8.64 2000.00 4000.00 7.99
## 53 53 under 4988 2492 8.64 1750.00 3500.00 7.99
## 54 54 under 4988 2492 8.64 1790.00 4350.00 7.50
## 55 55 under 4988 2492 8.64 2000.00 3200.00 8.50
## 56 56 under 4988 2492 8.64 500.00 4500.00 7.99
## 57 57 under 4988 2492 8.64 2000.00 4800.00 8.00
## 58 58 under 4988 2492 8.64 2000.00 3500.00 7.69
## 59 59 rounded 5000 2500 9.00 2300.00 4500.00 8.00
## 60 60 rounded 5000 2500 9.00 2000.00 4500.00 8.49
## 61 61 rounded 5000 2500 9.00 2200.00 4500.00 8.00
## 62 62 rounded 5000 2500 9.00 1900.00 3500.00 7.50
## 63 63 rounded 5000 2500 9.00 1000.00 2500.00 6.95
## 64 64 rounded 5000 2500 9.00 1700.00 4495.00 7.50
## 65 65 rounded 5000 2500 9.00 2400.00 4849.00 8.69
## 66 66 rounded 5000 2500 9.00 1700.00 3500.00 8.00
## 67 67 rounded 5000 2500 9.00 2000.00 4000.00 8.00
## 68 68 rounded 5000 2500 9.00 1800.00 1500.00 8.00
## 69 69 rounded 5000 2500 9.00 2000.00 4200.00 8.00
## 70 70 rounded 5000 2500 9.00 2000.00 2999.00 7.00
## 71 71 rounded 5000 2500 9.00 2450.00 4995.00 8.95
## 72 72 rounded 5000 2500 9.00 2300.00 4700.00 7.50
## 73 73 rounded 5000 2500 9.00 2000.00 4300.00 8.25
## 74 74 rounded 5000 2500 9.00 1000.00 3500.00 8.00
## 75 75 rounded 5000 2500 9.00 1950.00 4675.00 7.89
## 76 76 rounded 5000 2500 9.00 2000.00 4000.00 7.75
## 77 77 rounded 5000 2500 9.00 2000.00 4500.00 6.50
## 78 78 rounded 5000 2500 9.00 500.00 4500.00 8.00
## 79 79 rounded 5000 2500 9.00 1500.00 4500.00 7.00
## 80 80 rounded 5000 2500 9.00 2000.00 4700.00 8.50
## 81 81 rounded 5000 2500 9.00 1000.00 2000.00 7.50
## 82 82 rounded 5000 2500 9.00 2200.00 4700.00 8.00
## 83 83 rounded 5000 2500 9.00 2000.00 4000.00 8.50
## 84 84 rounded 5000 2500 9.00 2350.00 4750.00 8.25
## 85 85 rounded 5000 2500 9.00 2000.00 4000.00 8.50
## 86 86 rounded 5000 2500 9.00 1900.00 4800.00 8.50
## 87 87 rounded 5000 2500 9.00 2499.99 4995.00 8.99
summarise(d.tidy, mean = mean(dogCost, na.rm = TRUE))
## mean
## 1 1896.483
summarise(d.tidy, mean = mean(sushiCost, na.rm = TRUE))
## mean
## 1 8.009884
d.raw <- read.csv("janiszewski_rep_exercise.csv")
d.unique.subs <- distinct(d.raw, WorkerId)
d.tidy <- d %>%
select(WorkerId, Input.condition,
starts_with("Answer"),
starts_with("Input")) %>%
rename(workerid = WorkerId,
condition = Input.condition,
plasma_anchor = Input.price1,
dog_anchor = Input.price2,
sushi_anchor = Input.price3,
dog_cost = Answer.dog_cost,
plasma_cost = Answer.plasma_cost,
sushi_cost = Answer.sushi_cost) %>%
gather(name, cost,
dog_anchor, plasma_anchor, sushi_anchor,
dog_cost, plasma_cost, sushi_cost) %>%
separate(name, c("item", "type"), "_") %>%
spread(type, cost)
pcts <- d.tidy %>%
mutate(pct_change = abs((anchor-cost) / anchor)) %>%
group_by(condition) %>%
group_by(item, add = TRUE) %>%
summarize(pct_change=mean(pct_change, na.rm = TRUE))
z.scores <- d.tidy %>%
group_by(item) %>%
mutate(z=scale(cost)[,1]) %>%
group_by(condition, add = TRUE) %>%
summarize(z=mean(z, na.rm = TRUE))
qplot(item, pct_change, fill=condition,
position="dodge",
stat="identity", geom="bar",
data=pcts)
qplot(item, z, fill=condition,
position="dodge",
stat="identity", geom="bar",
data=z.scores)