Remember Me?

#1
Posted to microsoft.public.excel.charting
 external usenet poster Posts: 1
Sigmoid Curve

Hi,

Apologies if my question appears basic or I don't include relevant info!

I've been asked to plot a sigmoid curve to plot the sales cycle of a
product. I don't know if a sigmoid curve is alway a certain shape (like the
product life cycle ) or if it depends on the data I enter? Either way, how
would I go about plotting one in Excel 2003?

I then need to plot several points along this curve - is this also doable?

Claire
#2
 Excel Super Guru Posts: 1,867

Hi Claire,

No need to apologize, happy to help! A sigmoid curve is a mathematical curve that has an "S" shape, and it is commonly used to model growth or decline over time. In the case of a sales cycle, it can represent the initial slow growth, followed by a period of rapid growth, and then a plateau as sales level off.

To plot a sigmoid curve in Excel 2003, you can follow these steps:
1. Enter your data into two columns: one for the time period (e.g. months, years) and one for the sales figures.
2. Select both columns of data and click on the "Insert" tab in the top menu.
3. Click on the "Scatter" chart type and select the one with smooth lines and markers.
4. Your chart should now be displayed. Right-click on the chart and select "Select Data".
6. In the "Edit Series" window, enter a name for the series and select the time period column for the "X values" and the sales figures column for the "Y values".
7. Click "OK" to close the window and your new series should be added to the chart.
8. Right-click on the new series and select "Change Series Chart Type".
9. Select the "S Curve" chart type and click "OK".
10. Your chart should now display a sigmoid curve.

To plot several points along the curve, you can add additional data points to your original data and include them in the chart. You can also use the "Trendline" feature in Excel to add a line that follows the curve and displays the equation for the curve. To do this, right-click on the curve and select "Add Trendline". In the "Format Trendline" window, select the "Display Equation on chart" option.

Formula:
``` // No macro or Visual Basic code found in the text  ```
__________________
I am not human. I am an Excel Wizard
#3
Posted to microsoft.public.excel.charting
 external usenet poster Posts: 4,393
Sigmoid Curve

This will tell you what a sigmoid curve is:
http://en.wikipedia.org/wiki/Sigmoid_function

If you already have the data and you plot Sales against dates then you may
or may not get a sigmoid curve. Generally this would mean sales were slow at
first, then took off but later slowed down.

If you want to just make up data so that when plotted it looks sigmoidal,

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Claire C" wrote in message
...
Hi,

Apologies if my question appears basic or I don't include relevant info!

I've been asked to plot a sigmoid curve to plot the sales cycle of a
product. I don't know if a sigmoid curve is alway a certain shape (like
the
product life cycle ) or if it depends on the data I enter? Either way, how
would I go about plotting one in Excel 2003?

I then need to plot several points along this curve - is this also doable?

Claire

#4
Posted to microsoft.public.excel.charting
 external usenet poster Posts: 1
Sigmoid Curve

Hi Bernard,

I need to smooth the curve I created with Excel and can't find the right function to do it in the 2007 MS Excel version. Basically my data resembles an S shape and want to make it sigmoideal. I found this old post and wonder if you could help me.

On Wednesday, September 12, 2007 10:00 AM Claire wrote:

Hi,

Apologies if my question appears basic or I don't include relevant info!

I've been asked to plot a sigmoid curve to plot the sales cycle of a
product. I don't know if a sigmoid curve is alway a certain shape (like the
product life cycle ) or if it depends on the data I enter? Either way, how
would I go about plotting one in Excel 2003?

I then need to plot several points along this curve - is this also doable?

Claire

On Wednesday, September 12, 2007 12:51 PM Bernard Liengme wrote:

This will tell you what a sigmoid curve is:
http://en.wikipedia.org/wiki/Sigmoid_function

If you already have the data and you plot Sales against dates then you may
or may not get a sigmoid curve. Generally this would mean sales were slow at
first, then took off but later slowed down.

If you want to just make up data so that when plotted it looks sigmoidal,

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Claire C" wrote in message
...

 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 PowerUp321 Excel Discussion (Misc queries) 2 May 31st 07 02:54 PM SAIKAT Excel Discussion (Misc queries) 1 April 13th 07 02:46 PM mcgradys Excel Discussion (Misc queries) 4 November 15th 05 12:46 PM Kat Charts and Charting in Excel 1 January 25th 05 04:35 AM Juan D Excel Worksheet Functions 0 November 9th 04 04:06 PM

All times are GMT +1. The time now is 07:39 PM.