Error Bars in Excel

Error bars on a chart/graph provide a visual representation of our uncertainty of knowledge about the values of the data points. These are helpful in understanding the accuracy of our data and have the benefit of being relatively easy to interpret. We are going to discuss how to add error bars to charts in Excel [...]

By |2020-11-16T18:09:20-07:00October 22nd, 2020|Error bars, Excel, Tutorials and How-Tos|0 Comments

Excel 2016 How-to: Using the Correlation Tool

Excel's AnalysisToolPak offer a variety of routines for analyzing statistical, scientific and engineering data. In this articular we are going to look at how to use the correlation tool in the Analysis ToolPak. Enable the Analysis ToolPak: Although already installed with Excel, the Analysis ToolPak will need to be enabled through the Options menus. For [...]

By |2019-08-15T19:06:19-06:00July 20th, 2017|Excel, Tutorials and How-Tos|0 Comments
Go to Top