A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Different trend types



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2006, 12:59 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old April 18th, 2006, 01:33 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old July 20th, 2009, 03:29 PM posted to microsoft.public.excel.charting
Casy
external usenet poster
 
Posts: 8
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  
Old July 20th, 2009, 06:58 PM posted to microsoft.public.excel.charting
Bernard Liengme[_2_]
external usenet poster
 
Posts: 1,027
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?





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Quantify trend line Brisbane Rob General Discussion 3 March 5th, 2006 07:45 PM
Trend function question [email protected] General Discussion 2 February 15th, 2006 11:15 PM
.NET data types in Visio 2003 SL33PY Visio 0 October 4th, 2005 01:35 PM
Trend Lines (or Linest?) Martinaire Worksheet Functions 2 November 26th, 2004 06:08 PM
Trend line calculations Jerry W. Lewis Charts and Charting 1 January 8th, 2004 04:09 PM


All times are GMT +1. The time now is 10:12 PM.


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