This is a random data set to be used in the Polynomial Fitting exercises for Chem 311. Note that each time you load this page, the data will change! So pick just one set of data and go with it!
Using the data below, you should construct use approriate tools (either Excel of Python) to fit the data to linear, quadratic, and cubic models, and determine which provides the best fit. Use the F-test to justify your choice.
Your final results should be organized into an excel workbook that can be easily interpreted by someone who has not read the assignment.
| Data | ||
|---|---|---|
| x | y | |
| 1 | 0.277 | -93.936 |
| 2 | 2.044 | -44.143 |
| 3 | 2.803 | -12.208 |
| 4 | 3.596 | 30.919 |
| 5 | 3.831 | 45.895 |
| 6 | 3.945 | 53.737 |
| 7 | 5.631 | 203.747 |
| 8 | 5.799 | 223.004 |
| 9 | 6.124 | 262.507 |
| 10 | 6.894 | 369.525 |
| 11 | 7.089 | 399.909 |
| 12 | 8.732 | 713.678 |