Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Smooth curve in Excel

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-03-2009
Member
 
Join Date: Nov 2005
Posts: 103
Smooth curve in Excel
  

I need to make some graphs (characteristic of a diode) and I know there is a function in Excel to have a smooth curve, which plotted as an average between the measurement points. Do you know how this function is called?

Reply With Quote
  #2  
Old 24-03-2009
Member
 
Join Date: Dec 2007
Posts: 1,577
Re: Smooth curve in Excel

The smoothing in Excel is made via splines: you take 3rd degree polynomials, and adjust their four coefficients with the need of continuity, and smooth 1st and 2nd order derivatives. Then you would have to create sufficient points from those polynomials, so that you can see the curve really smoothed.
Reply With Quote
  #3  
Old 24-03-2009
Member
 
Join Date: Dec 2007
Posts: 1,545
Re: Smooth curve in Excel

Using smooth curves is deceptive. I like to see the data and decide for myself, or with the help of real curve fitting, how the variables are related.
Reply With Quote
  #4  
Old 24-03-2009
Member
 
Join Date: Dec 2007
Posts: 1,714
Re: Smooth curve in Excel

Here's another answer. When you create curves using the bezier tool you can change mode from create to edit and select a point(s) click on it and adjust the handle(s) to smooth out the curve....In case you are unaware of that.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Smooth curve in Excel"
Thread Thread Starter Forum Replies Last Post
How to get Line Curve formula without a graph in Microsoft Excel vALaNCiA MS Office Support 8 07-02-2012 06:59 PM
Need help to plot logistic curve in Microsoft Excel GuruT MS Office Support 2 03-02-2012 04:53 PM
Searching for template of bell curve graph in excel Rao's Windows Software 2 06-01-2012 01:04 PM
S-curve exported to excel Lima Jaric Microsoft Project 2 23-09-2010 04:25 PM
Vertical scrolling...jumps rather than smooth scrolling - Excel 20 Abbie Vista Hardware Devices 2 24-04-2009 07:36 AM


All times are GMT +5.5. The time now is 08:42 PM.