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 |
| * For an illustrated example refer to the page under Distributions * 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