Free Tutorial Central Home | Basic Statistical Analyses with Excel |

Basic Statistical Analysis with Excel Lesson 2: Describing Bivariate Data with Excel

In Lesson 2, you learn how to compute basic bivariate graphs and statistics. This lesson covers how to create scatterplots, compute Pearson's correlation, and Spearman's rho.

Click the "Download" button (upper right) to download this free lesson in PDF format.

Objectives: Be able to compute the following.

  1. Scatterplot
  2. Pearson's r
  3. Spearman's rho



    4. Scatterplot