How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate Average in Google Sheets.
statistics

How to Calculate Average in Google Sheets.

Rosemary Njeri

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.

Example:

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.

Average in Google Sheets.
  • 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.
Average in Google Sheets.

Therefore, the average is 5.571428571.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

Calculate Critical Value.
Critical values are essentially cut-off values that define regions where …

How to Calculate Critical Value.

Calculate Exponential Growth.
Exponential growth is a pattern of data that shows greater …

How to Calculate Exponential Growth.

Leave a Reply

Cancel reply

Popular Posts

  • How to Calculate Linear Regression Line.
    February 1, 2021 0
  • How to Calculate Anion Gap.
    February 1, 2021 0
  • How to Calculate MLU.
    February 1, 2021 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2021 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh