+ Reply to Thread
Results 1 to 2 of 2

How to find error percentage between two data of different lengths?

  1. #1
    Registered User
    Join Date
    05-30-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    1

    Question How to find error percentage between two data of different lengths?

    So I have 2 sets of data, one is around 8700 values and the other is around 5100 values. Both of them are from different experimental setups, so no formulas are used. I need to find the error between those data. I have made the graphs and everything and I need to find the exact value of maximum error in the trend. The graphs do follow a trend but the error reduces eventually. I need the exact point of error. The data is currently in MS Excel. Is there any way it can be done?

    To explain it further, the x-axis contains time and the y-axis contains the observed data. I need the time at which the maximum error occurs and the value of that error.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,726

    Re: How to find error percentage between two data of different lengths?

    I cannot think of a single step command for this. You have not explained the overall process or algorithm you want to use. I would expect something like this:

    1) Some kind of lookup or interpolation or regression algorithm to allow you to get or calculate y at any x for each data set.
    2) From there, choose an error calculation, and come up with a formula to calculate error at a given x.
    3) From there, find an algorithm for finding the maximum error and program that into the spreadsheet.

    If you can help us understand how you want to do each step, we should be able to help program those calculations into the spreadsheet.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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: 11
    Last Post: 07-17-2019, 07:47 PM
  2. Formula help to find how many lengths of an material per column of figures
    By MrExcel78 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-14-2017, 02:50 AM
  3. Need to find lengths and place in sql query.
    By Prabakaran3003 in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-09-2017, 09:20 AM
  4. Replies: 13
    Last Post: 08-21-2015, 02:27 PM
  5. [SOLVED] Find average of different wave lengths
    By rovaniemi in forum Excel General
    Replies: 6
    Last Post: 08-14-2013, 06:34 AM
  6. [SOLVED] Formula to find a match with different string lengths
    By mcranda in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-09-2013, 04:34 PM
  7. [SOLVED] Find possible combinations that fall between two lengths
    By Tulipo in forum Excel General
    Replies: 0
    Last Post: 04-23-2012, 08:47 AM

Tags for this Thread

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