Question: Use your answer to Problem 1 to compare the monthly returns on Intel and GE stock. Data from in Problem 1 Use the data in

Use your answer to Problem 1 to compare the monthly returns on Intel and GE stock.


Data from in Problem 1


Use the data in the file named Stock.xlsx to generate descriptive statistics for Intel and GE stock.


A 49 50 51 Date B Microsoft GE min max Intel D

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

Step by Step Solution

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To generate descriptive statistics for Intel and GE stock using the data from the Stockxlsx file you ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!