2022Book Publisher International (a part of SCIENCEDOMAIN International)Requires access

Output Variety Precision of Digits Rounding in SPSS and MS Excel

Zaher Saif Mohammed Al-Hashami

Open publisher page 1 citations

Abstract

Statistical operations are performed by various specialist programs, 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 program that can perform these calculations. Within the functions they are calculating, the level of some programs 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. In SPSS the decimals are valid for numeric variables only. 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.

About this research paper

What this paper is about

Statistical operations are performed by various specialist programs, 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 program that can perform these calculations. Within the functions they are calculating, the level of some programs 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. In SPSS the decimals are valid for numeric variables only. 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.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Statistical operations are performed by various specialist programs, 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 program that can perform these calculations. Within the functions they are calculating, the level of some programs 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. In SPSS the decimals are valid for numeric variables only. 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.

Key concepts: Decimal, Rounding, Microsoft excel, Numerical digit, Arithmetic, Computer science, Ms excel, Algorithm

Related papers

Back to paper searchBrowse research topicsOriginal source
Output Variety Precision of Digits Rounding in SPSS and MS Excel — Research Paper | ScholarLens