Linear Regression and Correlation – Excel Tools Instruction

Download Linear Regression and Correlation – Excel Instructions Data Sets [XLSX].

Scatter Plot

A scatter plot graph presents the data set where it is hypothesized that Y is dependent upon the single independent variable X.

Scatter Plot in Excel

  1. Highlight columns of cells
  2. Click Insert, Scatter and the one with only Markers
  3. Click on the new Scatter plot to change Title, and click icon + to make other changes
x (third exam score) y (final exam score)
65 175
67 133
71 185
71 163
66 126
75 198
67 153
70 163
71 159
69 151
69 159
Step 1 & 2: Highlight columns of cells. Click Insert, Scatter and the one with only Markers
Step 3: Click on the new Scatter plot to change Title, and click icon + to make other changes

Media Attributions

License

Icon for the Creative Commons Attribution 4.0 International License

Introduction to Business Statistics Problem Ancillary Materials: Yukon Edition Copyright © by Lisa Kanary is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book