The word average means middle or central point.
Most of the time when we are required to calculate the average of a list of data we are supposed to calculate the ‘mean’ of the given data.
Formula to calculate average in google sheets.
To calculate average in google sheets, we only need the AVERAGE Function and arguments just like in excel.
Calculate the average of the following random data set using google sheet.
2, 5, 8, 9, 4, 5, 6.
Therefore, just like in excel, we rewrite our data on the spreadsheet.
- Choose where you want your answer to appear.
- Then click on insert.
- Choose the function option.
- Click on the AVERAGE function, insert your arguments and click enter.
Therefore, the average is 5.571428571.