A | B | C | D | |
---|---|---|---|---|
1 | You don't need to request an access to work with this document. Simply make a copy of it :) | |||
2 | Month | Revenue | Google Spreadsheet uses a well-known method of least squares. Simply putting, the sense of this method is that the slope and the position of the trendline are chosen that way, so the sum of the squares of the residuals made in the results of every single equation is minimized. | |
3 | 1 | 2 130,00 | ||
4 | 2 | 2 457,00 | ||
5 | 3 | 1 974,00 | FORECAST(X; Known_values_Y; Known_values_X) | |
6 | 4 | 2 200,00 | X is the point in time for which we make a forecast | |
7 | 5 | 2 600,00 | Known_values_Y - known values of the dependent variable (revenue) | |
8 | 6 | 2 457,00 | Known_values_X -known values of independent variable (dates or numbers of periods) | |
9 | 7 | 2 204,00 | ||
10 | 8 | 1 845,00 | ||
11 | 9 | 1 897,00 | ||
12 | 10 | 1 945,00 | ||
13 | 11 | 1 896,00 | ||
14 | 12 | 1 987,00 | ||
15 | 13 | 2 451,00 | ||
16 | 14 | 2 134,00 | ||
17 | 15 | 1 984,00 | ||
18 | 16 | 2 548,00 | ||
19 | 17 | 1 987,00 | ||
20 | 18 | 1 645,00 | ||
21 | 19 | 2 145,00 | ||
22 | 20 | 2 231,00 | ||
23 | 21 | 2 032,00 | ||
24 | 22 | 2 022,00 | ||
25 | 23 | 2 012,00 | ||
26 | 24 | 2 002,00 |