I'm trying to make a graph to see the differences in student testing by age and their school rating. I could very easily make a scatterplot with student test scores by age and another for student test scores by school rating. But how can I get them on the same graph in a way that will tell me something?
I know how to use primary and secondary axes -- but those seem to show me how I would use those two graphs separately, just on the same graph. Which is definitely better, but not what I'm looking for. Since the idea is that there's only a correlation between age and rating, I think I'm thinking about graphing it the wrong way.
My hope was that the x-axis would be the 1-10 ratings, while the test scores would be one y-axis and the age would be the other -- but the score plots and the age plots wouldn't be so distinct.
Any suggestions? It might be less of a graphing question and more of a formulaic one -- but I thought that there was a way to manipulate this data and show the results by both criteria at once, rather than just showing both criteria separately on one graph.
I'm unfortunately not allowed to post an attachment, but hopefully that was enough for at least some ideas. Let me know if there's an easy way to sent more information.
Thanks, and any help is appreciated!
I know how to use primary and secondary axes -- but those seem to show me how I would use those two graphs separately, just on the same graph. Which is definitely better, but not what I'm looking for. Since the idea is that there's only a correlation between age and rating, I think I'm thinking about graphing it the wrong way.
My hope was that the x-axis would be the 1-10 ratings, while the test scores would be one y-axis and the age would be the other -- but the score plots and the age plots wouldn't be so distinct.
Any suggestions? It might be less of a graphing question and more of a formulaic one -- but I thought that there was a way to manipulate this data and show the results by both criteria at once, rather than just showing both criteria separately on one graph.
I'm unfortunately not allowed to post an attachment, but hopefully that was enough for at least some ideas. Let me know if there's an easy way to sent more information.
Thanks, and any help is appreciated!