On a daily bases, economists must enter and process a large amount of data. Most of the data is entered into an Excel application. When entering data into an Excel document, accidental or intentional incorrect data entry can occur. To prevent any possible incorrect data entry in the prepared Excel document, it is advisable to use the command for validation of the entered data before data entry. Data filtering is an integral part of the analysis of previously entered data in an Excel document. It is used to quickly and easily find the desired data in the table and continue further work only with the selected part of the data; the process of filtering data is described in the paper. When we have a large amount of data in economics, it can generally be estimated that they behave according to the Gaussian distribution. In this paper, we described how the area (or probability) below the Gaussian curve can be calculated easily and quickly in Excel, using the ready-made statistical function NORM.DIST and NORM.INV. Using two practical examples, we have shown how with the help of these two functions estimates, some values in the total data population can be performed.

Pročitaj online

Preuzmi PDF fajl

Curtis D. Frye, Microsoft Excel 2013 Step by Step, Microsoft, 2013.

ISO 10576-1:2003, Statistical methods — Guidelines for the evaluation of conformity with specified requirements - Part 1: General principles, ISO, 2003.

Damjanović S., Katanić P., A program for conformity assessment of the calibration results with the specification, International Journal of Electrical Engineering and Computing Vol. 3, No. 1 (2019), Elektrotehnički Fakultet, Istočno Sarajevo, 2019.

Damjanović S., Katanić P., Krsmanović B., „Excel za ekonomiste“, FPE Bijelјina 2020.

Krstić Gorana i Šoškić Dejan, „Ekonomska statistika“, Ekonomski fakultet, Beograd, prvo izdanje 2012.