Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Finding the absolute difference with positive and negative values

Tags:

math

excel

I have two columns. One with positive values and one with negative values. I need to find the absolute difference between the two columns.

What I am currently doing is the following: First of all, I edit both the columns to make all the values positive. Then I subtract the first column with the second column. I change any negative value to the positive one. Is this the same as the absolute difference?

like image 308
user3270725 Avatar asked Jul 31 '14 17:07

user3270725


People also ask

How do you find the absolute value of positive and negative numbers?

Absolute Value—the Numeric Approach When we take the absolute value of a number, it is always either positive or zero. If the original value is already positive or zero, the absolute value is the same. If the original value is negative, we simply drop the sign.

How do you find the absolute difference?

The absolute difference between two variables, for example two means or proportions is simply one subtracted from the other. It is often written as δB,A or δabs = μ1 - μ2, equivalently δabs = p1 - p2 for proportions.

Can the absolute difference be negative?

The common difference can be negativeYes, the common difference of an arithmetic sequence can be negative. Lets first learn what is a common difference, a common difference is a difference between two consecutive numbers in the arithmetic sequence.

Why do negative 3 and positive 3 have the same absolute value?

This is because both -3 and 3 are 3 units from zero on the number line. Keep in mind that the absolute value of a number will always be a positive value. This is because all numbers will always be a positive number of units away from zero on the number line.


1 Answers

Why not just use the ABS function

=ABS(B1-A1)
like image 132
Bijan Avatar answered Sep 20 '22 15:09

Bijan