The LED chart is not a chart, in the true sense of the word, but it looks nice and is a good choice to illustrate Variance analysis report. We make it so that, after analyzing the percentage for which the plan was exceeded or missed, with the help of the REPT function, generate a certain number of “squares” to illustrate the obtained result.
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.