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:
a The number of degrees of freedom for a contingency table with three rows and four columns can be calculated using the following formula df r 1 c 1 w...View the full answer
Answered By
Ashish Bhalla
I have 12 years work experience as Professor for Accounting, Finance and Business related subjects also working as Online Tutor from last 8 years with highly decentralized organizations. I had obtained a B.Com, M.Com, MBA (Finance & Marketing). My research interest areas are Banking Problem & Investment Management. I am highly articulate and effective communicator with excellent team-building and interpersonal skills; work well with individuals at all levels.
17+ Reviews
46+ Question Solved
Related Book For 
Question Posted:
