Difference between revisions of "Manuals/calci/CHITEST"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | ''' CHITEST | + | <div style="font-size:30px">'''CHITEST(ar,er)'''</div><br/> |
+ | *<math>ar</math> is the array of observed values | ||
+ | *<math>er</math> is the array of expected values | ||
− | + | ==Description== | |
+ | *This function gives the Average for given set 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 ai, where i=1 to n, then A.M= 1/n Summation i=1 to n (ai)= 1/n(a1+a2+.....+an). | ||
+ | *In this function N1,N2,... are either it can 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 in to 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 calculating 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. | *Sometimes CHITEST returns the error value, when ‘a’ and ‘b’ have a different number of data points. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
Line 82: | Line 85: | ||
i.e. =CHITEST (B2; C4, B5:C7) is 0.003 | i.e. =CHITEST (B2; C4, B5:C7) is 0.003 | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 23:52, 24 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 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 ai, where i=1 to n, then A.M= 1/n Summation i=1 to n (ai)= 1/n(a1+a2+.....+an).
- In this function N1,N2,... are either it can 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 in to 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 calculating 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