Saturday, 14 August 2021

Determination of Range of Outputs Precise of Digits Rounding in SPSS and MS Excel | Chapter 9 | Current Topics on Mathematics and Computer Science Vol. 6

This study's concept is to calculate rounding and truncate in SPSS and round function in MS Excel for 10 random digits numbers, then compare the results in the two programmes using the same digits numbers. In four decimal places, compare the rounding outputs of both programmes. Statistical operations are performed by various specialist programmes, which can do these processes quickly and accurately. In SAS, STAT, and the analytical application SPSS, there are various functions that can be calculated. There is a Microsoft Excel software that can perform these calculations. Within the functions they are calculating, the level of some programmes may differ from that of others. Sum, Average, Maximum, and Minimum are examples of these functions. This research can also measure the accuracy of the round function, which is one of these functions. In this study, I used ten-digit integers and three criteria: less than, equal to, and more than 5. Rounding procedures are performed based on whether the desired decimal place is less, equal, or greater than 5. Using the SPSS and MS Excel tools, ten digits were rounded. Except that Microsoft Excel truncates the remaining zeroes of the digit after the decimal point, the output findings are identical. It will truncate after the decimal point whenever the decimal place provided in the digit is wanted. Based on the decimal place in the digit number desired statistically and analytically, SPSS is more precise than MS Excel.

Author (S) Details

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

View Book :- https://stm.bookpi.org/CTMCS-V6/article/view/2589

No comments:

Post a Comment