What is a Scatter Chart?
A Scatter Chart (otherwise known as a scatter plot or scatter graph) uses dots to represent values for two different sets of data. It is commonly used to show how much one variable is (or is not) affected by the other.
The relationship between two variables is known as their correlation. If the dots are close to making a straight line in the scatter chart, the two variables are deemed to have a high correlation, and if the markers are equally distributed in the scatter plot, the correlation is low.
How to create a Scatter Chart in Explore
When you have identified the DataSources you want to use in the Scatter Chart, it's easy to build on in a DataGrid in Explore, in a new or (existing Workbook); follow the steps below:
1) Select Scatter Chart from the chart selection panel.
We assume you have at least two DataSources already added to your DataGrid. If you don't have data, you cannot create any chart!
2) Give your chart a name
We recommend something memorable so you can identify it later when adding it to a Dashboard!
3) Select your columns for both X and Y Axes
The columns you added to your DataGrid will be available for each axis to select in the drop-down.
a) X-Axis
b) Y-Axis
4) Generate your chart.
Click "Create Scatter Chart" for a scatter chart that you can use.
5) You are good to go!
That's it! You are good to go; your chart can be added to Dashboards or analysed further.
Generated Values
The scatter chart provides some values out of the box on the back line.
Regression Formula
The first part of the legend is the Regression model.
r² value
The coefficient of determination, denoted R2 or r2 and pronounced "R squared", is the proportion of the variation in the dependent variable that is predictable from the independent variable(s). (Source: Coefficient of Determination)