Graphing a logarithmic regression line

S

Susiebusie

Is it possible to graph a logarithmic regression line on Excel? Here is the
line I need help graphing:::::1.649+1.968lnx

The Ln stand for natural log. Thanks!!
 
J

Jon Peltier

Susie -

If you know the formula, you can plot your own line. Put a series of X
values into one column and enter the formula into the next column to get the
Y values. Add a series using these two ranges.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
J

Jerry W. Lewis

The Excel "XY (Scatter)" chart graphs data pairs. Create a series of
x-values (2 are sufficient if you will use a logarithmic axis). In the next
column calculate y =1.649+1.968*ln(x). Select the colection of x-y pairs and
Insert|Chart and select the XY (Scatter) chart type with either straight or
smoothed connecting lines. Double click on the X axis to get to its
properties where you can specify a logarithmic scale.

Jerry
 
B

B. R.Ramachandran

Hi,

Since you are calling your equation,the 'logarithmic REGRESSION line', it
seems to me that you obtained that equation by fitting the function a + b
ln(x) to some existing X,Y-data. If that is the case and you already have
the XY-plot of the data, all you have to do is to add a logarithmic trendline
to it.
Right-click on a data-point in the graph --> "Add Trendline" --> under
'Type' select "Logarithmic" and under 'Options' check "Display Equation on
Chart" --> "OK".
This adds the regression line to the existing plot of your data.

If, on the other hand, you want to just make a plot of y = 1.649+1.968
ln(x), you have to create a column of x-values, and calculate a column of
y-values using the equation, and make an XY-plot of those values (as
suggested Jon Peltier).

Regards,
B. R. Ramachandran
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top