CHISQ.TEST |
CHISQ.TEST(actual_range, expected_range) |
Returns the probability value from a chi-squared distribution. |
actual_range | The data containing observations to test against expected values. |
expected_range | The data containing the ratio of the product of row totals and column totals to the grand total. |
REMARKS |
* The chi-squared distribution is a [[continuous distribution]] * You can use the CHISQ.DIST function to return the probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). * You can use the CHISQ.DIST.RT function to return the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). * You can use the CHISQ.INV function to return the inverse of the probability distribution function for a chi-squared distribution (left tailed). * You can use the CHISQ.INV.RT function to return the inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). * This is similar to the F.TEST, T.TEST and Z.TEST functions. * This function was added in Excel 2010 to replace the CHITEST function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top