Survey Analysis - All Questions
Consider a question with multiple responses. Which of these magazines do you subscribe to? Obviously people could check more than one magazine. Lets assume 50 people answered this question. Count Percentage totals all the checks = the total number of magazines. Assume the total number of checks was 150. If Time magazine was checked 15 times, the Count percentage would be 15/150 = 10%. The Respondent Percentage refers to how many people answering the question, checked this choice. In this magazine subscription example, 15 of the 50 people checked the box so the respondent percentage is 15/50 = 30% Rounding
WISCO Survey uses the same calculation methods, including rounding, used by Microsoft Excel. Rounded percentages can sometimes total to 99% or 101%. Why? Consider this example, and how rounding would (should) occur. The example numbers were picked for easy calculations, but you can see that rounding will usually create some variation from the exact value. The greater the number of choices, the larger the fluctuations will be from the true value. This variation is not a mistake with either WISCO Survey or Microsoft Excel.
Actual | Rounding | Actual | Rounding | |
Choice A: | 20.2% | 20% | 20.6% | 21% |
Choice B: | 20.2% | 20% | 20.6% | 21% |
Choice C: | 20.2% | 20% | 20.6% | 21% |
Choice D: | 20.2% | 20% | 20.6% | 21% |
Choice E: | 19.2% | 19% | 17.6% | 18% |
Total | 100% | 99% | 100% | 102% |
If the columns are too narrow (or too wide) to display your survey data properly, the column widths can be changed. Place your cursor to the side of the column you wish to resize, then slowly move it until the cursor changes to a sizing arrow. Click the mouse button and hold it down. Still holding the mouse button down, drag the cursor to the left or the right to increase or decrease the width of the column. For additional help with question types, check out the training tutorials. Importance (used with Rank Order Questions)
Importance is determined by the rank of the item and the number of respondents selecting an item and rank. From a list of items, a respondents ranks items, first, second, third, etc. Importance is calculated by assigning points to the rank for each item, with the highest ranking item receiving the highest number of points. For each respondent, a first place rank is assigned the maximum number of points, second place is assigned (Maximum-1), third place is assigned (Maximum-2), etc. Then the points are added to calculate the importance. With this simple example, respondents are choosing their top 3 choices. A first place rank is assigned 3 points. The orange is the most important choice (6 points), even though two other choices (Avacodo and Banana) have a higher average ranking.
Fruits | Respondent A | Respondent B | Respondent C | Importance | Average |
Avocado | 1=3points | 3 points | 1.00 | ||
Apple | 2=2points | 2 points | 2.00 | ||
Banana | 1=3points | 2=2points | 5 points | 1.50 | |
Orange | 2=2points | 3=1point | 1=3points | 6 points | 2.00 |
Pear | 3=1point | 3=1point | 2 points | 3.00 |