I have put Multiple Choice Questions (MCQ) in the same category because, whilst having distinctly different purposes and theoretical underpinning from Likert Scales (choices in a Likert are usually of an ordinal nature MCQs can be nominal), their functionalities on Excel are virtually identical. (Although if you have a 99-point scale, you might as well use a continuous scale measure, or risk a stern question from your Reviewer.) Whether it be 3-, 7- or 99-point scale, Excel can handle the presentation and collection of this scale easily. Likert Scale is probably the most popular and widely used instrument to investigate attitudes and beliefs. How to create a Likert scale and Multiple Choice Response item. I'm just going to show you how each one can be easily presented and captured using Excel in the following entries. I'm not going into what you should use for your study. Multiple options (where you can choose more than one of several options).Multiple choice response (where you can only choose one of several options).Your typical social science survey usually employ more than one of the following response modes: It might be time to actually get into it. I've spent the last two posts harping on about the advantages of doing surveys and experiments using Excel and VBA.
0 Comments
Leave a Reply. |