![]() That means the polynomial equation fits the data better.Īlthough the trendline option is convenient, it may not always be the best option when you want to know the equation that best fits the data. 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 |