Help!

S curve Calculation in Excel.

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Word slow to open but fix makes no sense  
Author Message
nate.block
External


Since: Feb 25, 2009
Posts: 1



PostPosted: Wed Feb 25, 2009 1:54 pm    Post subject: S curve Calculation in Excel.
Archived from groups: microsoft>public>excel>misc (more info?)

Hello all. I'd like to find a basic formula for an S curve calc in
excel. Variables would be equal to Y = moeny vs. X time (or period).
Ymax would be the budgeted cost of the project, and Xmax would be the
budgeted time for the project.

current calculation I'm using is:

Y = Ymax ((2(X/Xmax)^2) - (X/Xmax)^4)

While this does give me a curve, I need a curvier curve. Smile Any
help would be appreciated.

Thanks!
Back to top
Mike Middleton
External


Since: Sep 23, 2005
Posts: 302



PostPosted: Wed Feb 25, 2009 3:37 pm    Post subject: Re: S curve Calculation in Excel. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

nate.block -

Consider a logistic function. For details, search Google for "excel logistic
curve" (without the quote marks).

For "curvier curve," consider more XY pairs, perhaps using an XY (Scatter)
chart type instead of a Line chart type, and choose "Smoothed line."

For more assistance, specify your version of Excel.

- Mike

http://www.MikeMiddleton.com



wrote in message

> Hello all. I'd like to find a basic formula for an S curve calc in
> excel. Variables would be equal to Y = moeny vs. X time (or period).
> Ymax would be the budgeted cost of the project, and Xmax would be the
> budgeted time for the project.
>
> current calculation I'm using is:
>
> Y = Ymax ((2(X/Xmax)^2) - (X/Xmax)^4)
>
> While this does give me a curve, I need a curvier curve. Smile Any
> help would be appreciated.
>
> Thanks!
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum