Spreadsheet: 555777d1515754073-challenging-issue-detect-outliers-in-a-column-with-multiple-groups-of-data-outliers
Sheet: Sheet1

Country | Value | IsOutlier | IsFarOut |  | k(outlier) | 1.5 |  | Country | Q1 | Q3 | IQR | Min(outlier) | Max(outlier) | Min(farout) | Max(farout)
Afghanistan | 1209 |  |  |  | k(far out) | 3 |  | Afghanistan
Afghanistan | 300 |  |  |  |  |  |  | Albania
Afghanistan | 214 |  |  |  |  |  |  | Algeria
Afghanistan | 134 |  |  |  |  |  |  | Andorra
Afghanistan | 95 |  |  |  |  |  |  | Angola
Afghanistan | 64 |  |  |  |  |  |  | Anguilla
Afghanistan | 50 |  |  |  |  |  |  | [NAME] and [NAME]
Afghanistan | 48 |  |  |  |  |  |  | Argentina
Afghanistan | 48
Afghanistan | 44
Afghanistan | 44
Afghanistan | 38
Afghanistan | 36
Afghanistan | 31
Afghanistan | 29
Afghanistan | 29
Afghanistan | 29
Afghanistan | 28
Afghanistan | 25
Afghanistan | 24
Afghanistan | 22
Afghanistan | 22
Afghanistan | 21
Afghanistan | 20
Afghanistan | 20
Afghanistan | 16
Afghanistan | 15
Afghanistan | 14
Afghanistan | 13
Afghanistan | 13
Afghanistan | 13
Afghanistan | 13
Afghanistan | 13
Afghanistan | 12
Afghanistan | 12
Afghanistan | 12
Afghanistan | 11
Afghanistan | 9
Afghanistan | 9
Afghanistan | 8
Afghanistan | 7
Afghanistan | 7
Afghanistan | 6
Afghanistan | 4
Afghanistan | 4
Afghanistan | 3
Afghanistan | 2
Afghanistan | 1
Afghanistan | 1
Afghanistan | 1
Albania | 352
Albania | 351
Albania | 245
Albania | 240
Albania | 168
Albania | 166
Albania | 161
Albania | 147
Albania | 141
Albania | 138
Albania | 133
Albania | 127
Albania | 101
Albania | 94
Albania | 83
Albania | 78
Albania | 71
Albania | 61
Albania | 54
Albania | 44
Albania | 39
Albania | 16
Algeria | 1882
Algeria | 726
Algeria | 646
Algeria | 528
Algeria | 524
Algeria | 517
Algeria | 498
Algeria | 427
Algeria | 422
Algeria | 372
Algeria | 361
Algeria | 319
Algeria | 303
Algeria | 298
Algeria | 290
Algeria | 288
Algeria | 268
Algeria | 267
Algeria | 239
Algeria | 238
Algeria | 238
Algeria | 231
Algeria | 231
Algeria | 222
Algeria | 217
Algeria | 216
Algeria | 209
Algeria | 191
Algeria | 176
Algeria | 174
Algeria | 166
Algeria | 164
Algeria | 163
Algeria | 162
Algeria | 147
Algeria | 139
Algeria | 131
Algeria | 122
Algeria | 121
Algeria | 120
Algeria | 119
Algeria | 119
Algeria | 115
Algeria | 111
Algeria | 106
Algeria | 105
Algeria | 103
Algeria | 98
Algeria | 94
Algeria | 93
Algeria | 88
Algeria | 87
Algeria | 85
Algeria | 82
Algeria | 78
Algeria | 78
Algeria | 69
Algeria | 64
Algeria | 63
Algeria | 62
Algeria | 60
Algeria | 59
Algeria | 59
Algeria | 56
Algeria | 40
Algeria | 9
Andorra | 264
Angola | 234
Angola | 100
Angola | 58
Angola | 52
Angola | 49
Angola | 44
Angola | 37
Angola | 28
Angola | 28
Angola | 27
Angola | 27
Angola | 20
Angola | 10
Angola | 10
Angola | 9
Angola | 3
Anguilla | 191
[NAME] and [NAME] | 557
[NAME] and [NAME] | 268
Argentina | 9495
Argentina | 7807
Argentina | 4206
Argentina | 2875
Argentina | 2812
Argentina | 2753
Argentina | 2645
Argentina | 1798
Argentina | 1780
Argentina | 1768
Argentina | 1750
Argentina | 1711
Argentina | 1618
Argentina | 1538
Argentina | 1475
Argentina | 1246
Argentina | 1178
Argentina | 1178
Argentina | 1168
Argentina | 1111
Argentina | 1032
Argentina | 1030
Argentina | 1028
Argentina | 1017
Argentina | 941
Argentina | 922
Argentina | 920
Argentina | 903
Argentina | 892
Argentina | 825
Argentina | 768
Argentina | 767
Argentina | 764
Argentina | 759
Argentina | 742
Argentina | 697
Argentina | 679
Argentina | 648
Argentina | 628
Argentina | 613
Argentina | 596
Argentina | 595
Argentina | 515
Argentina | 512
Argentina | 507
Argentina | 506
Argentina | 487
Argentina | 465
Argentina | 460
Argentina | 446
Argentina | 438
Argentina | 432
Argentina | 406