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.
0 kommentar(er)
