According to the official site of Microsoft there is no difference in the definitions of CHITEST and CHISQ.TEST.
Definition:
A chi-squared test, also referred to as chi-square test or
test, is any statistical hypothesis test in which the sampling distribution of the test statistic is a chi-squared distribution when the null hypothesis is true. Also considered a chi-squared test is a test in which this is asymptotically
true, meaning that the sampling distribution (if the null hypothesis is
true) can be made to approximate a chi-squared distribution as closely
as desired by making the sample size large enough.
Sources:
http://office.microsoft.com/en-in/excel-help/chisq-test-function-HP010335674.aspx
http://en.wikipedia.org/wiki/Chi-squared_test
Definition:
Returns the test for independence. It returns
the value from the chi-squared (χ2) distribution for the statistic
and the appropriate degrees of freedom. You can use χ2 tests to
determine whether hypothesized results are verified by an experiment.
Syntax: (actual_range,expected_range)
Actual range is the range of data that contains observations to test against expected values.
Expected range is the
range of data that contains the ratio of the product of row totals and column
totals to the grand total.
Usage: Chi-square is commonly used to compare observed data with data expected to obtain according to a specific hypothesis.
What is Chi Test or Chi Square test: The Chi-Square distribution is the distribution of the sum of the
squares of a set of normally distributed random variables. Its value
stems from the fact that the sum of random variables from any
distribution can be closely approximated by a normal distribution as the
sum as samples size increases. Thus the test is widely applicable for
all distributions.
A chi-squared test, also referred to as chi-square test or
test, is any statistical hypothesis test in which the sampling distribution of the test statistic is a chi-squared distribution when the null hypothesis is true. Also considered a chi-squared test is a test in which this is asymptotically
true, meaning that the sampling distribution (if the null hypothesis is
true) can be made to approximate a chi-squared distribution as closely
as desired by making the sample size large enough.Sources:
http://office.microsoft.com/en-in/excel-help/chisq-test-function-HP010335674.aspx
http://en.wikipedia.org/wiki/Chi-squared_test
No comments:
Post a Comment