Scatter Plots are used to study possible relationships (association or correlation) between two variables (bivariate correlation) using either continuous (variable) data or Attribute (discrete) data.
LearnLeanSigma.com Input (x) Output (y) Scatter Diagram Data Input Correlation: Pearson: RSQ:
Step 1 - Enter the X and Y data that you want to plot. This is a simple regression analysis; i.e. you want to see if a change in the X value correlates in some way to a change in the Y value. < - - …
42763. 19455. 195387. 93965. 35672. 20858. 217637. 107164. 74734. 34036. 130550. 87806. 42976. 17927. 151132. 91518. 54936. 29479. 0. 1. 2. 0. 1. 2. 6. 0. 2. 3. 6. 0. 2. 4. 10. 0. 2. 5. …
You may make archival copies and customize this template (the "Software") for personal use or for your company use.
Click Insert --> Scatter and select the top left hand sample The chart will appear in the worksheet and when you select the chart (by clicking on it) you can use the Design and the Layout …
Delivery Time X1 (Cartons) X2 (Distance) Scatter Plot Matrix Normal Probability Plot with Anderson-Darling Test Grouping Female
describe simple mathematical relationships between two variables (bivariate data) in observational and experimental contexts and illustrate using scatter graphs.
To add the location of the data labels, first, add the series to the chart and switch its type to a scatter plot. Then, turn on data labels and hide the markers.
100. 5000. 120. 6000. 120. 6000. 150. 7500. 150. 7500. 200. 10000. 200. 10000. 180. 9000. 180. 9000. 220. 11000. 220. 11000. 250. 12500. 250. 12500. 280. 14000. 280. 14000. 230. 11500. …