SOLUTION: 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

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.
RELATED QUESTIONS
In this exercises, include MegaStat, Excel, or MINITAB exhibits to support your... (answered by stanbon)

In this exercises, include MegaStat, Excel, or MINITAB exhibits to support your... (answered by stanbon)

When this assignment is completed please send it to my graduate assistant (email address... (answered by solver91311)

Hi, I am having problems with a chi-square related question. Here is the question: (answered by stanbon)

imagine if our data that is originally collected is categorical in nature. In other... (answered by stanbon)

All assignments will only be accepted in Word 2003 (.doc) format. That means if you do an (answered by solver91311)

a.What is the F critical value to be used at the 0.05 level of significance with 7... (answered by stanbon)

What is all the possible subsets that can be achieved from 1 to 28??? Can be send on an... (answered by Alan3354)

Solve the problem find the chi-square value x 2 over L corresponding to a sample size of... (answered by stanbon)