Course Documents -> Week 1 -> Excel Spreadsheet Exercise
In Class Exercise:
Download this data into Excel and do the following:
- Find the linear regression between columns 1 and 2
- Calculate the average and standard deviation for columns 1 and 2.
- clip the data of all values that are +/- 1.8 standard deviation units from the mean.
- Find the linear correlation of the clipped data set.