How to Use Chi | chi-square distribution excel
SomestatisticalmeasuresinExcelcanbeveryconfusing,butchi-squarefunctionsreallyarepractical.Evenifyou’regoingtouseonlyoneofthechi-squarefunctions,readthroughallthreefunctiondescriptions.Viewedasasetofstatisticaltools,thefunctionsmakequiteabitmoresense.CHISQ.DIST.RT:Chi-squaredistributionTheCHISQ.DIST.RTfunction,whichcalculatestheright-tailedprobabilityofachi-squareddistribution,calculatesalevelofsignificanceusingthechi-squarevalueandthedegreesoffreedom.Thechi-squarevalueequalsthesumofthesquare...
Some statistical measures in Excel can be very confusing, but chi-square functions really are practical. Even if you’re going to use only one of the chi-square functions, read through all three function descriptions. Viewed as a set of statistical tools, the functions make quite a bit more sense.
CHISQ.DIST.RT: Chi-square distributionThe CHISQ.DIST.RT function, which calculates the right-tailed probability of a chi-squared distribution, calculates a level of significance using the chi-square value and the degrees of freedom. The chi-square value equals the sum of the squared standardized scores. The function uses the syntax
=CHISQ.DIST.RT(<i>x</i>,<i>deg_freedom</i>)where x equals the chi-square value and deg_freedom equals the degrees of freedom.
As an example of how all this works, suppose you’re more than a little suspicious of some slot machine that shows one of six pictures: diamonds, stars, cowboy boots, cherries, oranges, or pots...