View the average of only positive or negative numbers with Kutools for Excel. If you have installed Kutools for Excel, with its Select Specific Cells feature, you can select the positive or negative numbers first, and then view the result of the calculation from the status bar.
https://www.extendoffice.com/documents/excel/1716-excel-average-only-positive-negative-numbers.html
When subtracting with negative numbers on a number line, the subtraction sign means to go in the opposite direction of the directed distance that follows. Thus, to find +2 – (4), start at +2, then do the opposite of 4 – that is, go 4 units to the right ending at +6. This can fool you.
https://eduplace.com/math/mathsteps/6/b/index.html
May be, sometimes, you need to calculate the average of only positive or negative numbers from a range which contains both positive and negative values in your worksheet, the normal AVERAGE function will not solve this task. This tutorial will show you how to average only positive or negative numbers in Excel.
https://www.extendoffice.com/documents/excel/1716-excel-average-only-positive-negative-numbers.html
Calculating a Geometric Mean with some negative values. This is a discussion on Calculating a Geometric Mean with some negative values within the Excel Questions forums, part of the Question Forums category; I am trying to work out how to calculate the geometric mean of a series of values, some of which ...
https://www.mrexcel.com/forum/excel-questions/264366-calculating-geometric-mean-some-negative-values.html
If the series has an outlier, it is better to calculate the median to find the central tendency. 2. Determine the series of numbers you need to calculate the mean for. This is usually a set of three or more numbers. Make sure to include all the numbers in the series, including 0 and negative numbers. For example, you might need to find the average low temperature in Chicago in the first week of January.
http://www.wikihow.com/Calculate-Averages-%28Mean%2C-Median%2C-Mode%29
You find the mean of negative numbers the same way you find the mean of any numbers. You add them up and then you divide by the number of numbers. An example, using -3, -4, -6, and -9. The sum is -22. N is 4.
http://www.answers.com/Q/How_do_I_Find_the_mean_of_negative_numbers
The relationship between negative numbers, positive numbers, and zero is often expressed in the form of a number line: Numbers appearing farther to the right on this line are greater, while numbers appearing farther to the left are less.
https://en.wikipedia.org/wiki/Negative_number
Operations with Negative Numbers. Commonly, plus and minus signs are used to indicate addition and subtraction, respectively. Those signs can also be used to indicate directed distances and specific points on a number line. A positive number means a move to the right on the number line, while a negative number means a move to the left.
https://eduplace.com/math/mathsteps/6/b/index.html
Calculating a Geometric Mean with some negative values I am trying to work out how to calculate the geometric mean of a series of values, some of which are negative, ie. investment returns over a series of years with some negatives. The Geomean function doesn't work because it only uses positive numbers.
https://www.mrexcel.com/forum/excel-questions/264366-calculating-geometric-mean-some-negative-values.html
In mathematics, a negative number is a real number that is less than zero. Negative numbers represent opposites. If positive represents movement to the right, negative represents movement to the left. If positive represents above sea level, then negative represents below level.
https://en.wikipedia.org/wiki/Negative_number
finding the mean with negative numbers
To find the mean with negative numbers, add them up and then divide by the number of numbers.