USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following are not included statistical functions are ____
|
|
=if()
|
|
|
=sum()
|
|
|
=count()
|
|
|
=min()
|
Explanation:
Detailed explanation-1: -The following is not function of statistics is: The correct option is b) Statistics indicate trend behavior. Originally the word ‘statistics’ was used for the collection of data concerning states both historical and descriptive.
Detailed explanation-2: -The most commonly used statistical functions by professional data analysts are MEDIAN, MODE, STANDARD DEVIATION, AVERAGE, VARIANCE, CORRELATION, and QUARTILES, to name a few.
Detailed explanation-3: -Syntax. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK")
There is 1 question to complete.