Spreadsheet: 810059d1671521379-finding-product-prices-with-criteria-task3-ans
Sheet: Data

Product code | Sales in unit | Product price in local curling | Product cost | Product name | Mark | Segment | Product price in euros | Product sales volume in euros |  | Euro exchange rate for the local currency: | 4.9
103664 | 2704 | 99 | 16
10672 | 1566 | 59.98722860791826 | 6.660312899106002 |  |  |  |  |  |  |  | Lowest Cost |  |  | Highest cost
10673 | 1071 | 58.22595704948646 | 6.647208216619982 |  |  |  |  |  |  |  | Product name | Mark | Product cost | Product name | Mark | Product cost
10674 | 5280 | 78.67244318181818 | 6.922674242424242 |  |  |  |  |  |  | Lipstick
10675 | 4000 | 62.6885 | 6.767595
10676 | 1111 | 59.36903690369037 | 6.679252925292529
10682 | 201 | 86.92039800995025 | 7.296766169154229
10684 | 1124 | 61.19395017793595 | 7.311975088967971
10685 | 798 | 59.12280701754386 | 7.221441102756892
10686 | 957 | 57.85788923719958 | 7.201243469174504
10687 | 815 | 60.30429447852761 | 7.276196319018405
10689 | 151 | 72.7748344370861 | 7.287615894039735
10691 | 411 | 58.01459854014598 | 7.226301703163018
10738 | 426 | 75.88262910798122 | 5.367887323943662
10782 | 14845 | 92.67547995958235 | 5.643675311552712
10783 | 2307 | 93.50845253576072 | 5.720676202860858
10784 | 1094 | 93.93692870201097 | 5.723308957952468
10851 | 885 | 63.07683615819209 | 7.804474576271186
10852 | 382 | 61.72251308900523 | 7.821151832460733
10853 | 203 | 64.50738916256158 | 7.762758620689655
10854 | 458 | 62.86026200873363 | 7.705458515283842
10855 | 315 | 62.46666666666667 | 7.841777777777778
10856 | 214 | 65.07476635514018 | 6.936448598130841
10857 | 33 | 66.0909090909091 | 7.81
10858 | 785 | 61.3515923566879 | 8.141885350318471
10859 | 16 | 62.25 | 6.51
10860 | 731 | 54.79753761969904 | 7.396142270861833
11282 | 433 | 93.12471131639722 | 8.831224018475751
11283 | 657 | 91.72450532724505 | 8.825479452054795
11491 | 508 | 68.98622047244095 | 11.53584645669291
11492 | 987 | 68.69807497467072 | 11.59208713272543
11493 | 655 | 68.7206106870229 | 11.56097709923664
11494 | 239 | 69.19246861924687 | 11.47903765690377
11495 | 367 | 68.86103542234332 | 11.53016348773842
11697 | 162 | 74.28395061728395 | 5.939876543209876
12121 | 1192 | 46.34060402684564 | 6.510008389261746
12124 | 1525 | 49.1127868852459 | 6.643383606557377
12125 | 1224 | 45.75245098039215 | 6.484395424836601
12128 | 962 | 48.03846153846154 | 6.537796257796257
12129 | 591 | 46.69204737732657 | 6.48005076142132
12130 | 1170 | 47.77863247863248 | 6.50617094017094
12131 | 843 | 47.13760379596678 | 6.490498220640569
12133 | 665 | 46.67218045112782 | 6.509744360902255
12135 | 1572 | 43.62595419847328 | 6.394306615776082
12137 | 1107 | 45.06955736224029 | 6.412050587172539
12139 | 1234 | 45.13371150729336 | 6.447260940032415
12140 | 842 | 48.86342042755344 | 6.49457244655582
12141 | 1130 | 47.79469026548673 | 6.45424778761062
12142 | 333 | 58.05705705705706 | 7.136666666666668
12143 | 1592 | 46.26884422110552 | 6.481143216080402
12286 | 3712 | 52.45959051724138 | 6.248176185344827
12404 | 4079 | 83.74528070605541 | 5.295381220887473
12405 | 826 | 83.62832929782083 | 4.868232445520581
12406 | 791 | 85.98230088495575 | 4.942907711757269
12426 | 1137 | 94.65523306948108 | 11.81720316622691
12427 | 455 | 95.34285714285714 | 11.88404395604396
12428 | 538 | 95.14498141263941 | 11.75007434944238
12429 | 240 | 97.3 | 11.81208333333333
12431 | 642 | 95.57009345794393 | 11.77613707165109
12620 | 197 | 102.6751269035533 | 12.6005076142132
12621 | 63 | 108.031746031746 | 12.55238095238095
12622 | 94 | 94.69148936170212 | 12.50893617021277
12623 | 110 | 109.0545454545454 | 12.61181818181818
12790 | 925 | 86.34486486486486 | 9.626194594594594
12791 | 566 | 85.83568904593639 | 9.587067137809187
12892 | 405 | 100.7012345679012 | 10.42683950617284
12893 | 253 | 98.84584980237155 | 10.41644268774704
12894 | 359 | 97.35933147632312 | 10.31381615598886
12913 | 804 | 49 | 6.7
12917 | 1059 | 49.06704438149198 | 6.7
12943 | 487 | 130.4086242299795 | 11.57546201232033
12944 | 2354 | 131.1733220050977 | 11.42251486830926
12962 | 574 | 39 | 10
13413 | 669 | 76.61733931240657 | 4.80896860986547
13609 | 585 | 69.47863247863248 | 5.092547008547008
13614 | 1317 | 67.79043280182232 | 4.866818526955202
13615 | 1039 | 43.54475457170356 | 3.074071222329163
13628 | 1774 | 74.73562570462232 | 4.456386696730553
13774 | 1489 | 74.2048354600403 | 5.635782404298187
13827 | 189 | 74.01587301587301 | 6.445238095238095
13828 | 143 | 74.87412587412588 | 6.430769230769231
13829 | 152 | 74.5 | 6.396381578947368
13830 | 109 | 74.70642201834862 | 6.442201834862386
13831 | 75 | 75.26666666666667 | 6.374000000000001
13832 | 142 | 72.4225352112676 | 6.114788732394365
13833 | 79 | 73.78481012658227 | 6.289240506329114
13834 | 116 | 77.22413793103448 | 6.302155172413793
13864 | 2956 | 50.68538565629229 | 6.416769282814615
13875 | 7051 | 51.81761452276273 | 5.758191745851652
13877 | 1333 | 49 | 6.5
13907 | 130 | 83.37692307692308 | 8.92876923076923
13908 | 119 | 77.84033613445378 | 9.028823529411765
13909 | 704 | 78.57244318181819 | 8.89565340909091
13910 | 141 | 82.43971631205673 | 8.955673758865249
13911 | 200 | 78.86 | 8.92735
13912 | 184 | 80.40217391304348 | 8.942934782608695
13913 | 94 | 86.51063829787235 | 9.059042553191489
13914 | 221 | 79.67873303167421 | 8.923800904977377
13957 | 960 | 57.440625 | 5.417104166666666
13958 | 395 | 57.50886075949367 | 2.042227848101266
13959 | 347 | 56.89337175792507 | 5.349193083573487
13960 | 596 | 56.05872483221476 | 5.390687919463087
13966 | 5021 | 99.07906791475801 | 5.163939454291974
13967 | 623 | 103.1444622792937 | 5.179261637239165
13968 | 574 | 104.3588850174216 | 5.192543554006969
14157 | 116 | 43.62068965517241 | 3.35
14158 | 337 | 32.80415430267063 | 3.539169139465876
14159 | 416 | 31.37740384615385 | 3.564543269230769
14160 | 651 | 32.35483870967742 | 3.535483870967742
14264 | 485 | 19 | 5.7
14265 | 580 | 19 | 5.8
14266 | 520 | 19.05961538461538 | 5.7
14348 | 564 | 56.8386524822695 | 9.015
14349 | 678 | 55.54867256637168 | 9.074867256637168
14350 | 1095 | 55.73607305936073 | 9.060054794520548
14351 | 1529 | 55.5297580117724 | 9.080575539568345
14352 | 299 | 55.32775919732441 | 9.049030100334448
14353 | 897 | 56.61928651059086 | 9.068896321070234
14368 | 1855 | 49 | 4.8
14745 | 221 | 92.3076923076923 | 10.98307692307692
14746 | 93 | 90.38709677419355 | 11.07096774193548
14747 | 96 | 92.4375 | 10.97916666666667
14748 | 161 | 94.13664596273291 | 11.09366459627329
14749 | 157 | 92.08917197452229 | 11.01617834394904
14750 | 312 | 87.57371794871794 | 10.95294871794872
14751 | 216 | 92.93518518518519 | 11.00712962962963
14752 | 162 | 93.54320987654322 | 10.94530864197531
14753 | 204 | 89.69117647058823 | 10.97392156862745
14754 | 251 | 85.26294820717132 | 10.81107569721116
14755 | 111 | 94.24324324324324 | 11.03135135135135
14756 | 184 | 94.86413043478261 | 11.06913043478261
14782 | 76 | 113.5263157894737 | 12.72421052631579
14935 | 532 | 95.15789473684211 | 11.77443609022556
15027 | 1834 | 92.32933478735005 | 6.873484187568157
15040 | 370 | 98.01351351351352 | 9.218918918918918
15041 | 145 | 94.12413793103448 | 9.209379310344827
15042 | 180 | 94.66666666666667 | 9.199611111111112
15043 | 396 | 97.38131313131314 | 8.996515151515151
15044 | 155 | 96.52258064516128 | 9.058387096774194
15045 | 319 | 96.0564263322884 | 9.037366771159874
15046 | 210 | 94.86666666666666 | 9.108619047619047
15047 | 437 | 95.5629290617849 | 9.195194508009154
15048 | 220 | 95.34545454545454 | 9.2865
15049 | 316 | 94.9873417721519 | 9.07389240506329
15052 | 3271 | 105.7230204830327 | 5.015273616630999
15053 | 655 | 100.1114503816794 | 5.06406106870229
15057 | 2016 | 94.60912698412699 | 10.39130952380952
15058 | 1906 | 95.60020986358867 | 10.58073452256034
15080 | 855 | 60.21929824561403 | 6.188842105263158
15081 | 601 | 58.85357737104825 | 6.198702163061564
15082 | 789 | 60.92965779467681 | 6.20467680608365
15083 | 1432 | 61.59567039106145 | 6.253317039106145
15084 | 1461 | 60.35181382614648 | 6.212381930184805
15090 | 2027 | 61.52491366551554 | 10.0472422298964
15091 | 1571 | 67.43220878421387 | 9.791343093570974
15092 | 605 | 67.55537190082644 | 9.998545454545454
15093 | 747 | 67.28781793842035 | 10.00322623828648
15094 | 1351 | 66.73131014063657 | 10.02969652109549
15148 | 263 | 79.59695817490494 | 8.29
15149 | 198 | 80.5 | 8.290000000000001
15150 | 291 | 78.93127147766323 | 8.29
15151 | 549 | 79.25865209471768 | 8.290000000000001
15152 | 213 | 79.66666666666667 | 8.29
15153 | 1048 | 79.1135496183206 | 8.290000000000001
15154 | 325 | 79.54153846153847 | 8.29
15155 | 326 | 79.35276073619632 | 8.29
15264 | 933 | 55.84030010718114 | 6.195176848874598
15267 | 708 | 55.24576271186441 | 6.222881355932204
15268 | 681 | 55.30249632892804 | 6.220484581497796
15283 | 33 | 54.24242424242424 | 5.399999999999999
15288 | 13 | 53.07692307692308 | 5.4
15289 | 126 | 54.8015873015873 | 5.399999999999999
15361 | 759 | 29 | 6.24
15362 | 427 | 29 | 6.24
15365 | 237 | 49 | 10.14
15366 | 400 | 49 | 10.14
15367 | 302 | 72.8841059602649 | 10.70003311258278
15382 | 231 | 125.6060606060606 | 10.79584415584416
15383 | 215 | 123.3348837209302 | 10.70525581395349
15384 | 239 | 124.5439330543933 | 10.49246861924686
15385 | 250 | 124.124 | 10.66016
15386 | 227 | 120.2378854625551 | 10.60008810572687
15387 | 221 | 122.8642533936652 | 10.68447963800905
15479 | 870 | 104.432183908046 | 12.4751724137931
15480 | 589 | 104.7487266553481 | 12.55704584040747