• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a BeanPlot in Excel

jrek67

New Member
Hello


I'm contemplating on the possibility to do a Bean Plot in Excel. In theory, there should be possible to do a horizontal Bean Plot with Area graph and Bar Graph combined.


Do you have any ideas how to start/think/design this? Is it possible?
 

Faseeh

Excel Ninja
Hi jerk67,


Kindly have a look at this file:


http://dl.dropbox.com/u/60644346/Vilon%20Plot_Trail.xlsx


& this thread:

http://chandoo.org/forums/topic/violin-plots-in-excel


Waiting for feedback.


Regards,

Faseeh
 

keymaster

New Member
Hi Jrek67,


You can create this in Excel using scatter plots. There are 3 parts to it:

1. the violin plot using smothed lines showing the probability density

2. The actual data points as rug plot

3. the quartiles as lines (ala box plot)


The process of calculating probability densities is the trickiest. This depends on your data and what your actual population looks like.


For an example, I took recently conducted Excel salary survey data. Since this data is varied, I considered data points between $15,000 and $100,000 (in other words, salaries in developed countries) and used it to generate bean plot. As you can guess, this range of salaries followed normal distribution, so I used normal distribution densities. (I may be wrong in assuming this)


See the example chart here:


http://img.chandoo.org/playground/bean-plot%20v1.xlsx
 

jrek67

New Member
Thank you Faseeh and Chandoo. You have made my day.


I thought it would require VBA or other solution.


I'm really impressed that I got an answer this quick.


Now it's up to me to vizualise my data.
 
Top