Scatter Plot Examples

QI Macros can do it for you!

Create Scatter Plots using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Box, Dot & Scatter > Scatter.
  3. QI Macros will do the math and analysis for you.

Go Deeper: Scatter plots are used to evaluate the correlation or cause-effect relationship (if any) between two variables.

There are three primary types of scatter plots:

Strong Positive Correlation

scatter plot example positive correlation

Data points are clustered along a trend line
Upward slope (as one variable increases so does the other).
R² is greater than .80

Strong Negative Correlation

scatter plot strong negative correlation

Data points are clustered along a trend line.
Downward slope (as one variable increases the other decreases.)
R² is greater than .80

No Correlation

Example of no correlation

Data points look like a shotgun blast
R² is less than .80

 

QI Macros makes me look like an expert


Calculating the Correlation of Determination

If R², the correlation of determination (square of the correlation coefficient), is greater than 0.8, then 80% of the variability in the data is accounted for by the equation. Most statistics books imply that this means that you have a strong correlation.


Can I create a Titration Curve in Excel using QI Macros?

Certainly! Make sure that you have a column of Volume data that represents your X-Axis, along with a column of pH data that represents your Y-Axis.

Select your data and then select the "Scatter" macro from the "Box, Dot & Scatter Plot" drop-down menu:

titration-chart-example

NOTE: Our Scatter Plot Diagram does NOT calculate the Equivalence Point for you - it can be identified by the end user where the graph is the steepest.

Also, if you have identified the Equivalence Point, simply hover over it - Excel will provide you with the value.


Scatter Plots can be made manually or in Excel. However, you have to find the right chart to get a trend line and Excel will not calculate the R² for you.

QI Macros Add-in for Excel can create a scatter plot in seconds and will calculate the slope and R² for you.

Stop Struggling with Scatter Plots!
Start creating your Scatter Plots in just minutes.

Download a free 30-day trial. Get Scatter Plots now!


QI Macros Can Also Create These Charts in Excel


Learn More...


Why Choose QI Macros for Excel?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support