Have been looking for a formula to give me a curve similar to the following:-
will post this 5 times untill I can post a link
Solid blue line. Doesn't matter if it doesn't exactly fit, I think I can adjust the functions by trial and error once I get it into xls. I am after the y value by inputting the x value, the important bit being the the curve rises steeply, tails off but never starts to go back down as would a quadratic equation ( y=ax2+bx+c ) If someone has something it would be great, have been looking for what seems like ages, many thanks in advance
Paul M
Easiest approach:
Column A: Put "X" in A1. Put a 0 in A2, select "Fill" in the editing section of the Home tab, select series, Series in Columns, Type Linear (default), Step Value 0.1, Stop Value 5. This will give you your x data
Column B: Put "Y" in B1. Put the following formula in B2: =1-EXP(-A1)
Copy B2 down through B52
Now you have your data.
Select the data B1:B52
Insert a line chart.
Right click on the chart, "Select Data"
Under Horizontal (Category) Axis Labels click edit
In the Axis Label Range, click on the little chart symbol to the right, then click on A2, hold the shift key, and press ctrl and the down arrow at the same time. The box should now read =Sheet1$A$2:$A$52 or similar (depending on your sheet's name). Press enter. Press OK. Press OK.
Play with your chart and label it, change the line color, etc etc.
Excel 2010
Looks more like a Gompertz curve to me.
http://www.mediafire.com/view/s9asng.../01_23_14.xlsm
http://www.mediafire.com/view/gama74...n/01_23_14.pdf
Bookmarks