S curve Calculation in Excel.

N

nate.block

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. :) Any
help would be appreciated.

Thanks!
 
M

Mike Middleton

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
 

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

Similar Threads

Fit a Logistic Curve 0
Step to generate s curve in excel 0
Calculation of Area Under a Continuos curve......Scatter Curve. 0
Need some PWA help 0
S- Curve Calculation and chart 3
Spread Project Costs Over Months Using Bell Curve 2
Need some plotting help - determining which points are farthest apart 5
Calculation of Area Under a Continuos curve...... 5

Top