XYZ 3D Scatter Plot in Excel using BESH Stat

Excel doesn’t offer a built-in 3D scatter plot. It do offer a 3D line chart (multiple line series presented side by side) but that cannot be easily adapted to scatter plot unless one of the variables is  integer with only handful of distinct values. Recently I discovered a Gabor’s Doka the 3D scatter plot for …

Missing values in BESH stat

Missing values in BESH stat Note1: BESH stat works only with numeric data (unless it is an ID column) so the text data are treated as missing. When talking about missing data I mean text string values as well. Note2: If you have a text categorical value in your data then create a numerical format …