CHITEST (PQL - xl)

This function calculates the test for independence from the chi-squared distribution

Syntax

CHITEST(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 'CHITEST' function - using the same inputs, logic and outputs.