20.500.12556/RUL-119696 Program Excel kot orodje za statistično vrednotenje rezultatov kemijskih analiz Program Excel as a tool for statistical evaluation of chemical analysis results Kemijske analize temeljijo na meritvah. Pri njihovem vrednotenju ima ključno vlogo statistika. Biti moramo sposobni ne le analizirati, temveč tudi ustrezno interpretirati rezultate in na podlagi tega sprejemati odločitve. Za vrednotenje rezultatov analiz smo v diplomskem delu uporabili osnovno, množično dostopno, hitro za učenje, močno in predvsem uporabnikom prijazno programsko opremo Microsoft Excel. Cilj je bil prikazati Excelova dodatka Orodja za analizo podatkov in Reševalnik, ki se uporabljata za kompleksne statistične analize in optimizacijo; prikazati, kako delujeta in kaj vse lahko z njima naredimo. Uporaba Excela v kemiji je široka, predvsem se uporablja v analizni in fizikalni kemiji, za reševanje linearnih in nelinearnih enačb, za statistično in grafično analizo, linearno regresijo, optimizacijo, prileganje krivulj. Uporabnost smo skušali prikazati s pomočjo različnih primerov iz literature. Ugotovili smo, da lahko tako preprost program za uporabo, kot je Excel, obdela kompleksne, številčne podatke in dejansko zadosti potrebnim izračunom, nam ponuja hitre, učinkovite ter natančne rešitve. Z Excelom prihranimo na času, saj so vnos, analiza, spreminjanje podatkov in rezultati v istem programu. Poleg hitrega izpisa rezultatov, so ti pregledni in se samodejno posodobijo ob spremembah vhodnih podatkov. Spoznamo pa tudi nekaj slabosti Excela, na katere moramo biti pozorni. Chemical analyses are based on measurements. Statistics has a key role in their evaluation. We have to be able not only to analyse, but also to appropriately interpret the results and make decisions based on them. For evaluation of results of the analyses in diploma work we have used basic, mass-accessible, fast-learning, powerful and, above all, user-friendly software Microsoft Excel. The aim was to present the Excel’s add-ins Data Analysis and Solver, which are used for complex statistical analysis and optimization, to show how they work and what we can do with them. The use of Excel in chemistry is versatile, it is mainly used in analytical and physical chemistry, for solving linear and nonlinear equations, for statistical and graphical analysis, linear regression, optimization, and fitting to curves. We tried to show the usability through various examples from the literature. We have found out that such a simple to use program, as Excel, can process complex numerical data and actually satisfy the necessary calculations. It can offer fast, efficient and accurate solutions. With Excel we can save time, because input, analysis, data modification, and results are in the same program. In addition to a quick printout of the results, they are transparent and are automatically updated following the changes of input data. We also learn about some of the weaknesses of Excel the we need to be aware of. statistika vrednotenje rezultatov Microsoft Excel orodje za analizo podatkov reševalnik Statistics Evaluation of results Microsoft Excel Data Analysis Solver true false false Slovenski jezik Angleški jezik Diplomsko delo/naloga 2020-09-10 16:50:00 2020-09-10 16:50:05 2022-08-31 03:54:19 0000-00-00 00:00:00 2020 0 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 8881 32219651 Gasperic_Tjasa_-_Program_Excel_kot_orodje_za_statisticno_vrednotenje_rezultatov_kemijskih_analiz.pdf Gasperic_Tjasa_-_Program_Excel_kot_orodje_za_statisticno_vrednotenje_rezultatov_kemijskih_analiz.pdf 1 4F9BBFDD85D24AD2EBE5826B5D1016C2 95c980933a9959961928fe743087fc750885733c984ff5c0c6973ac3549dbbfd e598ad16-a1b9-11eb-a523-00155dcfd717 https://repozitorij.uni-lj.si/Dokument.php?lang=slv&id=134421 Fakulteta za kemijo in kemijsko tehnologijo 0 0 0