How To Calculate

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

How to Calculate Weighted Average in Excel.

Rosemary Njeri

Weighted average is a calculation that takes into account the varying degrees of importance of the numbers in a data set.

One advantage of using the weighted average method is consistency.

Formula to calculate weighted average in excel.

To find the weighted average in excel we’ll be required to to sum the product of the score and their weight then divide the result by the sum of the weights.

Example:

ScoreWeight
6020%
8270%
985%
925%

We’ll begin by transferring the data to an excel spreadsheet.

 Weighted Average in Excel.

Then we’ll type our formula.

 Weighted Average in Excel.

After clicking OK we get our answer.

 Weighted Average in Excel.

Therefore, your weighted average is 78.9.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Quartiles.
Quartiles are the values that divide a list of numbers …

How to Calculate Quartiles.

How to Calculate RMS.
RMS stands for root square mean. Root Mean Square, or …

How to Calculate RMS.

Leave a Reply

Cancel reply

Popular Posts

  • How to Calculate Degrees of Unsaturation.
    January 6, 2021 0
  • How to Calculate Buoyant Force.
    January 6, 2021 0
  • How to Calculate Stairs.
    January 6, 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