# weighted average.

#### Npsays

##### Board Regular
Hi !
I am stuck with how can we calculate weighted average. for e.g.

unit weight percentage error percentage
65% 1.49%
27% 0.84%
8% 0.75%

In the above 'unit weight' is allocated to 3 departments and besides the unit weight is the percentage of errors done by the unit. I need toi calculate the weighted error average for all 3 departments... any ideas pls ?

Thanks..says np.

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Try =sumproduct(A2:A4,B2:B4) where A2 has your 65%.

Hi np.

Isn't it just an average of the averages?

I.e. ((1.49% + 0.84% + 0.75%) / 3)?

A = 1.03%

Or am I wrong?

Tamer:

No, that ignores the weighted part. 65% of the combined average should come from the 1.49%, so sumproduct is the way to go.

The "average of the averages" is 1.027%, but the weighted average is 1.255%

Thanks oaktree,

I make a point of getting an answer wrong every now and again to stop people from thinking I'm perfect and relying on me too much!

Generally, it works quite well.

Hey ! thanks both of you ! and tamer.. i like your sense of humor

Replies
2
Views
133
Replies
1
Views
840
Replies
5
Views
4K
Replies
0
Views
308
Replies
2
Views
265

1,203,525
Messages
6,055,916
Members
444,834
Latest member
ComputerExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back