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

Tags:

Sponsored Links



Smooth curve in Excel

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-03-2009
Kool's Avatar
Member
 
Join Date: Nov 2005
Posts: 75
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 25-03-2009
Expertz's Avatar
Member
 
Join Date: Dec 2007
Posts: 1,433
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 25-03-2009
Team Leader's Avatar
Member
 
Join Date: Dec 2007
Posts: 1,516
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 25-03-2009
JAMES_911's Avatar
Member
 
Join Date: Dec 2007
Posts: 1,554
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


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Smooth curve in Excel"
Thread Thread Starter Forum Replies Last Post
Need help to plot logistic curve in Microsoft Excel GuruT MS Office Support 2 1 Week Ago 05:53 PM
Searching for template of bell curve graph in excel Rao's Windows Software 2 06-01-2012 02:04 PM
Does the Blackberry Curve have Microsoft Word, Excel and Powerpoint applications ? Ameeryan Portable Devices 3 08-08-2009 12:28 AM
Vertical scrolling...jumps rather than smooth scrolling - Excel 20 Miller Man Vista Hardware Devices 4 24-04-2009 08:36 AM
S-curve exported to excel labingtone Microsoft Project 1 21-03-2008 09:30 AM


All times are GMT +5.5. The time now is 11:13 AM.