Manuals/calci/VARIF - Revision history

Devika: /* Examples */

2020-06-02T09:47:35Z

Examples

Devika at 20:54, 4 December 2018

2018-12-04T20:54:44Z

Devika at 19:45, 1 May 2017

2017-05-01T19:45:14Z

Devika at 19:34, 1 May 2017

2017-05-01T19:34:18Z

Devika: Created page with "VARIF"

2017-05-01T19:22:49Z

Created page with "VARIF"

New page

VARIF

@@ Line 29: / Line 29: @@
 #VARIF([2,7,19,20,43,65,77,81],">10") = 764.1666666666666
 #VARIF([2,7,19,20,43,65,77,81],"<10") = 12.5
-#VARIF([10,25,18,FALSE],"<23") = 32
+#VARIF([10,25,18,FALSE],"<23") = 81.33333333333334
 ==Related Videos==

@@ Line 30: / Line 30: @@
 #VARIF([2,7,19,20,43,65,77,81],"<10") = 12.5
 #VARIF([10,25,18,FALSE],"<23") = 32
 ==See Also==

@@ Line 18: / Line 18: @@
 *This function is considering our given data is the sample of the population.
 *Suppose it should consider the data as the entire population, we can use the [[Manuals/calci/VARP  | VARP ]] function.
-*The arguments can be be either numbers or names, array,constants or references that contain numbers.
+*The array values can be be either numbers or names, array,constants or references that contain numbers.
 *Suppose the array contains text,logical values or empty cells, like that values are not considered.
 *When we are entering logical values and text representations of numbers  as directly, then the arguments are counted.
 *Suppose the function have to consider the logical values and text representations of numbers in a reference , we can use the [[Manuals/calci/VARA  | VARA ]] function.
 *This function will return the result as error when
-. Any one of the argument is nonnumeric.
+. Any one of the array value is nonnumeric.
 . The arguments containing the error values or text that cannot be translated in to numbers.

← Older revision		Revision as of 19:34, 1 May 2017
Line 1:		Line 1:
−	VARIF	+	<div style="font-size:30px">'''VARIF (Array,Condition,SumArray)'''</div><br/>
		+	*<math>Array</math> is the set of values.
		+	*<math>Condition</math> is the particular condition value.
		+
		+	==Description==
		+	*This function shows the Variance value of the given set which satisfies the given condition.
		+	*In <math>VARIF (Array,Condition,SumArray)</math>, <math>Array</math> is the set of values.
		+	*<math>Condition</math> is the particular condition which satisfies the variance values.
		+	*Variance is a measure of dispersion obtained by taking the mean of the squared deviations of the observed values from their mean in a frequency distribution.
		+	*i.e.,variance is a measure of how far each value in the data set is from the mean.
		+	*It is denoted by <math> \sigma </math>.
		+	*The square root of variance is called the standard deviation
		+	*To find the variance we can use the following formula:
		+	<math>Variance= \frac{\sum (x_i-\bar{x})^2}{n-1}</math>
		+	where <math> \bar{x}</math> is the sample mean of <math>x_i</math> and <math> n </math> is the sample size.
		+	*Suppose <math>\sigma = 0</math> which is indicating all the values are identical.
		+	*When <math>\sigma </math> is non-zero then it is always positive.
		+	*This function is considering our given data is the sample of the population.
		+	*Suppose it should consider the data as the entire population, we can use the [[Manuals/calci/VARP \| VARP ]] function.
		+	*The arguments can be be either numbers or names, array,constants or references that contain numbers.
		+	*Suppose the array contains text,logical values or empty cells, like that values are not considered.
		+	*When we are entering logical values and text representations of numbers as directly, then the arguments are counted.
		+	*Suppose the function have to consider the logical values and text representations of numbers in a reference , we can use the [[Manuals/calci/VARA \| VARA ]] function.
		+	*This function will return the result as error when
		+	1. Any one of the argument is nonnumeric.
		+	2. The arguments containing the error values or text that cannot be translated in to numbers.