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!!

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/
_______


"Susiebusie" wrote in message
...
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!!

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

"Susiebusie" wrote:

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!!

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

"Susiebusie" wrote:

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!!