Тёмный

Violin Plots in Excel (without plug-ins...) | LAMBDA(), BYROW(), and Kernel Density Estimation 

Chris Armstrong
Подписаться 618
Просмотров 8 тыс.
50% 1

[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.

Опубликовано:

 

11 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 7   
@Bob-606
@Bob-606 11 месяцев назад
This tutorial is excellent. Cheers.
@spilledgraphics
@spilledgraphics 11 месяцев назад
sir, this is amazing, simply amazing.... I need to take a seat...wow!!
@spilledgraphics
@spilledgraphics 11 месяцев назад
minute 13....is so eye opening. Hat off!
@watchingwolf8092
@watchingwolf8092 4 месяца назад
The box plot, not too thin ? I think it is. (in my opinion 0:02 is better (diagram 2 on right)) amazing tutorial
@minakhihalder1811
@minakhihalder1811 17 дней назад
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
@ChrisArmstrongChemistry
@ChrisArmstrongChemistry 17 дней назад
=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%.
@minakhihalder1811
@minakhihalder1811 16 дней назад
@@ChrisArmstrongChemistry Thank you so much.🙏
Далее
Plotting Likert (agree/disagree) data in Excel
10:33
Просмотров 53 тыс.
How to make Violin plot #violin
6:34
Просмотров 1,4 тыс.
Standoff 2 is a true horror! #standoff #horror #meme
00:13
БЕЛКА РОЖАЕТ?#cat
00:28
Просмотров 132 тыс.
Conditional Formatting for Graphs and Charts in Excel
11:52
Quantitative Data Analysis for Survey Research
2:15
Просмотров 13 тыс.
Minesweeper in Excel (with no VBA...)
8:14
Просмотров 1,4 тыс.
Better Charts and Error Bars in Excel
15:59
Cursor Is Beating VS Code (...by forking it)
18:00
Просмотров 62 тыс.