This question already has an answer here:
- How does the standard error work? 3 answers
I have a bunch of survey responses from people all over the country. Each survey has one question: "How much do you like X?" (X isn't important here), where answers range from 0 (not at all) to 100 (a lot).
I want to group the results by (for example) State. However, when I group things by State, some of these groups have a couple hundred responses, whereas others might have fewer than 10.
I want to take an average of my results by State, but States with few responses are going to potentially be misleading.
So I've been asked to add a "confidence rating" so people can determine which averages are meaningful, which aren't, etc, and I'm not sure how to properly quantify / include this sort of metric.
Making up an example:
State Num Responses Average Rating Rhode Island 4 96 Texas 124 77 Alaska 2 100 Arizona 15 55 Washington 23 76 California 34 67