![]() ![]() 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. The window for setting line parameters opens. ![]() The horizontal direction represents year, and the vertical one shows price. Choose a simple graph out of the offered chart types. Select the range A1:P2 and click on the «Insert»-«Charts»-«Insert Line Chart»-«Line».
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |