A business consultant requests that you perform some preliminary calculations before analysing a data set using Excel. (a) Calculate the number of degrees of freedom for a contingency table with three...

A business consultant requests that you perform some preliminary calculations before analysing a data set using Excel.

(a) Calculate the number of degrees of freedom for a contingency table with three rows and four columns.

(b) Find the upper tail critical
 value with a significance level of 5% and 1%. What Excel function would you use to find this value?

(c) Describe how you would use Excel to calculate the test p-value. What does the p-value represent if the calculated chi-square test statistic equals 8.92?