0
average function
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What function sums the numbers in the specified range and then divides the sum by the number zero?
No function will add numbers up and divide the total by zero, as it is a mathematical impossibility to divide by zero. If your question meant to say that you want to divide by the amount of numbers that were summed to make the total, then the function is the AVERAGE function.
How many different sums can you make from 5 numbers?
you can make at least 25 sums
What is a three digit number that sum to 871?
"Sum" requires at least two numbers. So there cannot be athree digit number that sums to anything.
Which is the only number which is equal to the sum of its digits?
Well, 1 is equal to 1. 9 is equal to 9. So any number from 0 to 9. I do not think this is what is meant by the question. If you mean any number with more than one digit. There is no such number. Because 11 sums to 2. 19 sums to 10. 21 sums to 3. 29 sums to 11. 111 sums 3. 119 sums to 11. The sums do not grow as fast the increase of digits.
How is the mean calculated?
Add all the sums, then divide by the number of sums. (ie. the average.)
What are the sums numbers then divides by the number of values?
The average or arithmetic mean.
Sums numbers in range and divides by number of values?
Average Function
Sums number then divides by the number of values?
Average Function
What Excel function sums values and then divides by the number of values?
The AVERAGE function.
What sums of numbers then divides by the number of values?
That sounds like the mean average.
What sums numbers in range and divides by number of value?
Average function
What function sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range?
I assume you mean in Excel. Use the average() function.
What function sums the numbers in the specified range and divides the sum by the number of the cells?
To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.
Function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range?
AVERAGE(range)
What function sums the numbers in specified range and then divides the sum by the number of non-zero cells in the range?
The Average function.
What function sums the numbers in the specified range and thendivides the sum number cells with numeric values in the range?
The mean, except that Excel calls it "Average".
What function sums the numbers in the specified range and then divides the sum by the number zero?
No function will add numbers up and divide the total by zero, as it is a mathematical impossibility to divide by zero. If your question meant to say that you want to divide by the amount of numbers that were summed to make the total, then the function is the AVERAGE function.
