1.) A variable contains seven categories. It is expected that data are uniformly distributed across these seven categories. To test this, a sample of observed data is gathered on this variable resulting in frequencies of 27, 30, 29, 21, 18, 33 and 24. What is the value of test statistic equals to, using a significance level of 1%?
a. 18.475
b. 10.645
c. 6.46
d. 0.374
Please show me how to calculate the 6.46 in Excel.