Today, we help you find out ways to Calculate Averages in Google Sheets.
Google Sheets is a spreadsheet app that is included with Google’s free, web-based Google Docs Editor suite. Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep are also included in the service. Calculating averages in Google Sheets is one of the simplest (and most useful) operations. Are you a Google Sheets newbie who is simply trying to analyze numerical values? You could look at the average value.
You can select the closest central value for an entire set of data using the average. The average enables you to spread out the volatility if your values fluctuate up and down. Making decisions based on your data may become simpler as a result.
Related:
How to Create a Dropdown List in Google Sheets
How to Setup Google Drive as Local Drive on Your Computer
Here’s How to Calculate Working Days in Excel (with/without Holidays)
The steps listed below will show you how to calculate averages in Google Sheets if you’re a beginner.
Contents
When you select two or more cells in Google Sheets that contain numerical values, a drop-down menu appears in the bottom right corner.
These quick calculation menus will usually show you a quick total of all the values. You can also use the menu to display additional calculations, such as the average.
To find the average quickly in Google Sheets, use the quick calculations menu:
- Begin by opening your Google Sheets spreadsheet.
- Choose two or more cells that contain your values.
- Select an option from the drop-down menu in the bottom right corner.
- Choose the Avg option.
You can view the average value (the mean) of the cells you’ve chosen by selecting the average. The value will alter if you modify your selection by adding or removing cells. This enables you to view an updated average value in Google Sheets quickly.
How to use the explore tool
Use the explore tool to display a data set’s average value along with other common calculations. The explore tool also provides suggestions and guidance, along with quick calculations.
Utilizing Google Sheets’ explore tool, calculate averages as follows:
- Launch Google Sheets and open your spreadsheet.
- Chose the cells that contain the values you want.
- Select Explore by clicking in the bottom right corner.
- On the right, a pop-up menu will appear. You’ll see various calculations at the top, and one of them will include the average value.
How to use the AVERAGE Function
The average function returns an average value but does not allow you to interact with it. If you want to use the average in another formula, for example, you must use the AVERAGE function.
In Google Sheets, use the AVERAGE function to find averages:
- Begin by opening your Google Sheets spreadsheet.
- Choose an empty cell.
- Enter =AVERAGE(cell:range) in the formula bar, replacing cell:range with a suitable cell range containing your values (eg. A2:A20).
- To see the returned value, press enter on your keyboard.
Conclusion
You can quickly calculate averages in Google Sheets by following the above instructions. If you know what you’re doing, Google Sheets can be a serious competitor to Excel thanks to its tools, functions, and formulas.
There are additional approaches to data analysis, such as developing filter views. You can also use Google Sheets to sort your values by dates or, if you’re working with text, by A-Z (or Z-A).