Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
TP TP is offline
external usenet poster
 
Posts: 8
Default How do I fit a sigmoidal curve to data on a chart?


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do I fit a sigmoidal curve to data on a chart?

Fitting a sigmoidal curve to data on a chart using Microsoft Excel
  1. First, make sure your data is organized in two columns: one for the x-axis values and one for the y-axis values.
  2. Select the data you want to use for the curve fit.
  3. Click on the "Insert" tab in the Excel ribbon and select "Scatter" from the chart options.
  4. Choose the scatter chart type that includes lines connecting the data points.
  5. Right-click on one of the data points and select "Add Trendline" from the context menu.
  6. In the "Format Trendline" pane that appears on the right side of the screen, select "Logistic" as the trendline type.
  7. Adjust the other trendline options as desired, such as the line color and thickness.
  8. Click "Close" to apply the trendline to the chart.

Your chart should now display a sigmoidal curve that fits the data. You can use this curve to make predictions or analyze the relationship between the x and y variables.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default How do I fit a sigmoidal curve to data on a chart?

Using Solver. I show the use of Solver to fit a function at
http://people.stfx.ca/BLIENGME/ExcelTips/Elisa.mht
with sample worksheet.
If you wish, you may send me (get my email address from my website) a file
with data and the function to be fitted
best wishes
--
Bernard Liengme
MVP Excel
http://people.stfx.ca/bliengme

"tp" wrote in message
...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a bell curve chart [email protected] Charts and Charting in Excel 1 May 15th 08 10:43 PM
Frequency chart and normal curve Carl W. New Users to Excel 2 August 23rd 06 07:48 PM
Creating Bell Curve Chart MikeR-Oz Charts and Charting in Excel 3 February 2nd 06 12:19 PM
Vertical ND Curve on Combination Chart Phil Hageman Charts and Charting in Excel 4 December 30th 04 06:07 PM
how do i read directly off of a chart - callibration curve [email protected] Charts and Charting in Excel 2 December 6th 04 05:50 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"