Wednesday, 13 July 2022

Output Variety Precision of Digits Rounding in SPSS and MS Excel | Chapter 6 | Novel Research Aspects in Mathematical and Computer Science Vol. 5

Different specialised programmes that can carry out statistical procedures rapidly and accurately are used. There are several functions that may be calculated in SAS, STAT, and the analytical programme SPSS. These calculations may be made using a Microsoft Excel software. Some programmes may operate at a higher level than others inside the functions they are computing. These functions include sum, average, maximum, and minimum, for instance. The precision of the round function, one of these functions, may also be measured by this research. I employed ten-digit numbers in this investigation and the following three criteria: less than, equal to, and more than 5. The SPSS only allows decimals for numerical variables. Depending on whether the target decimal place is less, equal, or more than 5, different rounding techniques are used. Ten digits were rounded using the capabilities in SPSS and MS Excel. The output results are the same with the exception that Microsoft Excel trims out the last few zeros of the digit after the decimal point. Whenever the decimal place supplied in the digit is desired, it will truncate after the decimal point. SPSS is more accurate than MS Excel in terms of the decimal place in the digit number needed for statistical and analytical purposes.


Author (s) Details:

Zaher Saif Mohammed Al-Hashami,
CS Instructor, Muscat, Sultanate of Oman.

Please see the link here:
https://stm.bookpi.org/NRAMCS-V5/article/view/7483

No comments:

Post a Comment