Use the data in the following table (or the data in the attached Excel spreadsheet): a) What was the average dividend yield for the S\&P 500 from 1991-2021? (Hint: use Pt1Div to calculate the annual dividend yield) b) What was the volatility of the dividend yield? c) What was the average annual return of the S\&P 500 from 1991-2021 excluding dividends (i.e., from capital gains only)? d) What was the volatility of the S\&P 500 returns from capital gains? e) Were dividends or capital gains a more important component of the S\&P 500 's average returns during this period? Which were the more important source of volatility? Note: Show your work. Do NOT submit only an excel spreadsheet but also clearly write down your answers to questions (a) through (e). Use the data in the following table (or the data in the attached Excel spreadsheet): a) What was the average dividend yield for the S\&P 500 from 1991-2021? (Hint: use Pt1Div to calculate the annual dividend yield) b) What was the volatility of the dividend yield? c) What was the average annual return of the S\&P 500 from 1991-2021 excluding dividends (i.e., from capital gains only)? d) What was the volatility of the S\&P 500 returns from capital gains? e) Were dividends or capital gains a more important component of the S\&P 500 's average returns during this period? Which were the more important source of volatility? Note: Show your work. Do NOT submit only an excel spreadsheet but also clearly write down your answers to questions (a) through (e)