Distribution Analysis S-criterion Skewness

“Distribution Analysis S-criterion_Skewness” is a computer programme for calculating non-parametric criteria for evaluating the nature of the distribution of data.

The calculation algorithm is carried out in MS Excel using built-in functions.

The maximum number of data is 5000 values.

Input the data of the studied time series into Column A.

Check that the column does not contain data from previous calculations.

The graph shows the ranked normalised data.

The values of the proposed criteria are shown in cells I2 (S-criterion) and O2 (skewness coefficient A_s).

Reference

1. Suleymanov A.A., Abbasov A.A. The identification of data distribution in oil production. Petroleum Science and Technology, 2011, Volume 29, Issue 23, pp. 2480-2486. DOI:10.1080/10916461003735079.

2. Suleymanov A.A., Abbasov A.A. Diagnosing the condition of dynamic processes based on an assessment of the distribution of field data. SOCAR Proceedings, Issue 4, 2010, 30-35. DOI: 10.5510/OGP20100400041.

3. Suleymanov A.A., Abbasov A.A.Non-parametric Criteria of Chaotic Data Analysis in Oil Production. Advances in Intelligent Systems and Computing, Springer Nature Switzerland AG 2019, 491-498. DOI: 10.1007/978-3-030-04164-9.