Question: Im presented with an excel datasheet that contains data collected via a multi-sensor platform (sensor system). The sensor system contains readings on date, PM2.5, N02,
Im presented with an excel datasheet that contains data collected via a multi-sensor platform (sensor system). The sensor system contains readings on date, PM2.5, N02, 03, temperature and humidity. The data presented are 1 hour averages. Using the software R studio, I'm tasked with looking at data pre-processing and basic statistics ( detetcting missing values, outliers, presenting averages, standard deviations, quartiles and box plots). Can i have help with this task, as I've never used R studio?
The images contain the data sheet










Main Data (Sensor System average 1 hour) Date PM2.5 NO2 03 temperature humidity 18/10/2018 7.050505111 45.46464611 171.322449 18.41632653 39.26938776 18/10/2018 6.505050222 45.43434322 147.5255973 18.16382253 40.49829352 18/10/2018 6.707070333 57.20202033 123.9052133 17.20853081 43.06635071 18/10/2018 6.683333333 66.58333333 39.94444444 16.20555556 46.65555556 18/10/2018 6.492957746 66.8685446 34.31924883 15.03286385 49.35211268 18/10/2018 6.493562232 201.3648069 87.87982833 13.72961373 52.18454936 18/10/2018 6.576086957 192.9293478 84.17391304 13.33152174 53.29347826 18/10/2018 6.410810811 60.09189189 24.9027027 13.39459459 53.3027027 18/10/2018 6.075471698 51.81509434 27 13.25283019 54.52075472 18/10/2018 6.933333333 44.74901961 29.83529412 13.4627451 54.63921569 19/10/2018 7.179878049 48.39634146 27.85670732 13.0152439 57.2804878 19/10/2018 7.332317073 43.42378049 28.67682927 13 58.25914634 19/10/2018 6.035714286 38.80654762 30.51785714 12.90178571 57.64583333 19/10/2018 6.693009119 57.06382979 28.2674772 13 56.10638298 19/10/2018 7.204268293 77.23780488 32.17682927 13.63414634 54.76219512 19/10/2018 7.418397626 89.69139466 37.42433234 14 55.49554896 19/10/2018 6.966463415 71.86585366 34.63719512 14.03658537 56.42987805 19/10/2018 6.683890578 76.32826748 37.55927052 14.29787234 56.89057751 19/10/2018 6.808955224 68.2 40.82985075 14.76119403 60.87164179 19/10/2018 7.161585366 63.08841463 41.49390244 15.69817073 59.60670732 19/10/2018 7.179331307 64.76595745 38.5106383 16.62613982 57.79635258 19/10/2018 6.913690476 67.5952381 40.05357143 17.79166667 54.9672619 19/10/2018 6.75 77.24085366 41.83231707 18.0152439 55.7652439 19/10/2018 6.94224924 60.23708207 42.02431611 18.61094225 55.22796353 19/10/2018 6.452380952 40.70238095 51.22321429 18.16666667 56.48511905 19/10/2018 6.556923077 58.70153846 46.84615385 18 58.4 19/10/2018 6.489361702 63.74772036 40.06990881 17.40729483 61.48632219 19/10/2018 6.425595238 65.24107143 32.73214286 17.04761905 63.33035714 19/10/2018 6.592705167 56.81155015 29.50759878 17.18541033 62.6656535 19/10/2018 6.411585366 47.85670732 36.57317073 17.19817073 62.72256098 19/10/2018 6.377245509 48.38922156 37.53892216 17.21257485 62.90419162 19/10/2018 6.496969697 37.36969697 40.3030303 17.13636364 64.2030303 19/10/2018 6.407294833 38.02431611 36.95136778 17.16109422 63.72644377 19/10/2018 6.290030211 27.03021148 39.40785498 17.09667674 63.59516616 20/10/2018 6.537537538 32.46846847 32.18918919 17.09009009 62.63663664 20/10/2018 6.507598784 23.73556231 36.556231 17.01519757 63.29787234 20/10/2018 6.689969605 30.34346505 30.10030395 16.51671733 66.24924012 20/10/2018 6.580357143 30.94642857 31.22916667 16.84821429 66.6577381 20/10/2018 6.306990881 30.43768997 36.06990881 17 66.11550152 20/10/2018 6.376899696 38.44984802 32.59574468 17 65.19756839 20/10/2018 6.389880952 46.70238095 33.30357143 17.10119048 64.4077381 20/10/2018 6.778115502 40.11854103 37.3343465 17.32522796 64.15197568 20/10/2018 6.801829268 33.87195122 39.08231707 18.01219512 62.63719512 20/10/2018 6.548961424 38.34124629 40.07715134 18.53709199 60.82195846 20/10/2018 6.774390244 31.44817073 47.13109756 19.31097561 58.53963415 20/10/2018 6.466463415 32.25609756 52.51219512 20 57.7286585405/11/2018 7.637195122 92.17987805 11.38109756 15.01829268 69.24390244 05/11/2018 7.383233533 51.38023952 11.02994012 15.55688623 66.67365269 05/11/2018 7.452662722 48.66568047 11.49704142 15.21301775 66.23668639 05/11/2018 6.908823529 48.07941176 10.37352941 15.05294118 65.46176471 05/11/2018 7.099697885 48.09365559 8.429003021 15 65.14199396 05/11/2018 7.104166667 50.33035714 12.66964286 15 65.31547619 05/11/2018 6.876832845 53.3372434 15.26686217 15 65.58651026 05/11/2018 6.685534591 40.84591195 19.47798742 15.16037736 64.90880503 05/11/2018 7.100609756 30.03658537 23.16158537 15.34756098 62.33841463 05/11/2018 7.187134503 42.76608187 15.40643275 15.22222222 62.81578947 05/11/2018 7.24925816 24.70029674 23.14836795 15.99406528 63.18991098 05/11/2018 7.154589372 13.41545894 20.03864734 16.30434783 62.68115942 06/11/2018 6.917431193 20.44342508 24.42201835 16.05198777 65.57798165 06/11/2018 7.359756098 20.11890244 25.06707317 16.02743902 65.85670732 06/11/2018 7.4 11.55522388 30.04776119 16.18208955 64.7641791 06/11/2018 7.516616314 11.92145015 33.51661631 16.82477341 65.20845921 06/11/2018 7.124620061 16.50151976 36.14893617 16.40729483 66.59878419 06/11/2018 7.306060606 29.01515152 32.3969697 16.42121212 67.30606061 06/11/2018 7.296407186 43.47904192 26.72754491 16.51497006 67.9251497 06/11/2018 7.652439024 42.03963415 28.86890244 16.99390244 67.37195122 06/11/2018 6.682926829 39.26219512 37.05792683 16.39939024 66.88109756 06/11/2018 7 42.68686844 126.7555556 16.42222222 65.01111111 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018 06/11/2018\f\f24/10/2018 6.981595092 38.81595092 67.8006135 17.27300613 49.82208589 24/10/2018 6.410658307 44.42946708 65.8338558 17.0815047 50.82131661 24/10/2018 6.663690476 36.52380952 68.5327381 16.85119048 50.94047619 24/10/2018 6.510703364 40.67889908 64.10091743 16.20183486 52.09785933 24/10/2018 6.401840491 40.74233129 66.65030675 16 53.57055215 24/10/2018 6.175595238 31.80952381 69.66666667 15.93452381 54.21428571 24/10/2018 6.162079511 32.27217125 68.98776758 15.25993884 56.11926606 24/10/2018 6.153846154 25.42461538 70.10153846 15.05846154 57.01538462 24/10/2018 6.047761194 19.51940299 74.48358209 15.03283582 56.00597015 24/10/2018 6.134969325 15.12883436 76.80674847 15 57.3006135 24/10/2018 6.146875 9.790625 80.271875 15.01875 56.171875 24/10/2018 6.143283582 12.05970149 78.50447761 15 56.82686567 25/10/2018 6.256097561 16.17073171 72.80487805 15 58.85060976 25/10/2018 6.240740741 13.3117284 70.19135802 15 59.9382716 25/10/2018 6.264264264 13.24024024 69.04504505 15 59.5015015 25/10/2018 6.393292683 31.6402439 55.25609756 59.94207317 25/10/2018 6.422492401 52.88449848 45.83586626 15 60.57142857 25/10/2018 6.28358209 61.90746269 43.39701493 15 60.32835821 25/10/2018 6.463414634 65.18292683 36.45121951 15 60.23780488 25/10/2018 6.417682927 64.03353659 40.9054878 15.36890244 58.88719512 25/10/2018 6.410179641 52.08682635 47.75149701 16.48502994 56.00598802 25/10/2018 6.195583596 41.9873817 51.34069401 17.70347003 52.69085174 25/10/2018 6.56547619 53.7202381 48.21130952 17.13095238 54.52380952 25/10/2018 6.14893617 38.40425532 54.46200608 17.40425532 53.67173252 25/10/2018 6.073394495 31.31804281 59.70336391 17.85015291 51.0764526 25/10/2018 6.1875 38.30059524 61.97916667 16.99107143 53.64285714 25/10/2018 6.138554217 45.89156627 55.73192771 16.14457831 55.31626506 25/10/2018 6.118012422 42.21428571 56.68944099 16.01552795 55.70496894 25/10/2018 6.191044776 52.2358209 51.55820896 15.74925373 56.72537313 25/10/2018 6.449541284 54.47400612 46.76452599 15.19877676 58.37003058 25/10/2018 6.31402439 37.57012195 55.875 15.01219512 59.9847561 25/10/2018 6.288690476 23.30357143 63.30654762 15 62.02678571 25/10/2018 6.237804878 13.48170732 67.53353659 14.38719512 61.22256098 25/10/2018 6.740853659 12.06097561 66.72865854 13.08841463 57.49085366 25/10/2018 5.850299401 11.9491018 64.15568862 12.43113772 56.05688623 25/10/2018 5.545454545 11.81212121 64.34848485 12 56.62727273 26/10/2018 5.548780488 13.70426829 63.32317073 11.91463415 57.20121951 26/10/2018 5.560240964 13.49698795 63.21987952 11.31626506 58.5813253 26/10/2018 5.159638554 13.95783133 65.26204819 10.76807229 58.6746988 26/10/2018 5.265243902 20.47560976 60.01829268 10.27439024 57.83536585 26/10/2018 5.093939394 37.06060606 50.33636364 10.10909091 58.22424242 26/10/2018 5.315315315 42.64264264 55.5045045 10.06906907 60.78378378 26/10/2018 5.564417178 54.27607362 46.88343558 9.806748466 63.78527607 26/10/2018 5.425981873 56.53776435 43.3897281 9.954682779 61.25377644 26/10/2018 5.388554217 41.09939759 53.30421687 10.46686747 58.4126506 26/10/2018 5.558282209 42.39877301 53.19018405 11.00306748 59.60122699 26/10/2018 5.481927711 32.55421687 52.8313253 13.08433735 53.68975904 26/10/2018 5.933534743 28.55891239 60.40181269 14.12386707 48.81570997\f\f30/10/2018 6.002994012 71.26646707 41.74850299 16.06586826 34.17964072 30/10/2018 6.178461538 90.03076923 30.34769231 14.6 37.37230769 30/10/2018 5.932515337 101.5153374 20.77607362 13.59509202 39.29754601 30/10/2018 6.191044776 89.2 15.86865672 13.0119403 41.41492537 30/10/2018 6.286585366 78.92682927 18.3902439 12.3445122 42.93292683 30/10/2018 6.067484663 95.86196319 6.404907975 12.09202454 46.62269939 30/10/2018 7.020895522 90.17014925 2.513432836 12 47.87462687 30/10/2018 6.43597561 96.22560976 1.018292683 11.36890244 49.61585366 30/10/2018 7.134146341 92.83536585 1.515243902 11 50.70121951 30/10/2018 6.325373134 84.88358209 0.346268657 11 52.31343284 30/10/2018 6.356707317 68.38719512 0.917682927 10.94817073 53.50304878 30/10/2018 5.722560976 58.46036585 5.606707317 11 56.66158537 31/10/2018 5.824925816 55.16617211 8.884272997 10.27596439 62.52225519 31/10/2018 5.902439024 47.08841463 8.951219512 10.35670732 64.25304878 31/10/2018 5.52887538 46.6656535 8.310030395 10.88753799 65.11246201 31/10/2018 5.119760479 39.31137725 11.40718563 11 65.70359281 31/10/2018 5.233128834 52.71472393 4.248466258 11 65.7791411 31/10/2018 5.449848024 78.91489362 3.73556231 10.98480243 64.93009119 31/10/2018 5.373134328 94.6 3.671641791 10.94029851 64.77313433 31/10/2018 5.447852761 83.29141104 3.63803681 11 63.97546012 31/10/2018 5.387195122 70.69512195 5.051829268 11.06707317 62.42987805 31/10/2018 5.337349398 69.32831325 5.524096386 12.51204819 56.74096386 31/10/2018 5.422018349 72.05198777 14.13761468 13.79510703 50.36391437 31/10/2018 5.513761468 78.72171254 17.21406728 14.0733945 49.2293578 31/10/2018 6.571428571 88.83035714 21.77380952 14.13988095 54.30357143 31/10/2018 7.17325228 97.43465046 12.9331307 13.69300912 58.98176292 31/10/2018 6.570552147 86.48773006 14.38650307 13.05214724 62.25766871 31/10/2018 6.429850746 81.04776119 8.976119403 12.28656716 62.8238806 31/10/2018 6.563076923 84.55384615 4.744615385 12 64.88615385 31/10/2018 7.204268293 96.34756098 3.853658537 12 65.38414634 31/10/2018 6.077380952 79.16369048 4.389880952 61.61904762 31/10/2018 6.308868502 91.24464832 3.892966361 11.49235474 60.22629969 31/10/2018 6.71559633 85.96330275 4.52293578 11.02752294 63.02140673 31/10/2018 7.256716418 75.11044776 2.205970149 10.78507463 64.33731343 31/10/2018 6.446808511 72.48024316 1.814589666 10.0212766 64.01519757 31/10/2018 6.027522936 61.89908257 1990825688 9.262996942 64.03363914 01/11/2018 5.6875 53.04464286 3.241071429 8.49702381 65.31845238 01/11/2018 5.786585366 45.81402439 9.966463415 8.070121951 65.07012195 01/11/2018 5.932926829 32.94817073 14.41768293 7.743902439 64.40243902 01/11/2018 5.859701493 33.42985075 12.96119403 7 65.31940299 01/11/2018 5.680851064 47.95440729 10.39817629 7 65.13069909 01/11/2018 5.321100917 65.94189602 9.116207951 7.051987768 63.04281346 01/11/2018 5.700296736 88.0504451 5.575667656 7.089020772 62.3768546 01/11/2018 5.570121951 93.7195122 4.896341463 7.881097561 60.39329268 01/11/2018 5.527607362 74.16257669 11.9202454 9.662576687 55.71779141 01/11/2018 5.587537092 56.26706231 20.76261128 11.60237389 50.86053412 01/11/2018 5.56402439 62.25914634 29.81707317 13.71341463 45.87195122 01/11/2018 5.877675841 53.14067278 42.01834862 14.28440367 44.05504587\f\f
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
