Q:
# What Is the Weighted Average Function in Excel Used For?

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

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.

Learn more about Software-
Q:
## How Do You Round Numbers in Excel?

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: -
Q:
## How Can You Sum in Excel?

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: -
Q:
## How Do You Use VLOOKUP in Excel?

A: Excel’s VLOOKUP is a reference function for viewing specific data in a spreadsheet or table. The function searches for a value in the leftmost column of yo... Full Answer >Filed Under: -
Q:
## How Can You Calculate a Standard Deviation Using Excel?

A: Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is... Full Answer >Filed Under: