Applied Data Management Charts and Graphs
Summarize and Display Survey Data
You ask people to rate something on a scale, such as 1 to 5 for example, and you record that data. This might be a scale where 1 represents worst and 5 best, or something similar.
Crate Graph:
For making comparisons between questions (such as between different websites), use the following:
- mean
- standard deviation
- total response count
- confidence interval
We need to calculate the "Confidence Interval" while Excel has "Confidence Level" in the Data Analysis Tool.
Confidence Level- Use a confidence level to describe uncertainty associated with the interval estimate. It seems like you just make an educated guess to come up with this. Like, "I think this sample of people from a larger group probably is about 95% representative of what everyone would likely say if we had the resources to have everyone surveyed. A 95% confidence level implies that 95% of the confidence intervals would include the true population parameter.
Confidence Interval - Statisticians use a confidence interval to express the degree of uncertainty associated with a sample statistic. A confidence interval is an interval estimate combined with a probability statement. Confidence intervals are preferred to point estimates and to interval estimates, because only confidence intervals indicate (a) the precision of the estimate and (b) the uncertainty of the estimate.
standard deviation & confidence level & mean
References:
