In reading 13 there is an example, #3 I think, that discusses or explains the sales trend on intel for 20 years worth of data. It showed that regular linear models don’t fit the trend line and they used the log linear and that explained the sales trend perfectly. Can someone explain the log normal function, how do you know when to use it, (besides when regular models don’t fit exactly.)作者: Uranus08 时间: 2011-7-11 19:32
It's for graphs that plateau after a while.作者: ryanlb 时间: 2011-7-11 19:32
To expand on the previous post:
Suppose a company's sales grow at 10% a year:
1) 100k 2)110k 3)121k 4)133.1k 5)146.41k
Trying to use a linear regression model simply will not work. Our predictions would be based on the assumption that there is a linear relationship amongst our variables which we have defined them not to be.
However, by using the Log Linear function, we're able to convert the pattern into one that is effectively linear, thereby allowing us to use a regression equation to try to explain the future.
The reason a Log Linear function works, is because we are essentially removing the exponential and converting it into a coefficient (at least thats how I look at it)作者: economicz 时间: 2011-7-11 19:32
what do you mean converting it into a coefficient作者: DSquaredSlim 时间: 2011-7-11 19:32
Look at a linear graph which shows sales data from years 1 to 10.
* If sales from year 1 to 2, went from $10 to $20, that's a 100% rise, or $10 rise.
* If sales in year 9 to 10 went from $1000 to $1010, a rise by $10, same as before, but that's only a 1% rise.
* A linear graph would show both changes as covering same distance on the graph, i.e., the jump from one year to the next measures the same on the graph.
But why so? The first one is a big change (100%), while the other is a smal change (1%). A loglinear graph takes care of that.作者: kingstongal 时间: 2011-7-11 19:32
nice, thanks!作者: giorgio10 时间: 2011-7-11 19:32
wait in your example, that is a constant amount, so use linear?作者: wilslm 时间: 2011-7-11 19:32
Even if it grows by a constant amount, a loglinear graph shows the growth situation in a much better way. A linear graph is ok to use, and the two become almost the same, when you have a few data points, or the growth rate is very small. I don't think the statement made above which says:
Use linear when growth is at a constant AMOUNT
Use loglinear when growth is at a constant RATE
