[Slip to about 9:25 for the formula if you don't need the explanation of how to put it together.]
Have you wanted to implement a violin plot as a more visually intuitive alternative to a box and whisker chart? But found that you've only got your favourite cursed accountancy programme to make it? Annoyed that the built-in box plot option is actually a bit rubbish?
You should probably do it properly with actual statistics software...
But that's lame and boring. So, instead, you can do Kernel Density Estimation (KDE) on your data by using BYROW() to work out the density of your data at each point in your range by summing NORM.DIST() over your data. It's that easy. Mostly.
Негізгі бет Violin Plots in Excel (without plug-ins...) | LAMBDA(), BYROW(), and Kernel Density Estimation
No video
Пікірлер: 7