Remember Me?

#1
March 8th 08, 06:40 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 9
how do i plot a logistic curve?

I am trying to plot a logistic curve and determine r2 values for 13 data points
(0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422)

#2
March 8th 08, 06:59 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 1,696
how do i plot a logistic curve?

Not sure if you just want one value, but if so, there's a formula, LOGEST
that will return statistics for the curve. In your example, it returns
1.014717061. If that's what you wanted, put your X in, say, column A and your
Y in clumn B.

=LOGEST(B1:B100,A1:A100,TRUE,FALSE)

where the first TRUE indicates the constant is calculated normally or FALSE
if equal to 1.

and second FALSE indicates return m-coeffs and the constant b or TRUE
OR, if you want a chart, highlight your Xs and Y's, select line as the chart
type. Ensure you set your values as needed, then right click on the resulting

Otherwise, I have no idea what you need because I never took advanced stats.
:-)

"TRUSSMAN" wrote:

I am trying to plot a logistic curve and determine r2 values for 13 data points
(0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422)

#3
March 9th 08, 03:57 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 9
how do i plot a logistic curve?

Thank you for your reply. I am trying to find a way to fit a logistic curve
to the scattergraph I have, and finding each value seems a little too work
intensive, do you have any other suggestions?

"Sean Timmons" wrote:

Not sure if you just want one value, but if so, there's a formula, LOGEST
that will return statistics for the curve. In your example, it returns
1.014717061. If that's what you wanted, put your X in, say, column A and your
Y in clumn B.

=LOGEST(B1:B100,A1:A100,TRUE,FALSE)

where the first TRUE indicates the constant is calculated normally or FALSE
if equal to 1.

and second FALSE indicates return m-coeffs and the constant b or TRUE
OR, if you want a chart, highlight your Xs and Y's, select line as the chart
type. Ensure you set your values as needed, then right click on the resulting

Otherwise, I have no idea what you need because I never took advanced stats.
:-)

"TRUSSMAN" wrote:

I am trying to plot a logistic curve and determine r2 values for 13 data points
(0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422)

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Skip Excel Discussion (Misc queries) 0 October 4th 06 12:55 AM Sirritys Excel Discussion (Misc queries) 7 June 4th 06 11:46 AM Sirritys Charts and Charting in Excel 1 June 2nd 06 01:35 PM Rients Excel Worksheet Functions 1 March 21st 06 10:36 PM Rbp9ad Charts and Charting in Excel 3 December 21st 05 12:43 AM

All times are GMT +1. The time now is 01:14 PM.