answer question 3 and 4 with full steps and answers

3. Compute the mean monthly returns and standard deviations for the monthly returns of each of the stocks. Convert the monthly statistics to annual statistics for easier interpretation (multiply the mean monthly return by 12 , and multiply the monthly standard deviation by 212 ). 4. Add a column in your Excel worksheet with the average return across stocks for each month. This is the monthly return to an equally weighted portfolio of these 12 stocks. Compute the mean and standard deviation of monthly returns for the equally weighted portfolio. Double check that the average return on this equally weighted portfolio is equal to the average return of all of the individual stocks. Convert these monthly statistics to annual statistics (as described in Step 3) for interpretation