Range of outputs precise of digits rounding in SPSS and MS Excel


  • Zaher Al-Hashami CS Instructor






The statistical operations done by many specialist programs, by them can do these operations fluently and precisely. There are many functions in such programs can calculate in SAS, STAT and the analytical program SPSS. There is Microsoft Excel program that is calculate like these functions. The level of some programs may be different than others within these functions they are calculating. From these functions are Sum, Average, Maximum and Minimum. Round function is also from these functions that can measure it's accuracy through this research. In this research i chose ten digits numbers and I also chose three criteria under, equal and more than 5. According to that the rounding operations are done based on if wanted decimal place is less, equal or higher than 5. Rounding applied on ten digits using SPSS and MS Excel programs. The outputs findings are the same except that Microsoft Excel is truncating the last zeroes of the digit after the decimal point. Wherever the decimal place specified in the digit is want it will truncate after the decimal point. The SPSS is more precise than MS Excel based on the decimal place in the digit number wanted statistically and analytically.

Keywords: Decimal Place, Digit, Excel, Function, Round.


[1] French Ted, Rounding Numbers in Excel, the Excel 2007 ROUND function, 2014. Website: spreadsheets.about.com/od/excel2007/qt/excel2007_round.htm

[2] Poes, Joseph Matthew, Truncation of values after Decimal when exporting to Excel, 2011. Website: spssx-discussion.1045642.n5.nabble.com/Truncation-of-values-after-Decimal-when-exporting-to-Excel-td5068824.html

[3] Matthew Hesson, Reporting statistics in APA Style, A Short guide to handling numbers and statistics in APA Style, 2014. Website: my.ilstu.edu/~mshesso/apa_stats.htm

[4] French Ted, Excel Round Function, rounding numbers in Excel, 2014. Website: spreadsheets.about.com/od/excelfunctions/qt/070809_round.htm

[5] Tim Birkett, Rounding, Online Excel Tutorial, 2006. accountingweb.co.uk/topic/excel-faqs-rounding/493946

View Full Article: