Enter the data you want to calculate a weighted average for. Finding a Weighted Average 1. Simple moving average N period sum N where.
So 027 multiplied by 100 equals 27 or 27.
To find the average percentage of the two percentages in this example you need to first divide the sum of the two percentage numbers by the sum of the two sample sizes. The simplest Excel Average Formula for a set of values consists of the sign followed a the sum of the values all divided by the number of values in the group. Finding a Weighted Average 1. Many people used to find out average by divide the sum of the total by two buts it does not give the correct number.