Question 246202: I need to know if it is necessary to change the alpha level on the Chi-Square function in Excel when an assignment asks to solve a problem with a = .01. If it is necessary, how do I change it? I have asked my instructor for help, and he is not willing to help me. For example, the particular problem I am having issues with is:
Sixty-four students in an introductory college economics class were asked how many credits they had earned in college, and how certain they were about thieir choice of major. Research question: At a = .01, is the degree of certainty independent of credits earned?
CREDITS EARNED VERY UNCER. SOMEWHAT UNCER. VERY CERTAIN ROW TOTAL
0-9 12 8 3 23
10-59 8 4 10 22
60 OR MORE 1 7 11 19
COLUMN TOTAL 21 19 24 64
I have seen this question answered on this website, but I need to know more about the process as to how the answer was derived. The instructor said we had to use the alpha level from the text, not choose to use whatever we like. Someone please help! It will be greatly appreciated.
From: Someone really struggling with Stats!
Answer by stanbon(75887)   (Show Source):
You can put this solution on YOUR website! I use the Chi-Sq test facility on a TI
calculator.
It generates a test statistic of
Chi-Sq = 14.7638
and a p-value of 0.0052
----
Comparing the p-value to the alpha=1%
I see that p is less than alpha so
I reject Ho.
---
If XCEL gives you the p-value when you
run the Chi-Sq Test you really don't
need the critical value for 1%.
---
Just for you information the degree of freedom
for your test is (# of rows -1)(# of columns -1) = 2*2 = 4
So the critical value from the Chi-Sq Table is 13.277
--------------------
Hope that makes sense.
Cheers,
Stan H.
|
|
|
