Tag: Excel Function

General Statistics

Anomaly detection | Sort and Rank techniques

In most cases, there are complex and specific algorithms for abnormal or anomaly detection that have been implemented through various software in statistical or data analysis. However, in this article from the Arman Computer magazine, we aim to discuss the application of sorting and identifying abnormal observations, which, in addition to being simple, is also […]

Loading

Computer Softwares Excel Tutorial Statistics

Random Number in MS-Excel | How to Use

Random numbers in computer data simulation and statistical distributions play an important role. Although we know that the numbers generated by computer algorithms are pseudo-random (No real Random), but in most cases we use these techniques to create random numbers in the range [a,b] (from a to b). In this article of Arman Computer magazine, we […]

Loading

Computer Softwares General

Weighted Mean | Computation and Application

As in the calculation formula Average said, the role of each observation and value in calculating the average is equal and the same. If it is necessary that some observations have more or less importance in calculating the mean, weight (importance level) can be considered for them. In this article from Arman Computer Magazine, we […]

Loading

Back To Top