# AVERAGE: Basic AVERAGE function from excel In ExcelFunctionsR: Imports Excel Functions to R

## Description

It acts similiarly to Excel's AVERAGE function. It simply calculates average of the given numbers.

## Usage

 ``` 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26``` ```AVERAGE( number1, number2 = NA, number3 = NA, number4 = NA, number5 = NA, number6 = NA, number7 = NA, number8 = NA, number9 = NA, number10 = NA, number11 = NA, number12 = NA, number13 = NA, number14 = NA, number15 = NA, number16 = NA, number17 = NA, number18 = NA, number19 = NA, number20 = NA, number21 = NA, number22 = NA, number23 = NA, number24 = NA ) ```

## Arguments

 `number1, number2, number3, number4, number5, number6, number7, number8, number9, number10, number11, number12, number13, number14, number15, number16, number17, number18, number19, number20, number21, number22, number23, number24` Give this function number, same goes for other number arguments as well, but they are optional.

## Value

As you can see in the example below, the average of numbers 10,20,30,40 is 25. By default excel removes NA values, by NA values I mean Excel's blank cells. Function will always return numeric class.

## Examples

 `1` ```AVERAGE(10,20,30,40) ```

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.