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

Question:

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 χ2 value with a significance level of 5% and 1%. What Excel function would you use to fi nd 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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: