Sunday, November 3, 2019

Excel tips for min/max report

When putting together the min/max report, the following links came in handy:

To create the secondary axis, select a data series, and select "Format Data Series", then in Series Options find the option for "Secondary Axis".
https://www.extendoffice.com/documents/excel/2019-excel-make-two-y-axis.html
How to turn on the X and Y axis labels: Find the + sign for "Chart Elements" floating on the right side of the graph and select "Axis Titles". Also you can do any combination of X primary, X seconday, and Y axis labels:
https://www.extendoffice.com/documents/excel/1570-excel-add-axis-label.html#a2
Histograms are built in for Excel 2016. Also I found by trial and error that in order to restrict bin boundaries to the number of desired significant digits, the overflow bin has to either contain some data or be close to the first bin:
https://trumpexcel.com/histogram-in-excel/
Excel has a STDEV function: https://social.msdn.microsoft.com/Forums/en-US/0d8edea2-f08e-41b7-b120-8ac08855c23b/difference-between-stdev-amp-stdevp?forum=sqlanalysisservices
Here's a nice article explaining Mean, Median, and Mode: https://www.purplemath.com/modules/meanmode.htm