Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel's curve-smoothing algorithm
I have some raw data in excel, with a smooth curve added. I am trying
to reproduce this curve on the same data in GraphPad Prism, with poor results. Does anyone know how excel calculates curve smoothing? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel's curve-smoothing algorithm
As far as I can recall Microsoft uses a cubic spline but I have not seen the
exact formula. Try Google with search term: excel spline best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ps.com... I have some raw data in excel, with a smooth curve added. I am trying to reproduce this curve on the same data in GraphPad Prism, with poor results. Does anyone know how excel calculates curve smoothing? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel's curve-smoothing algorithm
Brian Murphy has determined that the smoothing algorithm is a Bezier curve.
Find the link to this workbook (Smooth_curve_bezier_example_file.xls) in the bottom part of this page: http://www.xlrotor.com/resources/files.shtml - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ps.com... I have some raw data in excel, with a smooth curve added. I am trying to reproduce this curve on the same data in GraphPad Prism, with poor results. Does anyone know how excel calculates curve smoothing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
smoothing data | Excel Discussion (Misc queries) | |||
double exponential smoothing in MS Excel? | Excel Discussion (Misc queries) | |||
Curve fitting algorithm | Charts and Charting in Excel | |||
curve fitting a charging capacitor type curve | Excel Discussion (Misc queries) | |||
graph smoothing | Charts and Charting in Excel |