+ Reply to Thread
Results 1 to 1 of 1

How to calculate errors (standard, Absolute or Absolute Relative)

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    372

    How to calculate errors (standard, Absolute or Absolute Relative)

    I'm having difficulty in calculating each of the standard, Absolute or Absolute Relative errors in one formula. For example, I can calculate the AVG error in one column. And I have 3 more separate columns each with the error calculated by the aforementioned deviations. But how do I calculate the Avg error and the Standard in one formula (the same for avg error and Absolute and so on) whereas I get the same results?

    - First, I think I got by deviation calculations correct.
    - Second, I need a sample formula for each in the adjacent columns; Standard looks weird to me. (I, J and K)...

    Please see attached-

    Thanks so much....
    Attached Files Attached Files

+ 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. [SOLVED] Relative & Absolute Paste
    By kyjae in forum Excel General
    Replies: 3
    Last Post: 05-15-2014, 07:28 AM
  2. Help with Absolute and relative
    By temp codata in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-01-2012, 09:21 AM
  3. [SOLVED] Absolute ref from relative in VBA
    By gjcase in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2011, 09:04 PM
  4. How Do I Mix Relative & Absolute References?
    By insect in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2009, 11:02 PM
  5. [SOLVED] Mix of relative and absolute?
    By M John in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2006, 11:30 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