Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dan Burgess
 
Posts: n/a
Default Different trend types

I am using excel to curve fit to data in an X-Y Scatter plot. Does anyone
know of add-ins/extensions that allow plotting of trendlines for other types
of curves eg. Sigmoid or sinusoidal curves?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Different trend types

You can use Solver to fit such data. Send me private email if interested;
attach file with data and tell me the equation to use.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Dan Burgess" <Dan wrote in message
...
I am using excel to curve fit to data in an X-Y Scatter plot. Does anyone
know of add-ins/extensions that allow plotting of trendlines for other
types
of curves eg. Sigmoid or sinusoidal curves?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Different trend types

Hi,

I've been trying to use Solver to fit my data, which is possibly a sigmoidal
curve but I wasn't sure where to start with.

I am currently using Excel 2007. I managed to enable the Solver add-in but
it doesn't show up in the Add-in toolbar. Will there by any chance that I
could create curve fitting apart from using Solver? Or any other method to
get Solver.

Many thanks,
Casy

"Bernard Liengme" wrote:

You can use Solver to fit such data. Send me private email if interested;
attach file with data and tell me the equation to use.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Dan Burgess" <Dan wrote in message
...
I am using excel to curve fit to data in an X-Y Scatter plot. Does anyone
know of add-ins/extensions that allow plotting of trendlines for other
types
of curves eg. Sigmoid or sinusoidal curves?




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default Different trend types

It Solver has been loaded, then you will find the tool to invoke it on the
Data tab, Analysis group (far right item on tab)

Yes you can use Solver for this type of problem. Visit my site
http://people.stfx.ca/bliengme/ExcelTips/Elisa.mht
and download the sample Excel file which fits data to a four parameter
function. If you have some math background you should have no problem
adapting this. Otherwise, please communicate with me at my personal email
address found on my website

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


"Casy" wrote in message
...
Hi,

I've been trying to use Solver to fit my data, which is possibly a
sigmoidal
curve but I wasn't sure where to start with.

I am currently using Excel 2007. I managed to enable the Solver add-in but
it doesn't show up in the Add-in toolbar. Will there by any chance that I
could create curve fitting apart from using Solver? Or any other method to
get Solver.

Many thanks,
Casy

"Bernard Liengme" wrote:

You can use Solver to fit such data. Send me private email if interested;
attach file with data and tell me the equation to use.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Dan Burgess" <Dan wrote in message
...
I am using excel to curve fit to data in an X-Y Scatter plot. Does
anyone
know of add-ins/extensions that allow plotting of trendlines for other
types
of curves eg. Sigmoid or sinusoidal curves?





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
Trend Line Equation Coefficients Jake Excel Discussion (Misc queries) 4 April 17th 06 08:46 PM
Quantify trend line Brisbane Rob Excel Discussion (Misc queries) 3 March 5th 06 07:45 PM
Trend function question [email protected] Excel Discussion (Misc queries) 2 February 15th 06 11:15 PM
Trend line in Excel deacs Excel Discussion (Misc queries) 3 February 13th 06 04:07 PM
Trend Lines (or Linest?) Martinaire Excel Worksheet Functions 2 November 26th 04 06:08 PM


All times are GMT +1. The time now is 11:58 AM.

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

About Us

"It's about Microsoft Excel"