how to calculate average percentage in excel

how to calculate average percentage in excel

Share this video:
youtu.be/wgtIxBhvw_w

How To Remove Password In Windows 10 8 7 With PC Unlocker Urdu Hindi
youtu.be/De63X922Xmo


In the event that your %'s are in A2:A100, enter this equation in A101

=AVERAGE(A2:A100)

The most effective method to Do Averages With Percentages in Excel

Midpoints are commonly processed as the entirety of qualities partitioned by the quantity of information focuses. Be that as it may, midpoints are likewise measurable from rates. For instance, grades in a course may be weighted diversely between tests. On the off chance that that is the situation, a basic normal would inclination the outcome. Rather, you would utilize the rate weight while computing the normal. By developing an Excel spreadsheet, this figuring turns into a straightforward matter of information section.

Step 1

Open Microsoft Excel.

Step 2

Enter the information to be found the middle value of in segment A. For instance, in the event that you had three standard tests, a midterm and a last, you may enter evaluations of 85, 100, 90, 80, 95 in cells A1 through A5.

Step 3

Enter the comparing rates in segment B. In the case, if general tests were worth 10 percent each, the midterm was worth 20 percent and the last 50 percent, then you'd enter 10%, 10%, 10%, 20% and half in cells B1 through B5. Make sure to incorporate the rate image so Excel knows they are rates.

Step 4

Enter "=A1*B1" without quotes in cell C1. In the illustration, this duplicates 10 percent times 85 to get 8.5.

Step 5

Click the lower right corner of cell C1 and drag to the last cell in segment C, which relates to the last information section in segments An and B. This duplicates the recipe to the chose cells. In the illustration, you would drag your mouse down to cell C5.

Step 6

Enter "=sum(C:C)" without quotes in cell D1 to ascertain the normal utilizing rates.


Subscribe our YouTube Channel:
youtube.com/channel/UCsuI1AWKK31iXzhKtG-zTfg

Facebook:


Google:
plus.google.com/u/0/111849326672730286270

Twitter:
twitter.com/nouman86ryk1

If you like this video so share it and subscribe our Channel now for more videos.

how to calculate average percentage in excel