Adding error bars

- On this worksheet called Error Bars…we see a chart to the right of the data, a line chart.…There's a feature in Excel available on the…Chart Layout tab called Error Bars.…Click the drop arrow, you'll see some choices.…If you're a statistician you're familiar with the term…Standard Error means.…If you want to show vertical lines here that show a…different percentage-wise with these lines or…if you're familiar with standard deviation you might…choose one of these.…I'm gonna choose standard deviation first…and if you're familiar with this term it has something…to do with, in a sense, averaging the data,…figuring out the mean, and then more or less showing how…these numbers vary widely from that mean.…

If the data line here, the blue line, were flat or…in other words if there were not a lot variants…throughout the six month period these vertical lines…would be a lot shorter.…If this blue line were a lot steeper, these would be…certainly taller here.…Now, if you're not too familiar with statistical measures,…it might be better when you first look at Error Bars…