I have the following scales:
1 (Strongly Disagree);
2 (Disagree);
3 (Not Applicable);
4 (Agree);
5 (Strongly Agree);
Questionnaire responses:
Question Item1: 2;
Question Item2: 3;
Question Item3: 1;
Question Item4: 1;
Question Item5: 4;
If I need to average the above responses into the Excel Sheet, while treating Question Item2: as null (since it is being excluded from the equation), Which of the formula (attached) is more appropriate to adopt and why?
Kindly advise.
1 (Strongly Disagree);
2 (Disagree);
3 (Not Applicable);
4 (Agree);
5 (Strongly Agree);
Questionnaire responses:
Question Item1: 2;
Question Item2: 3;
Question Item3: 1;
Question Item4: 1;
Question Item5: 4;
If I need to average the above responses into the Excel Sheet, while treating Question Item2: as null (since it is being excluded from the equation), Which of the formula (attached) is more appropriate to adopt and why?
Kindly advise.