How do you work out averages on excel?

Answer 1

Mathematically, the average is the sum of all values, divided by the number of values there are. This is known as the arithmetic mean. You can get it by using the Average function, which is the simplest way. Another way would be to the spreadsheet to total the values and count the amount of values and divide the total by the amount of values. If you were trying to get the average of the cells from A1 to A100, you could either do:

=Average(A1:A100)

or

=Sum(A1:A100)/Count(A1:A100)

Using the Average function is the best way. There are also two other forms of average, other than the arithmetic mean. They are the Mode and Median. The Mode is the most common value in a list and the Median is the middle value when all are arranged in numerical order, although you don't have to do the sorting yourself as the function is able to work it out. They are done as follows:

=Mode(A1:A100)

=Median(A1:A100)

Answer 2

First you need to work out your costs. When you have the costs, you need to know what cells on the spreadsheet those costs are in. Then you use the Average function to get an average of those costs. If all your costs are in the cells from B2 to B15 are, your formula would be:

=Average(B2:B15)

That formula can't go in any of those cells, so it could go in B16 perhaps. If the costs are in cells that are not beside each other, you may have to reference them differently. Say your costs are in cells B3, B7, B9, C10, C14 and D15, then your formula would be:

=Average(B3,B7,B9,C10,C14,D15)

So once you know where your cells are, you use the Average function and reference the cells that your costs are in. It is a good idea to lay your spreadsheet out in a structured way, as that will make your formulas easier to create. You can see that the first one is simpler than the second one, even though the first one averages far more cells.

Answer 3

The best way normally is to use the Average function, as in =AVERAGE(A1:A10). You can also find this function under the math functions, if you list them. If you don't have a single column of values, but instead have something like an interval (column of starts, column of stops), it is easiest to build a third column of your stops minus starts (i.e. the interval) and average those. Example: start and stop times, but need the average amount of time taken for all the interactions.

Answer 4

Use the AVERAGE function. Assume you want to find the average (mean) of a column of numbers in A1-A10 and show the results in C2. There are many methods you could use to calculate average. The simplest solution is to put the formula =average(a1:a10) in cell C2. The average function will add all the number in the range (ignoring blank cells) and divide by the number of entries that contain numbers. This is important if you are trying to find the average of a collumn that contains blank cells or cells with characters instead of numbers.

Answer 5

The simplest way is to use the Average function.

This will give you the average of all the numbers in the cells from A2 to A10:

=Average(A2:A10)

This will give you the average of the values in all the cells listed and the 34 and 39:

=Average(A4,A13,B30,C10,34,39)

Answer 6

Use the AVERAGE function. If you want to find the average for numbers in cells A1 - A10, use the formula =average(a1:a10).

Answer 7

you select it all and press equal