This assignment is designed to compare performance between Matlab and Excel for performing nonlinear regression analysis of a set of data. There are two data sets in the accompanying Excel spreadsheet, the cell migration data, and a noisy sine wave. The first set was collected by Dr. Cho, and represents the X and Y coordinates of a cell as it migrates across a substrate in culture. Your job is to find an equation that describes the position of the cell as a function of time. Use a polynomial of the lowest order possible such that R2(r squared)> 0.95. Do this in Excel and in Matlab, and hand in both plots along with your equations and R2(r squared)values for each determination.
Also fit a polynomial to the noisy sine wave. Find the polynomial of lowest order such that R2(r squared)> 0.95. Do this with both Excel and Matlab.Hand in all four plots, all four equations, and all four R2values, on no more than two sheets of paper.