CHISQ.TEST (ActualValues, ExpectedValues) CHISQ.TEST (ActualValues; ExpectedValues)

ActualValues

The observed values. This array must have the same size as the other array parameter.

ExpectedValues

The expected values. This array must have the same size as the other array parameter.

Returns

Number Number

The result of a chi-squared test.

Returns the result of a chi-squared test, comparing observed values with expected values. The result is the probability that differences at least this large between the observed and the expected values arise by chance. A small result, such as one below 0.05, indicates that the observed values do not follow the expected values.

Example

CHISQ.TEST ({ 58, 11, 10 }, { 45.35, 17.56, 16.09 })
CHISQ.TEST ({ 58; 11; 10 }; { 45,35; 17,56; 16,09 })

Returns roughly 0.016.

CHISQ.TEST (ActualMatrix, ExpectedMatrix) CHISQ.TEST (ActualMatrix; ExpectedMatrix)

ActualMatrix

The observed values. This two-dimensional array must have the same number of rows and columns as the other array parameter.

ExpectedMatrix

The expected values. This two-dimensional array must have the same number of rows and columns as the other array parameter.

Returns

Number Number

The result of a chi-squared test for independence.

Returns the result of a chi-squared test for independence, comparing observed values with expected values given as two-dimensional arrays. A small result, such as one below 0.05, indicates that the observed values do not follow the expected values.

Example

CHISQ.TEST ({ { 58, 35 }, { 11, 25 }, { 10, 23 } }, { { 45.35, 47.65 }, { 17.56, 18.44 }, { 16.09, 16.91 } })
CHISQ.TEST ({ { 58; 35 }; { 11; 25 }; { 10; 23 } }; { { 45,35; 47,65 }; { 17,56; 18,44 }; { 16,09; 16,91 } })

Returns roughly 0.0003.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell