Applied Data Management Charts and Graphs
From Free Knowledge Base- The DUCK Project: information for everyone
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 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.