How to Calculate Arithmetic Mean or Average in Excel Worksheet

Excel Worksheet Formula =AVERAGE()

This below example illustrates how the AVERAGE function can be used in Excel Worksheet. This function returns the Arithmetic Mean of arguments we mentioned in the formula. For example, if the range A2:A10 contains numbers, the formula =AVERAGE(A1:A10) returns the average of those numbers. In the below example the Arithmetic Mean have been calculated separately for the row ranges from A2 to A10 and the Row B ranges from B2 to B10 by using the formulas =AVERAGE(A2:A10) and =AVERAGE(B2:B10) respectively. The cumulative arithmetic mean also have been calculated by using the formula =AVERAGE(A2:A10,B2:B10)
Syntax
AVERAGE(number1, [number2],...)

Arithmetic Mean Calculation in Excel

Average or Arithmetic Mean Calculation in Excel Worksheet


Related Topic Calculate Standard Deviation in Excel
C Program to find Mean, Standard deviation & variance | Array example
Calculate Standard Deviation in Perl
How to Calculate Data Set Variability in Excel
Inverse Hyperbolic Sine Function ASINH() Excel Formulas

nScraps.com 2011   Privacy Policy  Terms of Service  Feedback