At the bottom of the column for each stock calculate the Average Monthly Return (use AVERAGE()...

Transcribed Image Text:

At the bottom of the column for each stock calculate the Average Monthly Return (use AVERAGE() function) and the Standard Deviation [use STDEV.P()] population function NOT STDEV() sample function). As a check, you should find your average returns to be: MSFT = 1.0477% and SPY = .64687%. (5 points) At the bottom of the column for each stock calculate the Average Monthly Return (use AVERAGE() function) and the Standard Deviation [use STDEV.P()] population function NOT STDEV() sample function). As a check, you should find your average returns to be: MSFT = 1.0477% and SPY = .64687%. (5 points)

Answer rating: 100% (QA)

To calculate the average monthly return and standard devia... View the full answer