(funky music)
- Hello I am professor Rick Jers
and I welcome you to this session
titled Box Plots in Tableau.
Box plots are important statistical figures
used to describe data.
So let's see if we could do this in Tableau.
I think you're going to enjoy this session.
Let's get started.
Okay let's create a box plot.
Remember a box plot shows the minimum value,
the maximum value, the middle value,
which is defined as the median
and the inner 50 percentile
defined by the position of the first quartile
and the third quartile.
How do we do this in Tableau?
I have provided to you a real estate data set
that contains sales of homes
from the North Valley real estate company.
We will use this data set
to create our charts using Tableau.
I begin by opening Tableau
and connecting to this Excel real estate file.
Immediately the data is brought into Tableau.
I am going to work on sheet one.
Let's begin by creating a new sheet
and we will name this Box Plot.
Our goal in producing this box plot
is to actually produce a box plot for each real estate agent
and see how their sales compare.
Okay here we go.
Drag agent to column, and price to rows.
Right-click on the y-axis
and choose to add a reference line box plot.
Go ahead and hide the underlying marks
and extend the whiskers to maximum.
Change the color to purple.
Add Price to Detail
and then change the Price in Detail to a dimension.
Change automatic marks to Circle, and fit to all.
At this point we have a box plot for all the agents.
If we want to show the underlying data as a dot plot
we can edit the reference line
and show the underlying marks.
We might need to re-size these marks
to something that looks visually attractive.
We can color these dots by dragging price to color
and adjusting the colors to something
that we find more attractive.
Wow, there we have it, box plots for each agent
showing the characteristics of their sales.
We can see that Marty sells homes
within a very narrow price range,
whereas Peterson's spread of price range for sales
are more dispersed,
and Peterson does seem to sell
some more expensive homes than others.
Go ahead and study these box plots for a little while
and see what you can detect.
Well there we have it, a box plot in Tableau.
I would probably have to agree with you
that producing some of these charts,
like a box plot in Tableau,
is not necessarily intuitively easy.
I had to do a bit of research both in the Tableau videos
and online to figure out how to do this.
I'm glad I've made this video
because sometimes I have to refer back to it
when I want to create box plots.
What I would suggest doing
after you have finished this assignment
is to go back and repeat it.
Repeating what you have done will help you learn
how to use this Tableau product.
(funky music)
Thanks for taking time to spend some moments with me.
I hope that you have enjoyed what I have shared with you.
If you ever have any questions or need my help
please let me know.