CMPS 273, Fall 2006, Assignment 4, Excel

Replace the outliers with a number that is the average of the two numbers surrounding the outlier. (30) Using Excel, make an x/y scatter chart of the data in the x and y with jitter columns. Using the y with jitter column, smooth the data using a running average with windows of the following size. (80) 3 5 10 4. ................
................