Violin Plots in Excel (without plug-ins...) | LAMBDA(), BYROW(), and Kernel Density Estimation
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- [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.
This tutorial is excellent. Cheers.
The box plot, not too thin ? I think it is. (in my opinion 0:02 is better (diagram 2 on right))
amazing tutorial
sir, this is amazing, simply amazing.... I need to take a seat...wow!!
minute 13....is so eye opening. Hat off!
What value i should use in the sequence when my data are in between 0.5-3.0?
Your video is awesome but its not working in my data range
=SEQUENCE(25,1,0.5,0.1) will get you a range going from 0.5 to 3.0 at 0.1 intervals instead of something normalised to 100%.