answersLogoWhite

0


Best Answer

An average is a key component of statistics. An average is value that is a typical representative of the set of data you have. We have the average function, correctly known as the arithmetic mean. We also can get over kinds of averages known as the mode and median. One of Excel's main uses is for analysing numbers and using averages are a fundamental element of that. So having the Average function along with the many other statistical functions that Excel provides is very important and extremely useful.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the usefulness of the average formula in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Math & Arithmetic

How do you calculate the mean of data using Excel?

Pick a cell in which to enter your formula Type: =average( then highlight the cells you wish to average. Press enter.


What is an expression in excel?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?

'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '


What is the Excel formula to show exponents?

There are two ways to express exponents in Excel.=6^3=POWER(6,3)


What is it called where excel displays data as you enter it?

formula bar

Related questions

How do you insert the formula of mean in excel?

=AVERAGE(Firstcell:lastcell) i think


Why is the formula C3H6O2 of limited usefulness?

aldol


What Functions may be entered for formulas in Excel?

Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.


What is the formula to find the sum of cells a1 a2 and a3 in excel?

Excel formulas that will find the average of cells A1, A2, and A4 are: =AVERAGE(A1 ,A2, A4) or =AVERAGE(A1:A2, A4)


What does average formula do?

The average formula, in programs like Microsoft Excel and many others, take the sum of all the numbers that a user inputs into a list and divides it by the number of numbers in that same list.


What does the AVERAGE formula do?

The average formula, in programs like Microsoft Excel and many others, take the sum of all the numbers that a user inputs into a list and divides it by the number of numbers in that same list.


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


How do you calculate the mean of data using Excel?

Pick a cell in which to enter your formula Type: =average( then highlight the cells you wish to average. Press enter.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


How do you do get Excel to do an average of 10000 numbers?

Put the 10000 numbers into cells, say from A1 to A10000 and then enter the following formula into a cell: =AVERAGE(A1:A10000)