Q:

# What is the weighted average function in Excel used for?

A:

The weighted average function in Excel calculates the average of a group of numbers with one or more of the numbers given more weight or a higher level of importance. For example, when averaging grades together, a teacher may give more weight to a test versus a worksheet assignment.

## Keep Learning

In Excel, the SUMPRODUCT function calculates weighted averages by multiplying the numbers by the specified weight, adds the total and divides by the number of assignments. For example, if a test is 40 percent of a grade but three homework assignments make up 20 percent each of the final grade, the SUMPRODUCT function calculates the weight of each.

Sources:

## Related Questions

• A: Though there are several functions in Excel for rounding numbers, the ROUND function is the most basic and the most commonly used. Keep in mind that when u... Full Answer >
Filed Under:
• A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >
Filed Under:
• A: There are two basic ways of calculating variance in Excel using the function VAR or VAR.S. These functions can then calculate variance in several ways: use... Full Answer >
Filed Under:
• A: Use the DATE function in Excel to list dates. Use the TODAY function to list the current date or the NOW function to list current date and time.... Full Answer >
Filed Under:
PEOPLE SEARCH FOR