Question

How do you do an X & Y scatter plot when you have one X value and one Y value. Im trying to create a graph that shows the x-axis (&x-value) in blue dots and on the Y-axis (y-value) in orange dots only problem the graph does not come out correctly and in the series section I leave the Y-value blank for the X-value and vice versa. When I use the Y & X value together when creating the x&y scatter plot the graph does come out correctly but there both in blue dots so i can not obtain a separate y=mx+b and R2 value.

Answer 1

1. Collect pairs of data where a relationship is suspected.
2. Draw a graph with the independent variable on the horizontal axis and the dependent variable on the vertical axis. For each pair of data, put a dot or a symbol where the x-axis value intersects the y-axis value. (If two dots fall together, put them side by side, touching, so that you can see both.)
3. Look at the pattern of points to see if a relationship is obvious. If the data clearly form a line or a curve, you may stop because variables are correlated. You may wish to use regression or correlation analysis now. Otherwise, complete steps 4 through 7.
4. Divide points on the graph into four quadrants. If there are X points on the graph:
5. Count X/2 points from top to bottom and draw a horizontal line.
6. Count X/2 points from left to right and draw a vertical line.
7. If number of points is odd, draw the line through the middle point.
8. Count the points in each quadrant. Do not count points on a line.
9. Add the diagonally opposite quadrants. Find the smaller sum and the total of points in all quadrants.
   A = points in upper left + points in lower right
   B = points in upper right + points in lower left
   Q = the smaller of A and B
   N = A + B
10. Look up the limit for N on the trend test table.   
11. If Q is less than the limit, the two variables are related.
12. If Q is greater than or equal to the limit, the pattern could have occurred from random chance.