Course Documents -> Week 1 -> Excel Spreadsheet Exercise

In Class Exercise:

Download this data into Excel and do the following:

  1. Find the linear regression between columns 1 and 2

  2. Calculate the average and standard deviation for columns 1 and 2.

  3. clip the data of all values that are +/- 1.8 standard deviation units from the mean.

  4. Find the linear correlation of the clipped data set.