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?
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 addressquot;Dan Burgessquot; lt;Dan gt; wrote in message
...
gt;I am using excel to curve fit to data in an X-Y Scatter plot. Does anyone
gt; know of add-ins/extensions that allow plotting of trendlines for other
gt; types
gt; of curves eg. Sigmoid or sinusoidal curves?
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
quot;Bernard Liengmequot; wrote:
gt; You can use Solver to fit such data. Send me private email if interested;
gt; attach file with data and tell me the equation to use.
gt; best wishes
gt; --
gt; Bernard Liengme
gt; www.stfx.ca/people/bliengme
gt; remove CAPS in email address
gt;
gt;
gt; quot;Dan Burgessquot; lt;Dan gt; wrote in message
gt; ...
gt; gt;I am using excel to curve fit to data in an X-Y Scatter plot. Does anyone
gt; gt; know of add-ins/extensions that allow plotting of trendlines for other
gt; gt; types
gt; gt; of curves eg. Sigmoid or sinusoidal curves?
gt;
gt;
gt;
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
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
people.stfx.ca/bliengme
remove caps from emailquot;Casyquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I've been trying to use Solver to fit my data, which is possibly a
gt; sigmoidal
gt; curve but I wasn't sure where to start with.
gt;
gt; I am currently using Excel 2007. I managed to enable the Solver add-in but
gt; it doesn't show up in the Add-in toolbar. Will there by any chance that I
gt; could create curve fitting apart from using Solver? Or any other method to
gt; get Solver.
gt;
gt; Many thanks,
gt; Casy
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; You can use Solver to fit such data. Send me private email if interested;
gt;gt; attach file with data and tell me the equation to use.
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove CAPS in email address
gt;gt;
gt;gt;
gt;gt; quot;Dan Burgessquot; lt;Dan gt; wrote in message
gt;gt; ...
gt;gt; gt;I am using excel to curve fit to data in an X-Y Scatter plot. Does
gt;gt; gt;anyone
gt;gt; gt; know of add-ins/extensions that allow plotting of trendlines for other
gt;gt; gt; types
gt;gt; gt; of curves eg. Sigmoid or sinusoidal curves?
gt;gt;
gt;gt;
gt;gt;
- Jul 25 Fri 2008 20:45
Different trend types
close
全站熱搜
留言列表
發表留言
留言列表

