Which formula is correct to calculate the average of the value from cell R6 to r19
Answers
Answer:
Sum of conversation divided by number of observation
Hope it will help you
Answer:
The AVERAGE function is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. It is used to calculate the arithmetic mean of a given set of arguments in Excel. This guide will show you, step-by-step, how to calculate the average in Excel.
As a financial analyst, the function is useful in finding out the average (mean) of a series of numbers. For example, we can find out the average sales for the last 12 months for a business.
Formula
=AVERAGE(number1, [number2], …)
The function uses the following arguments:
Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average.
Number2 (optional argument) – They are the additional numbers, cell references or a range for which we want the average. A maximum of 255 numbers is allowed.