![]() Q: How could You able to see - what are position of plots in those axis. There could see two axes smoothy and z-axes - could be need more? It would look something same as my the 1st sample. If that data is something same as You've given In order to properly conceptualise and make sense of my specific type of data really need to be able to see each axis with its scale in a clear 3D space, and with plot points corresponding to each variable - bars dont make sense in the this case. The label for each plot point should be the names of the variables.įYI - I will ultimately reduce the number of variables in the plot - before i do so I need to see how many will fit on with data labels before it becomes too crowded. So I want the X axis to be the % shared variance that each other variable shares with the row 2 variable "Happy", the Y axis to be the % shared variance that each other variable shares with the row 3 variable "has direction" and the Z axis to be the % shared variance that each other variable shares with the row 4 variable "Assertive". Because correlation coefficients are non linear, to enable useful visual representation these are then squared and transformed into percentages to create shared variance scores, as presented in the attached file. "focused on others" and "puts others needs first"). ![]() This person has rated a list of people they know on each of these constructs, which has allowed the creation of an matrix to show how much each of their contructs is correlated with one another (and therefore shares a similar meaning for this person - e.g. If it helps to know, the variables in this worksheet are a persons psychological constructs that they use to make sense of their social world, "Has direction", "clarity of Thought", "Tactful" etc. Ideally I would like to add a third variable Z to form an X-axis and make a 3D scatter plot!Īpologies, file attached, with where I've got up to with the chart. It would be great if someone could tell me how to do this in Excel. I've attached some example data and a mockup of the type of chart I'm trying to create. If the variable A has a 60% shared variance score with X and a 5% shared variance score with Y, the position of A on the chart would be plotted at 5% along the Y axis and 60% along the X axis. I want each plot to be labelled with the factor name from the column heading (“A”, “B”, “C” etc…)įor example. I now want to plot A, B, C, D, E etc on a scatter plot, where the X axis is the % shared variance with X and the X axis is the % shared variance with Y. In each cell I have a score for the % shared variance that the Factor in the column heading shares with the X (for the X row) and Y (for the Y row). I therefore have a table with a row each for X and Y, and columns for A, B, C, D, E, etc.I have chosen two of the variables (X and Y) and calculated % shared variance scores between each of those variables and all of the other variables (A, B, C, D etc).I have a list of Factors – each has been scored on a nine-point scale on a second list of variables.I can't figure out how do something that seems conceptually quite straight forward and I'm hoping someone can show me something obvious that I'm missing!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |