+ Reply to Thread
Results 1 to 3 of 3

Smoothen curve by reducing data or any other method

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    Enschede, Netherlands
    MS-Off Ver
    Home and student 2016
    Posts
    49

    Smoothen curve by reducing data or any other method

    Hello people

    I have a horrible curve (because of equipment error) that I need to smoothen.
    Is there any way to make it look a bit better?

    Please check the attachment.

    Kind regards
    Anmol
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-03-2012
    Location
    CHENNAI , INDIA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Smoothen curve by reducing data or any other method

    Hi ,

    I am not sure whether this is a good way to smoothen a curve ; the data on Sheet1 is sampling the original data by taking every 10th point , while the data on Sheet2 samples the data on Sheet1 by taking every 10th point.

    See the two results and decide for yourself whether this is an appropriate method for smoothing the original graph.

    Narayan
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-23-2019
    Location
    Enschede, Netherlands
    MS-Off Ver
    Home and student 2016
    Posts
    49

    Re: Smoothen curve by reducing data or any other method

    Dear Narayan

    Thank you very much for the help! Data in sheet 2 seems to be perfect!

    Kind regards
    Anmol

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  2. Find exact formula of a curve and fix the bumps in the curve
    By twobox in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 01-16-2015, 12:25 PM
  3. Need to derive curve from values, then apply curve to another data set
    By Telperion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2014, 09:57 PM
  4. Graph a curve, then enter data to generate new similar curve
    By denphi03 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 11-03-2013, 05:33 PM
  5. Reducing data into a new table
    By gohb1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2009, 02:25 AM
  6. Reducing data set, how to choose every 'n'th row
    By ge-eng in forum Excel General
    Replies: 3
    Last Post: 12-04-2006, 05:35 PM
  7. curve fitting a charging capacitor type curve
    By mcgradys in forum Excel General
    Replies: 4
    Last Post: 11-15-2005, 08:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1