3 ms·
To be fair, Excel's concept of a weighted average has no basis in statistics or common sense, as I have seen in a couple of published works. Here's a tip: if y
by tadfisher 14y ago
To be fair, Excel's concept of a weighted average has no basis in statistics or common sense, as I have seen in a couple of published works.
Here's a tip: if your results are reproducible only in Excel, something is terribly wrong.
- podperson 14y agoI don't think they were using Excel's weighted average function in this case but simply averaging filtered figures per country and then averaging the averages. This has no statistical basis, but it's not Excel's fault