A colleague of mine has asked me for help on this problem, but I am confused with it as well, the main question he asked me was that the chi-square result he was getting was very high.
He conducted a survey, and among other questions, one of them is a question which has 8 sub-questions about certain processes in company of examinees and the examinees have to give their grade of the quality of those processes by choosing values from 1 (bad) to 5 (great) (classical Likert scale).
There is one other value (sixth) that can be selected which is causing me trouble aside from the main problem. That sixth option is titled "N/A" and means that the examinees don't have that process in their company. Enough for intro (hopefully).
So the data table he made in Excel (for one subquestion) looks like this (there were 195 examinees in total):
I wonder why did he assume that theoretical frequencies (f$\_t$) are fixed to 32,5 (shown as rounded to 35 in data table) for all values? My opinions is that he is wrong, and that the theoretical frequencies should be these (and if not these, for sure not the same for every mark):
The chi-square value is even greater now. I am not even sure why does he calculate it in this fashion in Excel.
My opinion that for this data set chi-square value should be calculated with CHITEST function of the following syntax (cell addresses are as in Image 2.):
That way i get a chi-square value of 1,26177E-44, which I think is ok.
Please help me, all I thought I know or knew on topic seems to be vanished now. Sorry if any terms are not understandable, English is not my primary language. If any clarification is required, I'll do my best.
Thank you in advance for your time and knowledge and sorry that images are not automatically displayed, I need to gain more reputation in order to enable them.