How To Calculate

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

How to Calculate Average in Excel.

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 excel.

Since the formula to calculate average can be found in excel, it is pretty easy to calculate it using the average function.

=AVERAGE(X1:Xn)

Example:

Suppose you are given a data set containing the name of students and their mathematics percentage and asked to calculate the average of their mathematics marks.

Name of StudentMarks
Archie90
Millicent92
Jeff94
Veronica90

We will begin by transferring the data to an excel spreadsheet.

Calculate Average in Excel.

We continue by adding another row and label it Average and put our average function just below the marks column and press enter to get your average.

Calculate Average in Excel.

Therefore, their average mark is 91.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Geometric Mean.
Geometric mean is a mean or average, which indicates the …

How to Calculate Geometric Mean.

How to Calculate Equilibrium Price.
The equilibrium price is where the supply of goods matches …

How to Calculate Equilibrium Price.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 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 © 2023 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