Other terms used to describe groups of numbers are median and mode. The weighted average is used when the items to be counted are not easily distinguishable from each other. To see a quick average without a formula you can use the status bar.
Below you can see this formula in action where n is the named range E2.
The average speed formula is. Average which is the arithmetic mean and is calculated by adding a group of numbers and then dividing by the count of those numbers. Average Speed s total distance total elapsed time A v e r a g e S p e e d s t o t a l d i s t a n c e t o t a l e l a p s e d t i m e Average speed contrasts with instantaneous speed. The formula below calculates the average of the top 3 numbers.