1. M

    Weighted Avg excluding outliers

    Greetings, I have two columns of data: A) Stock P/E B) Port Weight The data is susceptible to outliers so I'm using TRIMMEAN to calculate the average P/E. Now I'd like to calculate a weighted average that also excludes outlier values. Assuming I can't simply delete the outliers from the data...

Some videos you may like

This Week's Hot Topics