Forum Discussion
ExcelGeek90
Jan 16, 2025Brass Contributor
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 fo...
JKPieterse
Jan 16, 2025Silver Contributor
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?
- ExcelGeek90Jan 22, 2025Brass Contributor
Thank you for your response. I will try regression analysis now.
I like your detailed answer btw :)