answersLogoWhite

0


Best Answer

Average Function

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Sums numbers in range and divides by number of values?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What sums numbers in range and divides by number of value?

Average function


What is the Function that adds the values of cells in a range and divides the result by the number of cells?

The AVERAGE function.


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 is the range of fx equals 2x - 5?

Domain is the number of x values that can be used and not cause an imaginary result. Range is the number of the y values that result. In f(x)=2x-5 the range is all real numbers.


The AVERAGE function displays the lowest value in a range?

No. The MIN function displays the lowest value in a range. The AVERAGE function gets the arithmetic mean of a set of values. It totals them up and divides by the amount of numbers.


Why does a positive number and a negative number cancel each other out?

The range of the numbers from 0 is what additively cancels the different values


How do you find the range of a number set beginning with zero?

The range is defined as the difference between the largest and the smallest values. One of these is known to be 0. If all the other numbers are negative, then the range is the absolute value of the smallest number whereas if all the other numbers are positive, the range is the largest number.


What is the difference between count and countA?

Count: counts the number of cells with numeric values in a range. Counta: counts the number of cells containing data (letters or numbers) in a range. Counta counts the number of non-blank cells in a range. Counta will therefore exclude any empty cells, which would be included if the count function were used.


What does range of values mean?

a rang of values is a list of different Numbers eg: the speed of every car in a race would be a range of values


What does the maths term median mean?

It is the value of all numbers in the range in which there are as many values above it as there are below it. For example for the ordered values 1,3,7,9,10,12,15,19,21 the median value is 10. It is not he same as the mean, or average, which is the sum divided by the number of values.


What is a number plotted on a number line?

The number can be equal to minus, zero or plus when plotted on the number line and two numbers plotted on the number line can have a range of numerical values.


How do you detemine range median and mode?

The range of a set of numbers is the biggest number minus the smallest number.When the set of numbers is put in order, if there are an odd number of values, then the median is the value in the middle position. If there are an even number of values then the median is the average of the middle two values.The mode is the value which features most often. There can be several, one or no modes.