![]() However, a second-order polynomial fits the data with an R-squared value of 0.998. From the image below, we can also clearly see that it is not a good fit. ![]() ![]() Try different types of curves to see which one maximizes the value of R-squared.įor this data set, a logarithmic equation fits the curve with an R-squared value of 0.7992. In the Format Trendline pane, select the options to Display Equation on chart and Display R-Squared value on chart. Then right click on the data series and select “Add Trendline …” Using LINEST for Nonlinear Regression in ExcelĮxcel charts are a convenient way to fit a curve to experimental data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |