Difference between revisions of "Manuals/calci/VARPIF"
Jump to navigation
Jump to search
(Created page with "VARPIF") |
|||
| Line 1: | Line 1: | ||
| − | VARPIF | + | <div style="font-size:30px">'''VARPIF (Array,Condition,SumArray)'''</div><br/> |
| + | *<math>Array</math> is the set of values. | ||
| + | *<math>Condition</math> is the particular condition value. | ||
| + | |||
| + | ==Description== | ||
| + | *This function gives the variance based on the entire population which satisfies the given condition. | ||
| + | *In <math>VARPIF (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 entire population. | ||
| + | *Suppose it should consider the data as the sample of the population, we can use the [[Manuals/calci/VAR | VAR ]] function. | ||
| + | *The arguments can 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/VARPA | VARPA ]] function. | ||
| + | *This function will return the result as error when | ||
| + | 1. Any one of the argument is non-numeric. | ||
| + | 2. The arguments containing the error values or text that cannot be translated in to numbers. | ||
| + | |||
| + | ==Examples== | ||
Revision as of 13:50, 4 May 2017
VARPIF (Array,Condition,SumArray)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of values.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Condition} is the particular condition value.
Description
- This function gives the variance based on the entire population which satisfies the given condition.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle VARPIF (Array,Condition,SumArray)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of values.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Condition} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sigma } .
- The square root of variance is called the standard deviation.
- To find the variance we can use the following formula:
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Variance= \frac{\sum (x_i-\bar{x})^2}{n-1}} where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{x}} is the sample mean of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x_i} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n } is the sample size.
- Suppose Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sigma = 0} which is indicating all the values are identical.
- When Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sigma } is non-zero then it is always positive.
- This function is considering our given data is the entire population.
- Suppose it should consider the data as the sample of the population, we can use the VAR function.
- The arguments can 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 VARPA function.
- This function will return the result as error when
1. Any one of the argument is non-numeric.
2. The arguments containing the error values or text that cannot be translated in to numbers.