a. CHISQ.TEST
Step-by-step explanation:
The Notation and previous concepts
A chi-square test is "used to test if variance of population is equal to a specified value.
This test can be either two-sided test or a one-sided test.
The two-sided version tests against alternative that the true variance is either less than or greater than the specified value"
The statistic is given by:
x² = Σ=1 (Oi- Ei)² / Ei
In order to calculate p value we need to have in count the degrees of freedom, on this case df=(rows-1) (#cols- 1). And we can calculate p value would be given by:
Pv = P(χ² > χ²cal)
But correct comand is given by:
a. CHISQ.TEST(Actual range, Expected range)
We just need to put in one column Observed values and in other expected values.
learn more about Chisq test at
https://brainly.com/question/4543358
#SPJ4
