Manuals/calci/CHITEST
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