Average standard deviation

If I have monthly returns for 10 different mutual funds, how do I calculate the average standard deviation for all the 10 funds together? Can I use the average return of each month for all the 10 funds or should I calculate the standard deviation of each fund first?

 

Calculate the standard deviation of each fund first and then take the average of that. If you average the returns, you will dramatically lower the standard deviation calculated (it's wrong in other words).

''You can fool some of the people all of the time, and those are the ones you need to concentrate on.'' — President George W. Bush 0.5 bb
 
dannee_:
ah thats what i thought, thanks man. Is it the same for the returns? Because I averaged the monthly returns so that I could plot them in a diagram.
Is what the same for the returns?
''You can fool some of the people all of the time, and those are the ones you need to concentrate on.'' — President George W. Bush 0.5 bb
 
Best Response
dannee_:
If I have monthly returns for 10 different mutual funds, how do I calculate the average standard deviation for all the 10 funds together? Can I use the average return of each month for all the 10 funds or should I calculate the standard deviation of each fund first?

It depends on the extent to which the 10 different funds are correlated with one another. You can do this on excel or with stat software. However, you will likely see some gains from diversification (that is, real correlations usually aren't exactly 1, so the SD of the portfolio will be less than the weighted average SD of the funds).

 
FinanceWhiz1989:
dannee_:
If I have monthly returns for 10 different mutual funds, how do I calculate the average standard deviation for all the 10 funds together? Can I use the average return of each month for all the 10 funds or should I calculate the standard deviation of each fund first?

It depends on the extent to which the 10 different funds are correlated with one another. You can do this on excel or with stat software. However, you will likely see some gains from diversification (that is, real correlations usually aren't exactly 1, so the SD of the portfolio will be less than the weighted average SD of the funds).

WTF are you talking about? No, it does not 'depend' for what he's trying to do. The correlations are less than one, because he is looking at different funds. You're trying to complicate this and it's unnecessary and wrong. What you say about the "SD of the portfolio will be less than the weighted average SD of the funds" is true, but completely irrelevant.
''You can fool some of the people all of the time, and those are the ones you need to concentrate on.'' — President George W. Bush 0.5 bb
 
Dubya:
FinanceWhiz1989:
dannee_:
If I have monthly returns for 10 different mutual funds, how do I calculate the average standard deviation for all the 10 funds together? Can I use the average return of each month for all the 10 funds or should I calculate the standard deviation of each fund first?

It depends on the extent to which the 10 different funds are correlated with one another. You can do this on excel or with stat software. However, you will likely see some gains from diversification (that is, real correlations usually aren't exactly 1, so the SD of the portfolio will be less than the weighted average SD of the funds).

WTF are you talking about? No, it does not 'depend' for what he's trying to do. The correlations are less than one, because he is looking at different funds. You're trying to complicate this and it's unnecessary and wrong. What you say about the "SD of the portfolio will be less than the weighted average SD of the funds" is true, but completely irrelevant.

I concentrated in statistics at Wharton UG, where I helped teach four different courses in statistics. I'm not sure why you're so angry, but thanks for the comment regardless.

 
SirTradesaLot:
OP -- this is a poorly worded question. Are you trying to determine the avg vol of each of the funds or are you trying to determine the vol of the combo of the ten funds?

im trying to determine the avg vol of each of the funds, so I can compare it with another group of funds. So im not interested in knowing the vol of the combo.

 
dannee_:
SirTradesaLot:
OP -- this is a poorly worded question. Are you trying to determine the vol of each of the funds or are you trying to determine the vol of the combo of the ten funds?

im trying to determine the vol of each of the funds, so I can compare it with another group of funds. So im not interested in knowing the vol of the combo.

Ok, so I would do it the way the guy at the top (Dubya) said to do it. Calculate the vol of each fund and then average those vols. If you're not making a portfolio out of these ten funds, you don't need to worry about their correlations. It should be as simple as it gets.
 

Velit minima voluptatem aut recusandae accusamus soluta saepe. Laboriosam et eum reprehenderit itaque alias. Officia inventore cupiditate eos sit dicta sapiente provident. Ut nihil rerum voluptas excepturi quis ratione.

Exercitationem itaque velit magni totam tempora quis cumque. Sunt aut accusantium cupiditate ut nostrum molestiae.

Excepturi repellat nulla aut. Aut velit sapiente necessitatibus excepturi dolores. Non magnam aut quidem numquam. Commodi vero facilis voluptate est. Recusandae dignissimos tempore perspiciatis molestias porro aut vel.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”