New Switching Functions of Microsoft Excel | Chapter 4 | Research and Applications Towards Mathematics and Computer Science Vol. 4

 The phase describes the changing functions of Microsoft Excel. It focuses on the creation of in charge formulas, examples show the use of function SWITCH and compares it to familiar Excel function IF. Microsoft Excel has the basic appearance of all spreadsheets using a gridiron of cells organized in numbered rows and report-named pillars to organize dossier manipulations like arithmetic movements. Using functions in modeling business-related and financial models in computer program software Microsoft Excel should. Formulas are easier to grasp when the new exchanging function SWITCH is used a suggestion of correction the outdated probable function IF that is reside inside of another logical function IF and has various closed supports at the conclusion. Users may find it smooth to create formulas accompanying the aid of new logical exchanging features.

Author(s) Details:

Rostislav Tomes,
Department of Digital Economy, Informatics and Statistics, Faculty of Business, Pan-European University, Spálená 14, Prague, Czech Republic.

Please see the link here: https://stm.bookpi.org/RATMCS-V4/article/view/11812

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

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