Please note javascript is required for full website functionality.


A to Z of Excel Functions: the CHISQ.TEST Function

24 February 2017

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the CHISQ.TEST function.


The CHISQ.TEST function

In probability theory and statistics, the chi-squared distribution (also chi-square or χ2-distribution) with k degrees of freedom is the distribution of a sum of the squares of k independent standard normal random variables.  It is one of the most widely used probability distributions in inferential statistics, e.g. in hypothesis testing or in construction of confidence intervals. 

The chi-squared distribution is used in the common chi-squared tests for goodness of fit of an observed distribution to a proposed theoretical one, the independence of two criteria of classification of qualitative data, and in confidence interval estimation for a population standard deviation of a normal distribution from a sample standard deviation.

If Z1, ..., Zk are independent, standard normal random variables, then the sum of their squares

is distributed according to the chi-squared distribution with k degrees of freedom. This is usually denoted as: