The file Stock.xlsx contains monthly stock returns for General Motors and Microsoft. Name the ranges containing the monthly returns for each stock and compute the average monthly return on each stock.

Transcribed Image Text:

E F -0.240320429 -0.202509 0.276619107 0.338983 CSCO 0.037267081 53 30-Apr-90 54 31-May-90 0.258620679 0.083515622 55 29-Jun-90 0.121518984 0.040485829 0.022284122 0.010753 0.047404062 -0.003891051 -0.053892214 -0.035422344 0.010638 0.221518993 0.115819208 0.042105 0.005444646 -0.025906736 -0.020565553 0.070707 0.034296028 -0.05319149 -0.020997375 -0.037736 -0.25 -0.131367296 -0.029412 -0.088050313 -0.090909 0.04109589 56 31-Jul-90 -0.125 57 31-Aug-90 -0.075187966 -0.13438046 58 28-Sep-90 0.024390243 -0.003745318 -0.113387093 -0.04587156 0.007518797 0.013793103 0.311111 59 31-Oct-90 0.011904762 60 30-Nov-90 0.13333334 0.052884616 0.119402982 0.013605442 0.338983 61 31-Dec-90 0.041522492 0.057260275 62 31-Jan-91 0.115468413 0.303986698 0.026666667 -0.05821918 0.136076 0.188311681 0.054545455 0.303621 0.043715846 0.100689657 -0.042735 0.023897059 -0.020942409 -0.044303797 -0.129464 0.016157989 0.053475935 -0.052980132 0.220513 0.09908127 0.131979689 0.217482507 0.084034 67 28-Jun-91 -0.068906605 -0.042071197 -0.165919289 -0.055072464 -0.054264 63 28-Feb-91 0.057324842 0.070468754 64 28-Mar-91 0.022891566 65 30-Apr-91 -0.067137808 66 31-May-91 0.108585857 68 31-Jul-91 -0.024539877 0.286885 69 30-Aug-91 0.078899086 -0.010135135 0.010752688 0.159863949 0.022184301 0.053191491 -0.033962265 0.156051 0.043988269 -0.066644408 -0.146464646 -0.016447369 -0.096419 -0.03846154 -0.060200669 0.189024 70 30-Sep-91 71 31-Oct-91 0.054775283 -0.005405406 Figure 30-1 Monthly stock returns. A 49 50 B 51 Date 52 30-Mar-90 Microsoft с GE D min max Intel GM