Logarithmic Regression

[N1ka18]

Hello, I need help with log linear Regression. The thing is I do not know how to calculate elasticity of logarithmic values, slope, std. error in order to make forecasts. Is there a way solve it with Linest or any other formula. I am attaching a spreadsheet to better see where I need help. If you require any additional information do not hesitate to contact. Thanks in advance.

[MrShorty]

In your spreadsheet, how did you get those values in N18 and N19 "non-dynamically"? What is the function being used to obtain those values? LINEST() can be used to obtain slope and intercept for any function that you can rearrange into a form g(y)=a*f(x)+b

[N1ka18]

These are the values provided by example from the book. I am trying to solve and do not know how to arrange Linest Function. https://drive.google.com/file/d/0B1P...it?usp=sharing. Here is the link to the example. Hope you can help me.

[N1ka18]

These are the values provided by example from the book. I am trying to solve and do not know how to arrange Linest Function. https://drive.google.com/file/d/0B1P...it?usp=sharing. Here is the link to the example. Hope you can help me.

[MrShorty]

Google says we don't have permission. Can you upload the example file here?

There is nothing in the example that explains how they got these results? Nothing to help interpret the results? What would you use to calculate y from that slope and intercept (y=m*ln(x)+b)??

[N1ka18]

This is the reason I started this thread, because I need know when 1% change occurs how they get adjusted slope and intercept. As far as I know it derives from elasticity.

[MrShorty]

I find that I first need to understand the math behind a problem before I can program the solution into Excel. From a quick look at Wikipedia, this looks like mathematical or economic elasticity, where elasticity is the slope of ln(y) vs ln(x). I cannot see how the example comes up with the values you say they get. Are you certain the example is done correctly? Once we know in mathematical terms how they come up with those values, it will probably be fairly easy to program that result into Excel. Without understanding the math behind it, I cannot see how they come up with those values.

[N1ka18]

I understand your concern and I share it with you. I do not really do not understand how they got adjusted slope and intercept. I am not familiar with Minitab, but is it is widely presented in the book, and the reasonable explanation is that they got the value automatically from Minitab