Answer:
2.45
Step-by-step explanation:
B+16.12=18.57. Take the sum and the given value and subtract the given value from the sum. You can do this on all problems like this.
Answer:
b. CHISQ.TEST
Step-by-step explanation:
Notation and previous concepts
A chi-square test is "used to test if the variance of a population is equal to a specified value. This test can be either a two-sided test or a one-sided test. The two-sided version tests against the alternative that the true variance is either less than or greater than the specified value"
The statistic is given by:

In order to calculate the p value we need to have in count the degrees of freedom , on this case
. And we can calculate the p value would be given by:
But the correct comand is given by:
b. CHISQ.TEST(Actual range, Expected range)
We just need to put in one column the Observed values and in other the expectec values.
Im not sure if you wrote this wrong because (x+y)2 does equal x2+y2. An example would be if x equals 3 and y equals 4 (3+4)2=(3)2+(4)2 (7)2=6+8 14=14.