![]() The R-squared value demonstrates that the choice has not been successful. ![]() In the example above the linear approximation has been chosen only for illustrating the algorithm. Note: that a trendline can not be added to the following types of charts and graphs: In our example, the choice of the linear approximation has given a low accuracy and poor result. If R2 = 1, the approximation error is zero. To this end, we need to extend the line and determine its values. ![]() It is used for making predictions based on statistical data. ![]() Trendline in Excel is an approximating function chart. Select the line type and enter R-squared value (the approximation accuracy value) in the chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |