Load Library

library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(tidyr)
library(ggplot2)

Load dataset

library(VIM)
## Warning: package 'VIM' was built under R version 4.5.2
## Loading required package: colorspace
## Warning: package 'colorspace' was built under R version 4.5.2
## Loading required package: grid
## VIM is ready to use.
## Suggestions and bug-reports can be submitted at: https://github.com/statistikat/VIM/issues
## 
## Attaching package: 'VIM'
## The following object is masked from 'package:datasets':
## 
##     sleep
data(SBS5242)

Melihat sekilas dataset

SBS5242
##              PW       BWS_F       Umsatz         PERSA       BEZWD      BEZWDVK
## 1   43888.85242 35081.07414  3737.974701  1.181536e+04 37577.19455 379.05214852
## 2    1449.40170  1239.13170   120.099200  5.945795e+00  1251.43080   8.66535283
## 3    1009.61541   944.93722    79.832300  1.632859e+02   857.75827   4.29699940
## 4    1218.17072   942.29390   104.851729  1.901103e+00  1063.73052  20.49419522
## 5     517.36342   450.46195    41.326691  1.800600e+01   448.09227   2.05900450
## 6      67.19103    44.91809     5.003297 -6.017785e-01    62.71034  -0.26735109
## 7    1683.01369  1381.60557   140.964884  1.197439e+01  1438.19391  19.20824832
## 8    2141.84021  1551.84794   186.967366  3.979387e+01  1896.32869  18.19560084
## 9    1266.61864  1057.68366   102.961968  4.256255e+01  1098.48268   5.26108037
## 10   6757.11323  5884.14928   547.471849  7.198159e+02  5747.90534  30.35963125
## 11  23379.41700 19831.88225  1940.864549  4.400475e+03 19539.73335 155.39931345
## 12   5054.22294  4115.69411   428.828349  4.131865e+02  4224.77256  46.10729168
## 13    735.72447   526.02382    61.388670  5.533321e+01   669.19361   2.53395792
## 14  26787.13436 24420.46994  2183.108026  2.804922e+03 22315.43592 140.77744926
## 15    649.30901   306.82480   656.920908  2.726465e+03   344.71935   2.96667584
## 16    250.72888   115.69142   263.330279  9.928140e+01   135.83536   1.44510060
## 17   3033.95600  1636.26443  2993.268992  3.651849e+03  1504.69147  26.31191247
## 18    575.19520   292.04268   582.326772  3.674323e+02   306.58042   0.00000000
## 19   2044.55341   919.19590  2079.362114  8.393386e+02  1075.32455   0.00000000
## 20    157.98432    81.41603   156.380884  1.575902e+02    81.48733   1.10458519
## 21   1148.86446   597.80067           NA  1.946880e+02   599.81679   5.11078715
## 22    103.31120    51.20821   106.749849  2.120042e+00    51.80395   2.39758519
## 23   3510.47094  1953.56889  3452.478857  1.286976e+03  1752.80439  19.96923376
## 24   1043.95954   658.36606   982.350366  8.757901e+02   518.11647   5.77150646
## 25   1993.35367   867.79148  2130.065224  1.028322e+03  1063.04962  29.80573387
## 26    586.20178   313.49652   581.348704            NA   311.42142   0.00000000
## 27    465.18049   211.78419   481.925364  9.105599e+01   247.96987   6.67823091
## 28    421.55682   210.74124   420.890472  0.000000e+00   214.77625   0.00000000
## 29   2014.82140   985.55296  2026.082919  1.247017e+03  1060.59090  20.40385399
## 30   1267.54768   481.77008  1409.691605 -1.847834e-01   710.94231  18.16692005
## 31   2032.30160  1132.79545  1976.879427  3.424989e+03  1043.42461   9.74201656
## 32    147.91488    76.51618   140.467156  2.430171e+01    79.46220  -0.13232196
## 33   2544.78955  1353.56260  2497.204345  8.670647e+02  1274.67752   0.00000000
## 34    219.77420   124.33997   213.123947  2.433220e+00   111.73747   1.40822543
## 35   2500.56637  1240.94140  2514.065939  0.000000e+00  1337.09183   0.00000000
## 36    294.35280   153.84043   287.254359  4.659670e+01   157.26335   1.26855905
## 37     21.49817    10.21686    21.357157  0.000000e+00    10.42539  -0.52220387
## 38    332.71479   171.30424   331.077857  5.751168e+02          NA   2.40429716
## 39    716.40851   352.07722   730.058799  4.225417e+03   371.20513   6.01942868
## 40   4323.36091  2299.39987  4217.769122  5.183778e+03  2212.37261  33.72917029
## 41   2691.60009  1283.03634  2655.549350  9.413617e+03  1451.80268   0.00000000
## 42   2285.67599  1098.34425  2320.740068  0.000000e+00  1187.23461  21.67247739
## 43   3512.06017  1857.95120  3464.804301  3.103487e+02  1800.37428  14.31692036
## 44    675.20872   345.48384   687.088511  0.000000e+00   340.68830   9.25419987
## 45    365.13280   173.57087   380.210187  6.645529e+02   192.40268   0.00000000
## 46   6627.31070  3600.48559  6605.844485  7.316197e+03  3286.53743  94.13632118
## 47    411.67131   200.19430   409.650623  0.000000e+00   215.91402   0.00000000
## 48   2563.20795  1229.72738  2665.229544  0.000000e+00  1351.41998  33.47155034
## 49   4252.82220  2258.83248  4185.967134  2.074136e+04  2239.35739  27.41361132
## 50   3052.08775  1611.55899  3006.160086  5.423118e+03  1593.26451  12.18574974
## 51    207.88614    88.23779   222.879021  3.306398e+01   110.55348   2.95048229
## 52   2792.94657  1460.31904  2732.581020  0.000000e+00  1417.20896  11.70193960
## 53   1580.23336   718.99052  1619.912960  0.000000e+00   854.65041   0.00000000
## 54   4675.50966  2433.65382  4674.744532  0.000000e+00  2430.29769  49.48825089
## 55    203.96484   113.56668   199.129342  9.711365e+00   107.43988   0.00000000
## 56   3559.34992  1508.76793  3784.705907  0.000000e+00  1995.81995  48.62780268
## 57           NA   562.78862  1161.881642  0.000000e+00   594.56556           NA
## 58   2909.36815  1271.78648  3069.781540  0.000000e+00  1572.87947   0.00000000
## 59    390.58571   203.59997   383.534035  7.183839e+00   206.64364   0.82064488
## 60   1442.14913          NA  1392.139360  6.027820e+02   739.33427   8.39183725
## 61   3348.92106  1698.50519  3301.705485  0.000000e+00  1722.41686  28.67102555
## 62   7406.48846  4723.41518  7049.202086  7.869061e+02  3581.31816  53.41457358
## 63    114.48887    63.97506   111.378839  9.249604e+00    57.76551   0.00000000
## 64   3263.11406  1617.39315  3390.861310  1.002908e+03  1745.38807  40.58710213
## 65           NA  3603.77804  6938.330749  1.014098e+04  3588.30068  52.73482839
## 66   3329.15228  1863.59086  3219.451624  3.508083e+02  1718.79190   0.00000000
## 67   3681.52853  1533.56018  3852.341590  5.035638e+03  2001.94280           NA
## 68    386.28716   180.22752   396.905142  0.000000e+00   202.08240   5.15400545
## 69    324.47380   156.43388   329.150432  3.201053e+02   172.03716   3.27831650
## 70   9989.82427  5992.41570  9644.833977  3.417250e+04  5047.00857  64.84080683
## 71   3949.64921  1817.98924  4175.922908  7.627088e+03  2073.96607  50.12601695
## 72    107.31878    49.26907   109.674688  1.051543e+01    57.84350   0.65797809
## 73    589.56504   311.05428   573.437744  3.199068e+01   307.75046   0.00000000
## 74    147.69916    84.24005   144.023483  3.668384e+02    72.12994   0.69364101
## 75     58.24806    30.12417    58.859764 -4.960528e-01    30.56338   0.37616950
## 76           NA   242.43344   433.889467  5.497950e+01   219.77059   5.45757778
## 77    333.01172   178.13903   330.087606  0.000000e+00   176.00012   2.44143036
## 78     28.70470    15.00677    28.733316 -4.073679e-01    14.77979  -0.66015477
## 79   1323.77427   754.87250  1283.299968  1.755921e+03   669.45278   5.80768248
## 80    879.94630   535.98221   839.246480  1.407044e+01   442.41598   5.56855409
## 81  17934.67102 10016.11590 17426.489617  0.000000e+00  8724.04877   0.00000000
## 82   6285.96133  3182.02894  6365.670613  0.000000e+00  3126.43883  57.43704401
## 83    636.32598   314.24744   654.698727  0.000000e+00   339.91830   6.69241566
## 84   2207.05698  1204.63466  2196.525538  1.016883e+03  1119.64400  22.12335696
## 85    336.22810   184.22825           NA  1.660480e+01   173.45025           NA
## 86    656.07618   318.87779   688.684588  1.922533e+02   349.34918   0.00000000
## 87   5694.65872  3226.62886  5415.757146  0.000000e+00  2834.67516  34.92092300
## 88    189.18636   118.56890   182.442259  4.263131e+01    94.58729   0.72611544
## 89    887.40908   512.38957   857.172175  2.509246e+02   425.87344   8.83687549
## 90    630.96899   305.60829   657.748803  2.744093e+01   331.16910   0.00000000
## 91   3189.25287  1730.83747  3109.941398  8.862844e+01  1572.12635  34.86846319
## 92    395.90040   194.50433   402.021710  1.048985e+03   219.77466   0.57425921
## 93   1117.48762   572.28507  1098.246484  9.221011e+03   554.50645  17.16157152
## 94    451.99021   210.24658   474.939308  1.611659e+01   242.09182   4.40726668
## 95     24.24265    13.14256    24.217303 -4.467400e-02    12.12041  -0.56670317
## 96    385.97344   199.34939   387.022091  8.466693e+00   201.64772   3.32056131
## 97  16271.80032  8100.29829 16409.573081  3.402503e+04  8486.47152 133.41465175
## 98    558.75110   291.87490   551.890638  2.477529e+02   291.21307           NA
## 99    261.57047   135.34802   266.576926  1.650945e+02   138.63084   1.80925574
## 100  1487.33247   781.41090  1454.119126  6.551759e+02   774.79283   6.77464704
## 101  1341.85740   769.38873  1327.313216  9.146534e+01   677.09084  10.95419663
## 102  4703.45785  2214.96686  4820.160569  1.204546e+03  2509.91314  38.78713174
## 103   224.27212    92.04264   238.800254  2.726763e+00   124.71423   2.63268407
## 104   115.38972    56.53938   118.515598  5.139794e+01    61.18045   0.46952216
## 105  1381.63134   604.77425  1451.431226  5.154034e+02   744.29063  18.90643763
## 106   546.05461   262.53788   547.642249  0.000000e+00   291.83860   5.46154162
## 107  3279.68480  1575.30006  3361.173899  2.178180e+03  1796.08860  19.05643164
## 108   188.41628    99.04295   184.363204  4.377271e+00   102.41576  -0.04719354
## 109   334.74295   180.73929   337.204439  3.964576e+01   164.70783   0.00000000
## 110   792.47038   391.97667   801.244509  2.750369e+03   413.83632   8.43261698
## 111   985.08989   469.51864  1004.159010            NA   517.46135   9.46596169
## 112   131.05324    65.66359   128.691890  3.651560e-01    68.31931   0.16152664
## 113  1239.44973   597.26125  1296.951254  9.726776e+01   650.56208   0.00000000
## 114   862.22168   419.87956   867.669182  2.169736e+03   440.14167  11.81487065
## 115   253.56052   122.34808   257.894009  4.913320e+00   139.46027   1.46129201
## 116  1729.63680  1005.59404  1685.220083  5.583438e+02   892.41456  12.48237928
## 117   116.01220    57.92733   117.919882  1.543330e+01    60.94906   0.30732132
## 118  4580.96633  2225.10111  4558.177437  3.934199e+02  2300.95097  39.16674130
## 119  1252.66028   624.24728  1272.648213  8.026548e+01   625.21747  16.13982511
## 120   728.54062   373.40031   726.853300            NA   390.43579   0.00000000
## 121   410.13443   225.63331   404.203873  2.752932e+00   208.86036   0.00000000
## 122  7519.22312          NA  7645.453606  5.491888e+03  3927.94921  51.58543609
## 123  6525.80256  3697.65053  6463.776807  1.563613e+03  3284.06080  68.80233669
## 124   103.21126    46.36175   106.270281  0.000000e+00    55.59928   0.00000000
## 125   368.65359   165.07036   386.660918  1.476811e+02   194.40797   7.28932568
## 126   956.96687   503.17619   963.084700  0.000000e+00   482.35403  23.42303608
## 127   323.73336   152.43630   335.513316  1.855426e+00   173.25179   0.00000000
## 128  2336.86802  1355.59398           NA  3.335728e+02  1259.26203   5.80960088
## 129   995.71361   518.69835  1029.154683  1.348195e-01   545.79534   5.56894453
## 130   988.59411   528.17714   956.057937  3.987273e+03   509.21996   4.34265930
## 131   437.01030   211.52658   457.460944  5.814408e+01   239.97520   0.00000000
## 132   126.72921    63.70741   125.844525  1.260449e+01    66.12116  -0.04518369
## 133  6753.72067  3242.08113  6915.430936  1.314791e+04  3491.21999  72.59463078
## 134   551.12074   282.33188   565.050513  2.021996e+02   288.58675   8.24401333
## 135   544.49796   261.16697   547.612948  5.394239e+00   285.20111   0.00000000
## 136  1058.09625   526.24673  1079.963935  1.421661e+02   541.51573  11.94898156
## 137   247.53301   134.77372   247.441424  6.387831e+00   123.85659   3.58242933
## 138   235.11736   121.57183   238.105783  7.181044e+02   127.01302   2.07546975
## 139 16693.01660  7104.56663 17385.560418  2.618220e+04  8836.55667  81.20482154
## 140    86.18503    44.87018    86.248909  3.063522e+01    44.40561   0.56823485
## 141  5941.82577  3103.23915  5852.477070  8.263669e+02  3044.68568  57.22268106
## 142   243.53163   105.62148   257.916984  6.278043e+01   131.07827   0.00000000
## 143   615.93456          NA   643.127142  2.843387e+01   324.32164   0.00000000
## 144          NA    31.89055    58.604529  3.212765e+00    30.38394  -0.42900888
## 145   222.91662   109.49323   229.508547  0.000000e+00   116.26922   2.90633757
## 146   748.70876   383.88508   759.322334  3.402503e+03   388.75142   6.79976315
## 147   466.41020   228.82030   483.899014  7.667360e+01   246.92051   3.97679671
## 148  1533.77096   816.31644  1537.173360  0.000000e+00   780.25309  12.43587415
## 149  1856.86450  1054.28708  1804.765118  4.211899e+03   981.46502   8.76554582
## 150   379.91562   166.62352   406.083267  0.000000e+00   207.72954   0.00000000
## 151   469.17818   251.87302   461.475699  1.976107e+01   237.91704   3.65500487
## 152  1390.30463   747.07434  1370.547317  2.940005e+02   733.47949   7.00446703
## 153  8941.19847  4593.25918  8872.892506  2.019359e+03  4729.32050  95.80134178
## 154   483.68905   221.72249   505.669237  1.208247e+02   253.76616   9.02159248
## 155  1354.15603   690.93715  1365.449569  0.000000e+00   708.25246  14.29932462
## 156   483.92180   212.89986   512.291848  1.216207e+01   262.61450   0.00000000
## 157   489.25173   266.04465   482.438435  9.224881e+01   253.24358   3.58903082
## 158  4300.63823  2094.97219  4410.213372  4.312401e+03  2240.89844  70.68199933
## 159   553.64492   354.69300   526.535524  1.237537e+02   277.60316   0.00000000
## 160   478.73091   216.10813   491.566847  0.000000e+00   260.00534   3.49264426
## 161   112.05592    57.04274   113.079489  0.000000e+00    58.53374   0.00000000
## 162  2137.80721  1150.24722  2103.406053  0.000000e+00  1085.72852  22.93300999
## 163   661.93090   326.61887   657.768329  1.050866e+02   342.89513   0.00000000
## 164  2323.56048  1201.70042  2220.114258  2.084027e+02  1237.56853   0.00000000
## 165  2042.47062  1156.11107  2049.159602  4.511867e+02  1023.06361  18.97302319
## 166   264.05617   135.32664   265.932099  4.651201e+01   140.62118   0.00000000
## 167   366.94009   191.19019   364.972610  6.995514e+00   189.33231   2.63360634
## 168   278.88447   148.07478   285.753584  3.538620e+02   141.72587   2.95496233
## 169  1800.72447   846.23337  1861.938492  7.172163e+04   964.46047  17.32533714
## 170  4629.92283  2278.91056  4665.883339  0.000000e+00          NA  56.70444508
## 171    34.41006    15.49371    36.592851  1.725339e-01    18.04589   0.00000000
## 172   749.77986   335.16593   775.908162  0.000000e+00   403.37454   6.47215477
## 173   645.19065   317.11583   663.381234  1.065017e+03   341.23220   0.00000000
## 174  1068.87893   546.82543  1045.332847  1.973351e+02   580.99296   0.00000000
## 175  1912.92813   902.88073  1902.333732  7.593526e+03   987.02013  10.28071867
## 176  6923.38892          NA  7384.735841  6.149617e+02  3928.33955   0.00000000
## 177   378.12577   206.74610   378.017249  2.526229e+03   195.47471   4.51783366
## 178 12637.09911  6587.44169 12792.013226  6.432091e+04  6604.06628  78.31586799
## 179  2545.30815  1257.63166  2548.479917  2.785165e+04  1340.30505  20.78412272
## 180   215.50503          NA   211.609488  1.704322e+02   113.49617   0.00000000
## 181  1569.87690   899.37434  1503.918193  6.059757e+02   792.07148   9.36887196
## 182  2739.40883  1309.42851  2809.735508  1.029810e+03  1401.01352  27.26587438
## 183   907.13085   406.81302   934.084433  3.184034e+02   476.22385   6.84793405
## 184  1867.62487   994.48514  1859.804131  0.000000e+00   937.10432  27.48696104
## 185  2871.36657  1411.47622  2906.824779  0.000000e+00  1497.32768  30.96797830
## 186    39.49134    16.86353    43.317262  1.315606e+01    21.05276   0.06892130
## 187   250.24452   124.94241   250.075360  5.153509e+02          NA   0.67931566
## 188  1103.33191   568.14955  1109.253350  5.933832e+00   559.07149   8.88659145
## 189  2333.93284  1213.72091  2395.364358  4.275828e+02  1187.47187  22.51022339
## 190   844.30259   460.99170   816.758982  4.946917e+02   425.22449   5.51741812
## 191  1887.57885   910.38241  1868.660310  1.511247e+04   983.69165  15.48349824
## 192  6623.13357  3656.98993  6586.064829  2.315053e+03  3463.85089  72.88107356
## 193  3156.24957  1485.60832  3218.812967  8.671485e+02          NA   0.00000000
## 194  1603.85191   752.20861  1652.575025  7.025667e+00   847.88573  23.06944309
## 195   192.61110    89.91013   196.222582  2.427600e+02   106.52395   1.05472904
## 196   989.89049   460.98326  1028.330241  5.948685e+03   517.89827  16.88361942
## 197   203.35266   102.68740   209.235736  6.092012e+01   107.37552   1.05409456
## 198  2175.15235  1116.87362  2167.856287  1.150120e+02  1131.83675   0.00000000
## 199   606.96506   316.86537   594.521921  1.104345e+03   302.67029   5.96820918
## 200   209.33457    85.90309   222.884593  1.598032e+02   116.94933   2.19514670
## 201   405.38869   212.69337   403.203547  5.388643e+01   209.62921   2.07321552
## 202  3311.86373  1570.59759  3387.990265  5.382811e+02  1708.83882  79.98316247
## 203   307.62512   159.37902   306.266837  2.302762e+01   158.94645   2.30893846
## 204          NA    66.45553   159.573530  1.460201e+01    81.36949   1.05922114
## 205   844.78681   446.34896   826.234108  1.673239e+02   417.45338   6.66107812
## 206   232.05877   111.44636   237.580904  1.926845e+00          NA   1.89452588
## 207  7255.94227  3484.46839  7347.342601  0.000000e+00  3782.60962           NA
## 208   153.66383    82.45402   152.332281  0.000000e+00    79.22609   1.47490265
## 209  1279.84397   743.23086  1228.843742  0.000000e+00   649.03915   5.40411790
## 210  2312.27303  1228.84199  2300.174420  7.182463e+01  1181.77609  16.74995958
## 211  4417.52306  2317.16650  4297.793681  6.292400e+01  2287.88041  27.30786798
## 212    78.90606    38.85139    82.804471  7.791435e+00    43.42034   0.02024709
## 213   572.35703   254.36981   593.640942  1.639063e+02   309.54242   6.25721260
## 214    95.72788    56.01176    90.973497 -6.040638e-01    48.92639  -0.41213820
## 215   313.02718   143.65179   321.674561  5.834718e+01   176.36313   0.00000000
## 216   238.92646    99.59420   254.500321  3.383513e+00   132.01293   2.19821420
## 217  4827.37763  2355.20491  4900.341270  6.156938e+03  2528.09204   0.00000000
## 218   238.37162   105.64455   250.131671  1.622391e+02   131.54662   0.00000000
## 219   158.24087    81.01975   155.646729  3.304204e+01    83.18538   0.52696590
## 220  2775.80154  1268.19992  2911.459787  0.000000e+00  1470.01826  32.87437447
## 221  8285.78862  3927.40473           NA            NA  4415.47751  31.52909713
## 222  4980.77391  2599.91612  4880.434764  2.294397e+03  2543.54782  47.08154343
## 223 11627.01094  5509.00688 11638.599893  1.182152e+04  6123.64466  86.84133825
## 224   886.11291   469.16629   883.285398  8.363889e+01   454.49569   6.33992556
## 225  1896.17790   962.61100  1890.369711  2.157824e+03   989.28713  11.26294612
## 226   670.18796   319.27578   709.050216  1.146645e+03   360.25594  16.94311379
## 227  7813.71283  3403.56340  8267.085452  1.609433e+04  4216.16756   0.00000000
## 228   501.93567   263.51640   502.321679  1.272975e+02   254.81923   6.50727684
## 229  1215.28583   547.84272  1257.659553  2.798646e+02   636.08377   0.00000000
## 230  1064.85800   508.95690  1081.563177  0.000000e+00   540.56709  14.20575918
## 231  4209.23371  2022.18549  4152.501603  8.440480e+03  2168.12033  35.38995168
## 232    38.16033    20.56179    38.113275  1.458658e+00    19.55069  -0.57427874
## 233   147.89461    76.24589   147.195059  8.504624e+01    75.61900   2.54420579
## 234   593.54962   283.29813   618.832395  1.155623e+02   300.11438   0.00000000
## 235  1248.02018   654.85797  1240.070548  8.071230e+02   642.36733   8.38928415
## 236   472.35954   183.26489   512.626291  1.979367e+02   264.07589   0.00000000
## 237  4145.74628  1888.88755  4346.234239  9.012488e+02  2220.49395   0.00000000
## 238  1759.01597   927.80577  1741.373101  0.000000e+00   896.94492  18.00402353
## 239   374.88805   167.37281   398.800322  1.130739e+02   205.68397   5.58527948
## 240  6538.87364  2931.20155  6902.200703  7.323761e+02  3562.02372  91.54622007
## 241    80.98275    37.44147    85.518114  4.897133e+01    43.72788   0.00000000
## 242 17130.70028  8474.48108 17191.407642  1.271759e+05  8783.09925 125.97084242
## 243   587.29814   295.58661   596.321686  1.729294e+03   316.73886   0.00000000
## 244  3558.09241  1847.30486  3599.647470  0.000000e+00  1842.49584  35.65684013
## 245  1652.18562   689.06110  1794.341210  1.148739e+04   916.92158  21.84802894
## 246    38.87081    15.53980           NA  2.242262e+00    20.31354  -0.30533993
## 247   148.63928    74.00676   148.294358 -5.875784e-01    78.86709   1.89020829
## 248  1475.66142   791.59811  1440.776197  7.723248e+03   766.55003   7.57510036
## 249   318.00489   145.96343   330.618922  0.000000e+00   172.84743   4.73087809
## 250   541.05706   255.17089   561.337602  0.000000e+00   281.82772   9.22774066
## 251  3949.54477  2078.83647  3935.259851  8.164317e+01  1999.09509  29.27532648
## 252   263.09656   136.20606   258.881945  4.218448e+02   138.21491   0.99245581
## 253   248.99940   115.53092   259.611284  0.000000e+00   135.93542   1.05832327
## 254   607.65023   335.10294   598.595265            NA   307.49959   0.00000000
## 255  9582.34159  4262.99396 10138.829945  0.000000e+00  5108.83962 147.85617266
## 256  2508.57011  1091.91461  2597.965350  1.466164e+02  1336.22554  27.09243761
## 257   802.04586   378.30508   799.672624  7.606814e+00   423.15594   0.00000000
## 258  2452.39982  1043.50723  2562.364922  1.626358e+03  1331.46592  22.07042577
## 259  4394.01348  2326.24791  4300.770123  4.812183e+03  2295.81959  32.37276985
## 260  1064.34661   521.40942  1072.883911  6.139467e+03   569.32302   9.07713628
## 261 24049.59394 12551.28107 23558.504075  3.220643e+04 12046.99530 142.99357808
## 262 14381.15438  7204.49812 14535.598112  7.734487e+04  7521.84928 103.24295197
##            BESCH          USB         ISACH
## 1   310.09482470  30.48368699 6575.33408147
## 2    18.47358029  -0.41414050   58.02441360
## 3    24.73831059   0.35008017   12.33190904
## 4    30.44421677  -0.37563076  513.91041344
## 5    20.18174945  -0.09648481   21.44578108
## 6    13.85199405  -0.68410116   25.90377909
## 7    40.42703252   0.30442450  810.75814519
## 8    37.92548982   0.36126771   62.04858940
## 9    44.76593468   0.93543718   25.18754774
## 10  177.13820575   6.84392685   96.93852035
## 11  282.55228375  13.65470758  831.62467306
## 12   51.89685239   1.48771343 1597.30911163
## 13   35.89864251   0.27942877   55.85301528
## 14  290.68846422  11.83443607 3978.59179676
## 15    8.65295621   0.00000000    0.00000000
## 16    3.37273054   2.83200570    2.40653504
## 17   16.81826222   0.00000000  229.68202853
## 18   11.69062878   0.00000000   30.27035126
## 19    6.54742217   8.44399895   20.56151834
## 20    6.78125992   4.73445599    0.00000000
## 21    7.81434245   7.09008510   15.64908544
## 22    2.36165545   0.00000000    3.32725311
## 23   16.26024313  19.62365167  785.47590876
## 24            NA  19.85332391    8.05094879
## 25            NA  18.61770798  506.15172450
## 26    2.73592039   1.90155438    3.39728586
## 27    6.60088138   3.94844186    0.00000000
## 28   11.78867371  14.50663484    2.36682675
## 29   12.62030369  10.62273911   32.35981066
## 30    1.04071305   0.00000000   44.60429423
## 31   25.07915148  28.53983990  221.84671249
## 32    2.32590106           NA   20.32654593
## 33   26.70624061  22.84921657  202.08470146
## 34    1.23762517   0.42456498   11.83658583
## 35   18.03765457  22.11778466   10.32693452
## 36    3.75917069   2.77028741    2.32626675
## 37    1.03580879   0.20034466    2.37573602
## 38    5.07433048   6.39527846    2.93125451
## 39   16.94432290   0.00000000  174.82772385
## 40   37.44603785  35.11904613  666.56801915
## 41   27.82815267  43.16952885            NA
## 42    6.84863028   6.04736443   95.46573896
## 43    8.57362857   8.08237911  321.12925237
## 44   17.73665282  21.37879934  341.48467505
## 45    9.43555572   7.56172354    3.73025477
## 46   22.06541325  36.32222084  120.71592051
## 47    1.80759910   1.32645748    0.00000000
## 48   17.75263702  20.14344086  408.65356430
## 49   46.51460813  58.71757793   44.15302521
## 50   17.48837090  20.96471078    2.90903039
## 51    2.93968035   1.27768849   34.12139724
## 52   21.28090910  25.07051721  147.68657368
## 53    7.00231323   0.00000000  213.37381325
## 54   20.54420135  18.25151564 1125.15566767
## 55    0.94193863   0.00000000    3.67408520
## 56            NA  17.80298958 2553.62295732
## 57    3.90143055   2.21777800   14.64863403
## 58   23.15216574  27.31267372  425.57711530
## 59    0.69484300   0.54441330    3.75323157
## 60   27.25839090  21.97116997   34.65814535
## 61   17.77700945  16.80101624  126.24312224
## 62   13.39049302  21.28070402  132.54447211
## 63    1.97456819   0.77721989    3.66401717
## 64    9.21626504  11.38250744  212.63842893
## 65   16.64446011  22.48316515    0.00000000
## 66   10.39323256   9.86732949  189.56160016
## 67   42.21517994  61.41262467  116.49632516
## 68    2.47062709   1.55440518   48.43477398
## 69    7.31019217   5.75342874   79.36240108
## 70   52.70889542  78.25948265    0.00000000
## 71   24.54498122  36.91570932  111.89896441
## 72    1.13454347   0.64472336   13.98235848
## 73    3.51911804   1.71610693  111.37243277
## 74    1.28416340   1.72554722    0.72241245
## 75    1.55306109  -0.06737877    0.65048782
## 76    3.20636009   1.72905220    4.31230218
## 77    7.91870585   5.09364876   28.73435637
## 78    0.48579120  -0.34035061   -0.45254305
## 79    8.69741462  10.21216800   32.62684332
## 80    4.38122570   2.02710205   28.55516806
## 81   33.58187691  56.70717646   70.53792201
## 82   22.77185801  26.75415469  227.25679324
## 83   11.50905762   8.30050759    1.58783737
## 84   15.28317804  11.44428087   41.35236930
## 85    3.44419008   1.87575743   11.35510834
## 86    4.95251326   4.24324183    9.58792099
## 87   53.59442580   0.00000000 1707.63905629
## 88    3.51404386   2.44759739    8.11796455
## 89    4.10905028   4.51338079  110.69922762
## 90    8.52789303   5.14175311   36.74225024
## 91   14.33380753   8.64689183    0.00000000
## 92   10.65946960  12.23865333    1.18053226
## 93   18.55416591  26.90244269  127.18903568
## 94    3.97894756   0.00000000    2.87963274
## 95    0.24294180  -0.34677625    0.65635683
## 96    2.31767794   0.00000000   16.32641784
## 97   51.16527573  74.26772749  254.03406604
## 98    5.81636501   0.00000000    0.00000000
## 99    2.90163156   2.65034781    4.48618055
## 100  22.96458581  20.82670909   27.96865572
## 101   4.19618358   0.00000000   31.02627631
## 102  12.91231431  13.04983410  200.38834757
## 103   4.89729513   2.11578778  127.30002358
## 104   4.40523956   2.57129107   39.04705099
## 105  20.91223325  19.13065243   77.25511077
## 106   9.95208587   8.78941757   23.84704238
## 107  11.28255071  16.25612218   46.16444917
## 108   4.03551044   0.00000000    1.24687797
## 109   5.09144359   4.26950188   21.87505772
## 110  32.81011629  38.40140362   61.26157558
## 111   3.90259845   3.18152158    0.00000000
## 112  -0.16757015   0.00000000    2.41156070
## 113   6.74483543   4.76732822    0.00000000
## 114  14.34404514  15.56102638   16.96452880
## 115   3.97808879   1.75058751   21.29547025
## 116  18.14725221   0.00000000   50.72903242
## 117   2.33584446   0.69783894   -0.34446132
## 118  12.60424027  11.91766534   74.58321827
## 119   2.52397146   2.31431191    0.00000000
## 120  40.05185924  66.04625216   49.17058107
## 121   1.76978977   0.72836972   53.34266823
## 122   9.73280612   0.00000000   55.20667011
## 123  11.51612680   0.00000000  649.56866513
## 124   0.58098328  -0.36159996    2.12548232
## 125  10.91843096   9.30158711   49.42888623
## 126  14.35487016  10.63891655  703.63625739
## 127   0.43433468   0.00000000            NA
## 128   8.72516318   8.84715922    8.18177519
## 129   3.61222990   0.82734257   -0.09251772
## 130  10.79531058  15.90900354    8.86406222
## 131   3.97311818   2.90843364   21.90206052
## 132   0.85102416   0.03041404   48.56103950
## 133  37.95872799  54.01623751    8.51818023
## 134  20.75288248           NA  118.24118441
## 135   2.90450814   0.00000000   21.24124401
## 136           NA   5.58277629   31.36381867
## 137   3.60164926   1.67293696   47.78880749
## 138  20.17801509  22.51708101    2.13397089
## 139  25.81606871  41.57457243  237.45062366
## 140   5.01084720   2.88198749    1.12432362
## 141  28.01403807  25.63732703  196.14244317
## 142   4.51696859   2.82937035   69.98780993
## 143   3.22153949   1.51642772    2.94304064
## 144   0.97555451   0.19766608   -0.13651637
## 145   4.12258664   2.15788441   27.60900705
## 146  11.25720900  18.15479506   22.34722311
## 147   4.47049188   0.00000000   12.14294499
## 148   6.73495913   6.94584527   20.30342165
## 149  11.19071598  11.83796881    0.00000000
## 150  15.99295560           NA   32.59619897
## 151   4.93840477   3.23305946    0.00000000
## 152   8.46947546   9.07190408   19.50180736
## 153  18.84750495  27.91009989  599.21153784
## 154   6.38043982   4.38202315   35.34923555
## 155  22.79113778  35.82826740  166.13908668
## 156   4.99511967   2.93775780  231.83150488
## 157   4.61219255   3.93553680    0.00000000
## 158  23.86510886  24.48055041  202.29929939
## 159  10.33488151   7.87905927    2.39109850
## 160   9.45430208   0.00000000            NA
## 161   2.35460817   0.00000000   30.65641926
## 162  24.49727048   0.00000000   41.48663576
## 163   9.02356293   0.00000000    5.93902852
## 164  21.05920693  18.50666623    8.14288559
## 165   6.10078666   5.44430907  408.21741621
## 166   5.11674820   3.37344963   11.91117177
## 167   3.42801549   1.35304264    3.06292105
## 168   4.43898917   4.30078622   17.10490367
## 169  51.93424515  96.45250828   38.28442406
## 170  14.42847854   9.18154583            NA
## 171   0.50666877   0.00000000    4.77930523
## 172   4.45825295   2.83910662   33.25556742
## 173  16.21970295  15.76339005    0.00000000
## 174  10.80103287   8.44290851    9.90272664
## 175  11.95194077  23.34055722   25.17407256
## 176  16.51205189   0.00000000  456.74947502
## 177  15.06659136  16.99399344   24.81360111
## 178  40.30898990   0.00000000  187.27223061
## 179  31.67807763  44.03802106    0.00000000
## 180   3.97479232   3.07999877    3.45160684
## 181   6.65774780   6.89933385    0.58776492
## 182  20.10528507  24.95454323  370.31949198
## 183  16.76980983  16.75848344   84.81525136
## 184  13.14632979   7.28938345  585.10776669
## 185  19.22759949  22.37976655   48.47491597
## 186   2.09008891   0.96145396   11.68588538
## 187   4.19192084   4.58964799   -0.92491234
## 188   1.37606793   0.00000000   41.67789221
## 189  10.18634355  10.65554374   24.67139235
## 190   8.02561299   8.73790459            NA
## 191  24.40789577  38.93649374  224.43057158
## 192  16.60875224  20.95053621   97.20757323
## 193  13.18691606  18.05774820  168.55952578
## 194   6.11595251   3.76969389  112.61843955
## 195   7.79558955   0.00000000    0.97383576
## 196  41.80195584  47.55032218  187.12105728
## 197           NA   4.92672846    4.36156735
## 198  19.62881818  12.54007161 1190.31026671
## 199   5.97867493   8.07982698   36.24811873
## 200   7.35786863   6.84627631   34.30258590
## 201   4.91272480   3.99569366  121.65659418
## 202  14.95831799   0.00000000 1298.95409585
## 203   2.41210197   1.03570094    0.00000000
## 204   2.36903242   1.35550797   12.81513319
## 205  10.29631853   8.76102234   72.63349186
## 206   0.45691522  -0.33272964   13.41126340
## 207   5.00916906   5.25642551    0.00000000
## 208   0.40861917   0.00000000   19.05576288
## 209   2.41774469   0.00000000   19.58789656
## 210  14.68581648  10.74583667  127.66240705
## 211  15.88155589  13.16576453  132.77242350
## 212   3.41888108   1.37623315   26.10762232
## 213   6.05744524   4.98163920    0.00000000
## 214   0.20064542   0.00000000    0.13589327
## 215   5.03886186   3.82679880   20.08848927
## 216   2.68095751   0.00000000   75.13100081
## 217  61.39693082   0.00000000  458.27161093
## 218   4.72154644   4.77941458    1.91623236
## 219   2.15014883   1.45864955    0.57007828
## 220   6.10548659   4.44665371   67.85492783
## 221  21.29878789  32.20186786  640.94323966
## 222  33.19402214  39.35958305  140.09138049
## 223  61.12714559  64.08266170  336.44424808
## 224   2.94456148   0.00000000   23.21686572
## 225  17.21612837  19.14236328   16.14904478
## 226  15.92789568  13.52694377   22.11475188
## 227  40.32022557  47.75843102  254.21777563
## 228   4.99417892   4.82310195   23.97198659
## 229  16.00026114  18.60702267    1.80292741
## 230  10.28492446  12.59892563  110.49814689
## 231  63.96953924  73.18904719   85.31257524
## 232   0.24845260           NA    0.26325473
## 233   7.99406668   0.00000000   11.82834962
## 234   5.81128076   0.00000000    7.33992211
## 235  14.92425714   0.00000000    0.00000000
## 236   6.41181726           NA   31.71713102
## 237   8.68099955   9.65884307  332.87001996
## 238  24.93845747  27.19058648   41.85836176
## 239   4.73495410   3.52438161   39.57608551
## 240  18.24550336  18.22407376 1843.51926868
## 241   0.84415021   0.58288296    0.90721802
## 242  64.74210895 105.36741942 2390.14230755
## 243  21.26566035  20.16072352  106.37148100
## 244  45.17474960  77.21788533    0.00000000
## 245  30.41936526   0.00000000  137.84794608
## 246  -0.03561554  -0.30926904    2.88893989
## 247   1.19180920  -0.11396669   32.93113249
## 248  21.49166743  29.59456162   24.17864393
## 249   3.13949785   2.63290629    4.12578468
## 250  15.48106245  12.31680219  238.36829294
## 251   5.66743279   3.43983067  316.26833301
## 252   5.55039722   6.98232464    0.00000000
## 253   2.38834173   0.00000000    3.46312374
## 254   6.59757417   0.00000000  109.25984852
## 255  25.64475813  30.31811300    0.00000000
## 256   4.03182365   2.64747307  313.78851159
## 257   3.73745228   1.87372839   10.60729855
## 258   9.89028808  13.36787852   95.57626759
## 259  23.20820905  29.77702179  203.07981478
## 260  21.37670540  30.26448697   73.96728147
## 261  75.17959846   0.00000000  979.72457477
## 262  23.55834582   0.00000000 1065.26878722
head(SBS5242)
##            PW       BWS_F      Umsatz         PERSA       BEZWD     BEZWDVK
## 1 43888.85242 35081.07414 3737.974701 11815.3610831 37577.19455 379.0521485
## 2  1449.40170  1239.13170  120.099200     5.9457950  1251.43080   8.6653528
## 3  1009.61541   944.93722   79.832300   163.2859277   857.75827   4.2969994
## 4  1218.17072   942.29390  104.851729     1.9011026  1063.73052  20.4941952
## 5   517.36342   450.46195   41.326691    18.0060038   448.09227   2.0590045
## 6    67.19103    44.91809    5.003297    -0.6017785    62.71034  -0.2673511
##       BESCH         USB      ISACH
## 1 310.09482 30.48368699 6575.33408
## 2  18.47358 -0.41414050   58.02441
## 3  24.73831  0.35008017   12.33191
## 4  30.44422 -0.37563076  513.91041
## 5  20.18175 -0.09648481   21.44578
## 6  13.85199 -0.68410116   25.90378
summary(SBS5242)
##        PW              BWS_F              Umsatz              PERSA           
##  Min.   :   21.5   Min.   :   10.22   Min.   :    5.003   Min.   :    -0.604  
##  1st Qu.:  365.1   1st Qu.:  171.30   1st Qu.:  306.267   1st Qu.:     3.213  
##  Median :  985.1   Median :  503.18   Median :  801.245   Median :   105.087  
##  Mean   : 2515.4   Mean   : 1406.27   Mean   : 2100.978   Mean   :  3147.404  
##  3rd Qu.: 2691.6   3rd Qu.: 1309.43   3rd Qu.: 2548.480   3rd Qu.:  1002.908  
##  Max.   :43888.9   Max.   :35081.07   Max.   :23558.504   Max.   :127175.910  
##  NA's   :5         NA's   :5          NA's   :5           NA's   :5           
##      BEZWD             BEZWDVK             BESCH               USB          
##  Min.   :   10.43   Min.   : -0.6602   Min.   : -0.1676   Min.   : -0.6841  
##  1st Qu.:  192.40   1st Qu.:  0.0000   1st Qu.:  3.9789   1st Qu.:  0.5444  
##  Median :  517.46   Median :  5.5174   Median :  9.4356   Median :  4.7794  
##  Mean   : 1453.76   Mean   : 18.1511   Mean   : 17.6972   Mean   : 12.0593  
##  3rd Qu.: 1417.21   3rd Qu.: 20.4038   3rd Qu.: 20.1053   3rd Qu.: 18.0577  
##  Max.   :37577.19   Max.   :379.0521   Max.   :310.0948   Max.   :105.3674  
##  NA's   :5          NA's   :5          NA's   :5          NA's   :5         
##      ISACH          
##  Min.   :  -0.9249  
##  1st Qu.:   3.7532  
##  Median :  31.0263  
##  Mean   : 191.0032  
##  3rd Qu.: 127.1890  
##  Max.   :6575.3341  
##  NA's   :5

Pendeteksian Missing Values

is.na(SBS5242)
##        PW BWS_F Umsatz PERSA BEZWD BEZWDVK BESCH   USB ISACH
## 1   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 2   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 3   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 4   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 5   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 6   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 7   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 8   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 9   FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 10  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 11  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 12  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 13  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 14  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 15  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 16  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 17  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 18  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 19  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 20  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 21  FALSE FALSE   TRUE FALSE FALSE   FALSE FALSE FALSE FALSE
## 22  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 23  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 24  FALSE FALSE  FALSE FALSE FALSE   FALSE  TRUE FALSE FALSE
## 25  FALSE FALSE  FALSE FALSE FALSE   FALSE  TRUE FALSE FALSE
## 26  FALSE FALSE  FALSE  TRUE FALSE   FALSE FALSE FALSE FALSE
## 27  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 28  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 29  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 30  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 31  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 32  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE  TRUE FALSE
## 33  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 34  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 35  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 36  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 37  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 38  FALSE FALSE  FALSE FALSE  TRUE   FALSE FALSE FALSE FALSE
## 39  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 40  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 41  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE  TRUE
## 42  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 43  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 44  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 45  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 46  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 47  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 48  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 49  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 50  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 51  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 52  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 53  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 54  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 55  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 56  FALSE FALSE  FALSE FALSE FALSE   FALSE  TRUE FALSE FALSE
## 57   TRUE FALSE  FALSE FALSE FALSE    TRUE FALSE FALSE FALSE
## 58  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 59  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 60  FALSE  TRUE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 61  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 62  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 63  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 64  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 65   TRUE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 66  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 67  FALSE FALSE  FALSE FALSE FALSE    TRUE FALSE FALSE FALSE
## 68  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 69  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 70  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 71  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 72  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 73  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 74  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 75  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 76   TRUE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 77  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 78  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 79  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 80  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 81  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 82  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 83  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 84  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 85  FALSE FALSE   TRUE FALSE FALSE    TRUE FALSE FALSE FALSE
## 86  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 87  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 88  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 89  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 90  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 91  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 92  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 93  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 94  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 95  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 96  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 97  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 98  FALSE FALSE  FALSE FALSE FALSE    TRUE FALSE FALSE FALSE
## 99  FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 100 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 101 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 102 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 103 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 104 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 105 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 106 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 107 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 108 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 109 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 110 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 111 FALSE FALSE  FALSE  TRUE FALSE   FALSE FALSE FALSE FALSE
## 112 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 113 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 114 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 115 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 116 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 117 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 118 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 119 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 120 FALSE FALSE  FALSE  TRUE FALSE   FALSE FALSE FALSE FALSE
## 121 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 122 FALSE  TRUE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 123 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 124 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 125 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 126 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 127 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE  TRUE
## 128 FALSE FALSE   TRUE FALSE FALSE   FALSE FALSE FALSE FALSE
## 129 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 130 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 131 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 132 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 133 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 134 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE  TRUE FALSE
## 135 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 136 FALSE FALSE  FALSE FALSE FALSE   FALSE  TRUE FALSE FALSE
## 137 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 138 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 139 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 140 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 141 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 142 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 143 FALSE  TRUE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 144  TRUE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 145 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 146 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 147 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 148 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 149 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 150 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE  TRUE FALSE
## 151 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 152 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 153 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 154 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 155 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 156 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 157 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 158 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 159 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 160 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE  TRUE
## 161 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 162 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 163 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 164 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 165 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 166 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 167 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 168 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 169 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 170 FALSE FALSE  FALSE FALSE  TRUE   FALSE FALSE FALSE  TRUE
## 171 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 172 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 173 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 174 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 175 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 176 FALSE  TRUE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 177 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 178 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 179 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 180 FALSE  TRUE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 181 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 182 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 183 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 184 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 185 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 186 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 187 FALSE FALSE  FALSE FALSE  TRUE   FALSE FALSE FALSE FALSE
## 188 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 189 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 190 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE  TRUE
## 191 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 192 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 193 FALSE FALSE  FALSE FALSE  TRUE   FALSE FALSE FALSE FALSE
## 194 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 195 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 196 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 197 FALSE FALSE  FALSE FALSE FALSE   FALSE  TRUE FALSE FALSE
## 198 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 199 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 200 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 201 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 202 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 203 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 204  TRUE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 205 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 206 FALSE FALSE  FALSE FALSE  TRUE   FALSE FALSE FALSE FALSE
## 207 FALSE FALSE  FALSE FALSE FALSE    TRUE FALSE FALSE FALSE
## 208 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 209 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 210 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 211 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 212 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 213 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 214 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 215 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 216 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 217 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 218 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 219 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 220 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 221 FALSE FALSE   TRUE  TRUE FALSE   FALSE FALSE FALSE FALSE
## 222 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 223 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 224 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 225 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 226 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 227 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 228 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 229 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 230 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 231 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 232 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE  TRUE FALSE
## 233 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 234 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 235 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 236 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE  TRUE FALSE
## 237 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 238 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 239 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 240 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 241 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 242 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 243 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 244 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 245 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 246 FALSE FALSE   TRUE FALSE FALSE   FALSE FALSE FALSE FALSE
## 247 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 248 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 249 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 250 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 251 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 252 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 253 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 254 FALSE FALSE  FALSE  TRUE FALSE   FALSE FALSE FALSE FALSE
## 255 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 256 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 257 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 258 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 259 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 260 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 261 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
## 262 FALSE FALSE  FALSE FALSE FALSE   FALSE FALSE FALSE FALSE
colSums(is.na(SBS5242))
##      PW   BWS_F  Umsatz   PERSA   BEZWD BEZWDVK   BESCH     USB   ISACH 
##       5       5       5       5       5       5       5       5       5
library(VIM)
aggr(SBS5242, numbers = TRUE, prop = FALSE)

SBS5242 <- as.data.frame(SBS5242)
class(SBS5242)
## [1] "data.frame"

Imputasi Missing Values

SBS5242[] <- lapply(SBS5242, function(x) {
  if(is.numeric(x)) {
    x[is.na(x)] <- median(x, na.rm = TRUE)
  }
  return(x)
})
colSums(is.na(SBS5242))
##      PW   BWS_F  Umsatz   PERSA   BEZWD BEZWDVK   BESCH     USB   ISACH 
##       0       0       0       0       0       0       0       0       0
summary(SBS5242)
##        PW              BWS_F              Umsatz              PERSA           
##  Min.   :   21.5   Min.   :   10.22   Min.   :    5.003   Min.   :    -0.604  
##  1st Qu.:  367.4   1st Qu.:  174.71   1st Qu.:  323.543   1st Qu.:     3.632  
##  Median :  985.1   Median :  503.18   Median :  801.245   Median :   105.087  
##  Mean   : 2486.2   Mean   : 1389.03   Mean   : 2076.174   Mean   :  3089.344  
##  3rd Qu.: 2558.7   3rd Qu.: 1280.22   3rd Qu.: 2509.851   3rd Qu.:   894.884  
##  Max.   :43888.9   Max.   :35081.07   Max.   :23558.504   Max.   :127175.910  
##      BEZWD             BEZWDVK              BESCH               USB          
##  Min.   :   10.43   Min.   : -0.66015   Min.   : -0.1676   Min.   : -0.6841  
##  1st Qu.:  194.68   1st Qu.:  0.03242   1st Qu.:  4.0327   1st Qu.:  0.5983  
##  Median :  517.46   Median :  5.51742   Median :  9.4356   Median :  4.7794  
##  Mean   : 1435.89   Mean   : 17.91000   Mean   : 17.5395   Mean   : 11.9204  
##  3rd Qu.: 1388.62   3rd Qu.: 19.77899   3rd Qu.: 19.5285   3rd Qu.: 17.6007  
##  Max.   :37577.19   Max.   :379.05215   Max.   :310.0948   Max.   :105.3674  
##      ISACH          
##  Min.   :  -0.9249  
##  1st Qu.:   4.1724  
##  Median :  31.0263  
##  Mean   : 187.9502  
##  3rd Qu.: 125.0965  
##  Max.   :6575.3341

Deteksi dan Penanganan Outlier

numeric_data <- SBS5242[sapply(SBS5242, is.numeric)]
SBS_clean <- numeric_data

for(col in names(SBS_clean)){
  Q1 <- quantile(SBS_clean[[col]], 0.25, na.rm = TRUE)
  Q3 <- quantile(SBS_clean[[col]], 0.75, na.rm = TRUE)
  IQR_val <- Q3 - Q1
  
  lower <- Q1 - 1.5 * IQR_val
  upper <- Q3 + 1.5 * IQR_val
  
  SBS_clean[[col]][SBS_clean[[col]] < lower] <- lower
  SBS_clean[[col]][SBS_clean[[col]] > upper] <- upper
}
numeric_data <- SBS5242[sapply(SBS5242, is.numeric)]

outlier_count <- sapply(numeric_data, function(x) {
  Q1 <- quantile(x, 0.25, na.rm = TRUE)
  Q3 <- quantile(x, 0.75, na.rm = TRUE)
  IQR_val <- Q3 - Q1
  
  lower <- Q1 - 1.5 * IQR_val
  upper <- Q3 + 1.5 * IQR_val
  
  sum(x < lower | x > upper, na.rm = TRUE)
})

outlier_count
##      PW   BWS_F  Umsatz   PERSA   BEZWD BEZWDVK   BESCH     USB   ISACH 
##      28      28      24      46      28      28      17      16      35
outlier_matrix <- sapply(numeric_data, function(x) {
  Q1 <- quantile(x, 0.25, na.rm = TRUE)
  Q3 <- quantile(x, 0.75, na.rm = TRUE)
  IQR_val <- Q3 - Q1
  
  lower <- Q1 - 1.5 * IQR_val
  upper <- Q3 + 1.5 * IQR_val
  
  x < lower | x > upper
})

sum(apply(outlier_matrix, 1, any))
## [1] 83
Q1 <- quantile(SBS5242$PW, 0.25, na.rm = TRUE)
Q3 <- quantile(SBS5242$PW, 0.75, na.rm = TRUE)
IQR_val <- Q3 - Q1

lower_bound <- Q1 - 1.5 * IQR_val
upper_bound <- Q3 + 1.5 * IQR_val

outliers <- SBS5242$PW < lower_bound | SBS5242$PW > upper_bound
sum(outliers)
## [1] 28
boxplot(SBS5242[sapply(SBS5242, is.numeric)],
        main = "Boxplot Semua Variabel Numerik",
        col = "gold",
        las = 2)

SBS5242$PW[outliers] <- ifelse(SBS5242$PW[outliers] < lower_bound, lower_bound, upper_bound)

Deteksi dan Hapus Duplikasi

sum(duplicated(SBS5242)) 
## [1] 0
SBS5242 <- SBS5242[!duplicated(SBS5242), ]

Mengecek Data Setelah Preprocessing

summary(SBS5242) 
##        PW             BWS_F              Umsatz              PERSA           
##  Min.   :  21.5   Min.   :   10.22   Min.   :    5.003   Min.   :    -0.604  
##  1st Qu.: 367.4   1st Qu.:  174.71   1st Qu.:  323.543   1st Qu.:     3.632  
##  Median : 985.1   Median :  503.18   Median :  801.245   Median :   105.087  
##  Mean   :1772.9   Mean   : 1389.03   Mean   : 2076.174   Mean   :  3089.344  
##  3rd Qu.:2558.7   3rd Qu.: 1280.22   3rd Qu.: 2509.851   3rd Qu.:   894.884  
##  Max.   :5845.8   Max.   :35081.07   Max.   :23558.504   Max.   :127175.910  
##      BEZWD             BEZWDVK              BESCH               USB          
##  Min.   :   10.43   Min.   : -0.66015   Min.   : -0.1676   Min.   : -0.6841  
##  1st Qu.:  194.68   1st Qu.:  0.03242   1st Qu.:  4.0327   1st Qu.:  0.5983  
##  Median :  517.46   Median :  5.51742   Median :  9.4356   Median :  4.7794  
##  Mean   : 1435.89   Mean   : 17.91000   Mean   : 17.5395   Mean   : 11.9204  
##  3rd Qu.: 1388.62   3rd Qu.: 19.77899   3rd Qu.: 19.5285   3rd Qu.: 17.6007  
##  Max.   :37577.19   Max.   :379.05215   Max.   :310.0948   Max.   :105.3674  
##      ISACH          
##  Min.   :  -0.9249  
##  1st Qu.:   4.1724  
##  Median :  31.0263  
##  Mean   : 187.9502  
##  3rd Qu.: 125.0965  
##  Max.   :6575.3341

Kesimpulan

Setelah dilakukan preprocessing, dataset SBS5242 telah bersih dari missing values, outlier telah ditangani, dan duplikasi data telah dihapus. Proses ini memastikan data siap digunakan untuk analisis lebih lanjut.

Langkah-langkah ini memberikan pemahaman mendalam tentang preprocessing data, yang merupakan tahap penting sebelum melanjutkan analisis atau model prediktif.