Step 1: We have the following data with values and their weight, for which we will calculate the average weighted. Let's take an example to calculate the average weighted. The SUMPRODUCT function is actually worked like - (45*1)+(38*2)+(41*3). Its process of calculation is completely different than the simple average calculation.Īverage weighted requires values and their corresponding weights. This time, we will calculate the average weighted by using the SUM and SUMPRODUCT function of Excel, as we already discussed earlier. It was the normal average calculation using Excel AVERAGE() formula. Step 4: Once you click the Average, average for the selected cells will be calculated and displayed in the below cell. Step 3: Inside the Formulas tab, and click the AutoSum dropdown button and select Average formula. Select the targeted cells and navigate to the Formulas tab. Step 2: So, we will use the simple mathematic Excel formula. For which, we need to calculate the average. Step 1: Suppose we have the following data of three subjects marks of a student. For simple average calculation, Excel users use mathematical formulas, i.e., Sum of values/Number of values.įollowing are the examples and steps to calculate the simple average. If the user simply uses the AVERAGE() function, It will return the simple average after calculation for the given values. So, please do not get confused between them. Example 1: Simple Average calculationĪverage and average weighted terms are different. So, these functions work together to calculate the average weighted. One for values array and another for their weight array. Usually, the SUMPRORDUCT() function takes two arguments. This function enables the users to calculate the sum for the range of cells. It is a most used function of Excel that helps to calculate the sum of numbers. You might have already used the SUM() function earlier. Now, let's see how the SUM and SUMPRODUCT functions work to calculate average weighted. So, remember - the simple average and average weighted both are different.
If you simply use the AVERAGE function, it will find the normal average. These functions will be used to find out the average weighted in Excel. The Excel users require two functions to calculate the average weighted, i.e., SUM and SUMPRODUCT. Hence, we will describe the ways to calculate the average weighted in MS Excel using its built-in formulas. There could be various scenarios where you may need to calculate the average weighted. To calculate the weighted average, you can use the SUM and SUMPRODUCT functions of Excel. Usually, users calculate the average as Sum of values/Number of values. Instead of that, we will find an estimation of the week temperature. In that case, we are not going to tell the everyday temperature. Let's suppose calculate the weather of the week. Have you ever heard about the average weighted or average? Usually, we cannot calculate everything in our daily life. Next → ← prev Calculate average weighted in Excel
0 kommentar(er)
