# Graphical Correlation between Discrete X,Y

Six Sigma – iSixSigma Forums Old Forums General Graphical Correlation between Discrete X,Y

Viewing 8 posts - 1 through 8 (of 8 total)
• Author
Posts
• #32228

Kannan
Participant

Folks
I have a case of a discrete X and a discrete Y I am interested in representing graphically correlationships. For example Salesmen (5) against Product Source (5 Warehouses). I have already used pivot tables and stackup histograms…but want a better graphical representation. Any suggestions?

0
#85847

Ed VanHaute
Participant

If there is a relationship between the salesmen and the warehouses, you can use a dot plot with a regression equation included. I am guessing, however, that the salesmen and the warehouses are both X’s, and you have yet to identify the Y. When you do, use a matrix plot, multi-vari analysis, and/or a multiple regression analysis toshow the relationship between your inputs and outputs

0
#85860

Kannan
Participant

Thanks for your response. I do know the Y and the Y is Delivery Time. I agree with you on both being Xs but this is only to establish a relationship. Also just for you to know the salesman as per a moods median test (non-normal data) is not a critical X. I am still not clear of using a regression equation for discrete Xs.

0
#85874

Zilgo
Member

You could run a correlation/covariance analysis to see whether or not your Xs are correlated.  A scatterplot of each X versus another will show that if you need it graphically.
As far as running a regression analysis on discrete X I am going to assume that you really have multiple level categorical data which means you need to run a logistic regression.  If your data has order to it, such as a Likert scale you should use Ordinal Logistic Regression.  If Salesman A could swich places with Salesman B, ie call A B and call B A, you should use nominal logistic regression.  What the correlation analysis will tell you is which two level factors need to be included when you input the model.  What it won’t tell you is which higher order interactions (three and four way) need to be included.

0
#86454

Swaggerty
Participant

Here’s a simple graph:  square the correlation to get the shared variance between X & Y.  Multiply by 100 to get a percentage.  Plot the percentages in a bar chart and call it “Leverage”.  E.g., this is what salesman X needs to leverage.

0
#86472

Mike P
Participant

Use a radar chart (aka spider chart, star plot).  The warehouses will be on the outside edge of the chart, with each as one edge of a pentagon.  Results for each of the five salesmen at each warehouse will be plotted on the inside of the chart with their results color-coded by salesman and the dot of each salesman at each warehouse connected.
The result is a single, data-rich graph that will show:

how each salesman performed at each warehouse
how each salesman performed relative to each of the other salesmen at each warehouse
the overall ranking of the salesmen (which is the total area of the graph enclosed by their connected points).
http://www.itl.nist.gov/div898/handbook/eda/section3/starplot.htm

0
#86491

Jonathon
Participant

You mention pivot tables, but have you tried a pivot chart? They are pretty powerful, especially if you create a dual-axis chart. That is, the chart holds an X1 and X2 as variables, and displays “towers” for each X1-X2 comnbination. It’s pretty cool stuff, but you need Office 2000 or later.

0
#86504

John Noguera
Participant

Hi Jonathon!
How’s the book coming along?
I wanted to mention that SigmaXL creates pivot charts for Excel ’97.
Also, I wanted to mention that SAS JMP has a similar powerful tool for Discrete X and Discret Y that they call Mosaic Plots.

0
Viewing 8 posts - 1 through 8 (of 8 total)

The forum ‘General’ is closed to new topics and replies.