Outliers are values that differ significantly from other members of a statistical set. By analyzing outliers we can try to establish why they occurred in order to take some preventive or corrective actions. Using the example of sales analysis in the first four months of a year, you will learn how to detect exceptions and how to display them on a line chart.
In one of the earlier „recipes“ I briefly described the statistical functions in Excel. My knowledge of statistics is quite modest (one of these days will probably take some additional lessons to improve my knowledge). However, I would like to dedicate one article to this area. On a practical case, the analysis of wages in a small company, I’ll show you how you can use these functions to make you come up with some interesting conclusions.
Iako Excel ima manje mogućnosti nego specijalizovani softveri za statističku obradu podataka kao što je SPSS, on poseduje mnoštvo statističkih funkcija što ga čini moćnim alatom. Njih možete da iskoristite za analizu poslovnih izveštaja, a imaju primenu i u svim drugim oblastima gde se statistika koristi kao alat za analizu podataka.