Enter the x- and y-variables, define the gradient, and select the gradient type.
In Y-variable, enter a column that you want to explain or predict. In X-variable, enter a corresponding column that might explain or predict changes in the y-variable. Both columns must be numeric and have the same number of rows.
In this worksheet, Debt Ratio is the y-variable and Age is the x-variable. The graph shows the relationship between debt ratio and age.
C1 | C2 |
---|---|
Age | Debt Ratio |
45 | 0.80298 |
40 | 0.12188 |
38 | 0.08511 |
... | ... |
Select how you want to define the color scale of the bins on the binned scatterplot.
In this example, bins with 180 observations or more are dark red. Bins with 60 observations or fewer are dark blue. Bins with between 60 and 180 observations are lighter shades of blue, red, and gray.
In this example, when the average value of all observations of the third variable is greater than 5, the bin is dark red. When the average value of all observations of the third variable is less than 1, the bin is dark blue. Bins with average values between 1 and 5 are lighter shades of blue, red, and gray.
This option is only available when you select Diverging from Gradient type.