happygaq.blogg.se

LINEST works similarly to INTERCEPT and SLOPE, but it has to be used as a matrix formula.

Calculation with function INTERCPET, SLOPE and FORECAST. There are multiple ways how to find "a" and "b". In another words the dependent variable is on vertical axis Y axis. For now it is the ice cream sales, because it depends on temperature. Y is dependent variable - which means variable dependent on the other one. In another words the independent variable is on horizontal X axis. In my case the independent variable is a temperature - because the sales of ice cream depend on temperature. X is an independent variable - which means variable, on which the second one is dependent. In this case - number of ice creams sold = a * temperature + b. The linear regression is described by equation y = a * x + b. We will describe the equation of regression (find a, b parameters) and estimate, how many ice cream portions is going to be sold tomorrow, when the temperature will be 17☌.įor now we will not consider any factors except of ice cream portions and temperature. In this example we will deal with variables "number of ice cream portions sold in one day" (independent variable) and "average day temperature" (dependent variable).

If you are interested in nonlinear regression, click here. In another words, when this relation is visualized in chart, it makes straight line. This relation can be described by an equation y = a*x+b. Linear regression is relation of two variables (=columns of data), when one depends on the second. This article deals with multiple way how to work with linear regression in Excel.