Difference between revisions of "Manuals/calci/CHITEST"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
*Average means Sum of all the given elements is divided by Number of the given elements. | *Average means Sum of all the given elements is divided by Number of the given elements. | ||
*It is also called Arithmetic mean. i.e If n numbers are given and each number is denoted by a<math>i</math>, where <math>i</math>=1 to n, then <math>A.M = \frac{1}{n}\sum_{i=1}^n (ai)= \frac{a1+a2+.....+an}{n} </math>. | *It is also called Arithmetic mean. i.e If n numbers are given and each number is denoted by a<math>i</math>, where <math>i</math>=1 to n, then <math>A.M = \frac{1}{n}\sum_{i=1}^n (ai)= \frac{a1+a2+.....+an}{n} </math>. | ||
− | *In this function N1,N2,... are | + | *In this function N1,N2,... are it can either be numbers,arrays,references of cells or we can enter the logical values directly. |
− | *This function will show the result as Error, when the numbers are error values or text that cannot change | + | *This function will show the result as Error, when the numbers are error values or text that cannot change into numbers. |
− | *Also if the distribution is symmetric, then we can use this function to find the | + | *Also if the distribution is symmetric, then we can use this function to find the Central Tendency. |
− | *The three most common measures of | + | *The three most common measures of Central Tendency are: A.M, Median,& Mode. |
− | A.M: It is | + | A.M: It is calculated by adding the given set of numbers and divided by the count of the given set of numbers. |
+ | E.g:Average of 2,4,2,7,2,3 and 5 is 3.6 | ||
Median: It is the middle number of a sorted list(Ascending order) of numbers. E.g:The median of 2,2,2,3,4,5,7 is 3 | Median: It is the middle number of a sorted list(Ascending order) of numbers. E.g:The median of 2,2,2,3,4,5,7 is 3 | ||
Mode: It is the most frequently repeated number in a given set of numbers. E.g.The mode of 2,2,2,3,4,5 and 7 is 2 | Mode: It is the most frequently repeated number in a given set of numbers. E.g.The mode of 2,2,2,3,4,5 and 7 is 2 |
Revision as of 00:11, 25 November 2013
CHITEST(ar,er)
- is the array of observed values
- is the array of expected values
Description
- This function gives the Average for given set of numbers.
- Average means Sum of all the given elements is divided by Number of the given elements.
- It is also called Arithmetic mean. i.e If n numbers are given and each number is denoted by a, where =1 to n, then .
- In this function N1,N2,... are it can either be numbers,arrays,references of cells or we can enter the logical values directly.
- This function will show the result as Error, when the numbers are error values or text that cannot change into numbers.
- Also if the distribution is symmetric, then we can use this function to find the Central Tendency.
- The three most common measures of Central Tendency are: A.M, Median,& Mode.
A.M: It is calculated by adding the given set of numbers and divided by the count of the given set of numbers. E.g:Average of 2,4,2,7,2,3 and 5 is 3.6 Median: It is the middle number of a sorted list(Ascending order) of numbers. E.g:The median of 2,2,2,3,4,5,7 is 3 Mode: It is the most frequently repeated number in a given set of numbers. E.g.The mode of 2,2,2,3,4,5 and 7 is 2
- Sometimes CHITEST returns the error value, when ‘a’ and ‘b’ have a different number of data points.
Column1 | Column2 | Column3 | Column4 | |
Row1 | 45 | 38 | 0.000313 | |
Row2 | 10 | 23 | ||
Row3 | 12 | 26 | ||
Row4 | 40.5 | 49.36 | ||
Row5 | 19.56 | 16.44 | ||
Row6 | 17.05 | 17.41 |
Let’s see an example
B C
45 38
10 23
12 26
40.5 49.36
19.56 16.44
17.05 17.41
CHITEST (a, b)
i.e. =CHITEST (B2; C4, B5:C7) is 0.003