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.
Select what the gradient is defined by
Select how you want to define the color scale of the bins on the binned scatterplot.
Frequency of binned data
Select to define the gradient scale by the number of observations in the bin.
Select to define the gradient scale by the value of a third variable.
Select the Gradient
Select the color scale for the bins.
Bins with high values are red, and bins with low values are blue.
low to high
Bins with high values are dark blue, and bins with low values are light blue and light gray. You can use this option to highlight bins with more productivity or to maximize revenue.
high to low
Bins with low values are dark blue, and bins with high values are light blue and light gray. You can use this option to highlight bins with low defect rates or to minimize cost.
symmetric around value (optional)
Enter a value to center the gradient scale at a specific value rather than the center of the grouping variable or the frequency of the binned data. For example, a research team selects the gradient to be defined by the mean of the profit of all the products in the bin. The owner enters 0 as the Gradient
symmetric around value (optional) so that bins with products that made a positive profit are a different color than those that lost money.
This option is only available when you select Diverging from Gradient