Forum Discussion
Which graph is best to show positive and negative relationship of different variable to one output?
Hi everyone,
I am working on a business case study where I have to show a realtionship of 6 x (x1,x2,x3,x4,x5,x6) to a single output (y) . now x1,x2 & x3 have positive relationship with output y for example if x1,x2 and x3 are higher the better for output y
but x4,x5,x6 have negative relationship with output y for example if x4,x5,x6 are lower the better for output of y
I am struggling to understand which graph should I used or which technique should I used to show on a dashboard that why Y was not achieved based on different behaviors of x1,x2,x3,x4,x5 and x6.
Waiting for an answer.
thanks
2 Replies
plotting 6 variables in any meaningful way is very difficult.
Perhaps you could try to create a 3D chart with only the two most important factors on the x-axes?
You could expand that by having a grid of charts where the other variables are varied
In my experience, there are often also interactions between the variables (a*x1*x2, b*x2*x3, ...). Have you taken that into account in your regression analysis?
Thank you for your response. I will try regression analysis now.
I like your detailed answer btw :)
