By following the line forward in time, you can estimate future sales, if you can safely assume that growth will remain linear.Įxponential regression Produces an exponential curve that best fits a set of data that you suspect does not change linearly with time. Based on a year's worth of sales figures, for example, linear regression can tell you the projected sales for March of the following year by giving you the slope and y-intercept (that is, the point where the line crosses the y-axis) of the line that best fits the sales data. Linear regression Produces the slope of a line that best fits a single set of data. The following list defines the different types of regression: You can use each of these functions with one or several independent variables. You enter these functions as array formulas, and they produce array results. Excel includes several array functions for performing linear regression (LINEST, TREND, FORECAST, SLOPE, and STEYX) and for performing exponential regression (LOGEST and GROWTH).
0 Comments
Leave a Reply. |