CHISQ.TEST (PQL - xl)

This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

CHISQ.TEST(actual range, expected range)

Function Arguments

Name

Description

Type

Optional

actual range

Array of observed values to test against expected values

StringOrNumber

expected range

Array of expected values against which to test observed values

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'CHISQ.TEST' function - using the same inputs, logic and outputs.