Introduction to a variety of useful statistical ideas and techniques - Improving the User Experience through Practical Data Analytics - page 19

SIDEBAR: HOW TO DISPLAY CONFIDENCE INTERVALS ON A BAR CHART
IN EXCEL—cont'd
2. Set the values from Step 1 in a simple table in Excel. Here's an example using a simple data set
of likelihood of adoption ratings for two different designs:
3. Create a standard chart of just the means and associated column headers:
4. Select your means column. Then, click on the “Chart Layout” tab. From the “Error Bars”
dropdown, choose “Error Bars Options.” In the results dialog box, click on the “Custom” radio
button option in the “Error Amount” section; then click on the “Specify Value” button. In the
“Custom Error Bars” pop-up, enter the same value for both the positive and negative error
values. In both cases, these will be the “e” you previously calculated. (You can either type in the
value or navigate to the value in your spreadsheet using the standard Excel selection control.)
Continued