how to do a subset with the columns relating to BSE and the following 5 stocks motilalofs, whiripool, bhel, ipcalab and oil compute the daily returns of each of these stocks and midcap index and interpret their descriptive statistics in depth
Excel FA Q1 - Saved to OneDrive 9 Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Open in Desktop App Editing v Calibri 11 B ... ab - V General I V A1 fx Date A B C D E F G H I J K M N O P Q |Date BATAINDIA TATAPOWE MOTILALOFS MANAPPU IPCALAB GLENMAROIL WHIRLPO(BHEL AARTIIND FEDERALB MRF SUNTV APOLLOTY SAIL Midcapindex 04-May-15 1035.85 77.2 296.3 35.9 642.85 906.15 487 715.85 245 328.15 136.45 37790 369.3 177.4 71.5 10549.42 A W N 05-May-15 1063.3 76.2 292.6 35.85 643.55 896.95 486 703.65 244.75 324.35 134.8 37837 357.3 175.8 73.45 10613.15 06-May-15 1041.95 73.35 285.3 35.1 629.3 846.4 470 696.45 229.55 317.25 128.3 36345 342.95 165.2 70.3 10265.23 07-May-15 1035.2 71.65 286.65 34.8 625.45 826 465 680.95 228.4 313.7 125.7 35057 354.45 163.35 67.15 10065.56 08-May-15 1046.2 73.15 291.85 34.9 628.8 834.8 473 676.4 231.3 321 131.25 35885 362.15 164.1 67.5 10236.21 11-May-15 1048.35 74.2 295.6 34.5 641.1 868.75 486 678.8 234.55 330.8 135 36701 366.3 170.95 68.9 10453.96 12-May-15 1044.25 71.5 296.2 33.95 653.7 870.05 483 671.45 222.65 332.9 130.55 35360 356.8 169.6 67.05 10274.08 9 13-May-15 1059.2 73.1 295.85 33.8 653.25 889.7 476 669.3 227.7 313.9 132 36124 351.45 171.75 66.95 10433.87 10 14-May-15 1066.4 73.45 299.7 34.7 660.6 914.1 489 675.3 230.1 317.1 136.75 36462 355 173.75 66.95 10526.94 11 15-May-15 1059.1 72.95 311.3 34 665.65 899.65 497 689.65 230.65 330.2 138.75 36553 347.8 171.25 67.05 10563.92 12 18-May-15 1064 75.2 312.2 34.1 670.45 905.8 500 712.15 234.2 333.35 136.8 37177 362.85 186.35 67.25 10667.07 13 19-May-15 1112.75 75.85 304.05 33.7 661 899.35 497 718.15 234.85 332 138.35 36240 350.9 183.45 67.2 10651.02 14 20-May-15 1097.9 77.2 310.9 33.25 670.4 907 489 734.4 231.3 329.45 141 35918 354.5 187.7 67 10650.78 15 21-May-15 1119.9 76.2 311.4 33.15 665.5 896.2 480 751.65 232.3 327.8 142.55 35772 360.1 183.75 66.3 10606.92 305.45 32.9 652.75 884.9 480 737.15 233.95 331.8 140.5 35674 357.9 183.7 66.15 10619.81 16 22-May-15 1116.7 75.75 141.05 35597 363.75 184 65.75 10611.11 17 25-May-15 1114.3 74.85 298.2 33 659.1 871.35 480 724.05 234.25 326.35 183.5 66.1 10609.96 18 26-May-15 1082.8 74.95 289.4 32.3 656.3 866.3 477 725.9 241 328.05 141.3 35563 370.85 1037.3 75.7 291.1 32.05 651.85 861.3 474 762.15 249.05 319.65 144.25 35735 378.8 183.6 66.15 10616.47 19 27-May-15 32.1 643.55 857.3 476 752.9 251.95 312.85 143 35372 386.2 65.9 10560.04 20 28-May-15 1051.05 74.05 293.65 31.6 656.65 877.15 465 757.15 251.6 316.95 143 35854 378.7 189.85 65.9 10716.09 21 29-May-15 1072 74.75 321.35 747.05 253.95 314 142.8 35961 362.75 185.05 66.15 10712.43 686.1 865.2 483 22 01-Jun-15 1055.45 76.1 307.35 32.15 176.35 65.7 10474.51 02-Jun-15 1034.45 75 296.3 30.8 652.15 860.7 477 730.4 250.75 313.65 139 34632 354.75 23 710.95 245.95 310.1 137.9 34781 348.05 175.25 64.85 10329.46 24 03-Jun-15 1024.85 70.4 290.2 30.75 635.75 853.95 473 713.3 248.2 308.5 136.1 34756 359.3 172.25 62.25 10347.45 25 04-Jun-15 1028.55 70.3 294.5 29.6 637.65 834.1 470 = in + Give Feedback Calculation Mode: Automatic Workbook Statistics onedrive.live.com C Excel FA Q1 - Saved to OneDrive Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Open in Desktop App Editing Calibri v 11 V B A =v ab Custom .00 EV 28 A25 fx 04-06-2015 B C D E F G H I K L M N O P Q R 25 04-Jun-15 1028.55 70.3 294.5 29.6 637.65 834.1 470 713.3 248.2 308.5 136.1 34756 359.3 172.25 62.25 10347.45 26 05-Jun-15 1004 70.6 290.95 28.85 640.1 843 471 716.15 246.45 322.75 135.25 34265 356.35 171.3 63.8 10353.93 27 08-Jun-15 993.2 71.4 291.25 27.3 639.55 854.9 466 705.2 242.8 316.4 133 33816 278.9 174.95 62.65 10194 28 09-Jun-15 978.7 72.15 288.95 28.15 635.7 847.95 466 695.55 241.25 316.9 135.75 32797 290.7 160.9 62.5 10161.25 29 10-Jun-15 993.95 73.75 290.95 27.75 641.55 857.15 471 699.65 251.4 331.4 136.15 33310 295.05 165.4 62.85 10270.77 30 11-Jun-15 994.35 70.15 287.55 27.2 645.2 866.3 468 700 243.25 316.15 132.15 31887 287.35 161.95 60.9 10088.07 31 12-Jun-15 995.75 72.6 285.45 27.95 642.7 880 470 708.3 247.95 315.05 131.8 31862 287.1 164.25 60.3 10121.94 32 15-Jun-15 1026.45 72.1 290.2 18.8 642.1 887.8 467 705.15 247.35 323.8 132.65 32253 303.8 165.55 59.35 10120.8 33 16-Jun-15 1016.6 73.95 289.5 28 659.35 924.05 467 710.85 245.9 323.85 135.05 32406 310.3 165.3 60.05 10197.68 34 17-Jun-15 1012 72.85 293.5 28.15 659 971.1 464 733.95 241.2 320.25 140.9 33058 311.75 167.1 61.15 10344.51 35 18-Jun-15 1003.4 73.1 292.8 29.45 675.95 987.8 466 741 243.1 323.35 140.55 33020 309.25 166.8 61 10427.16 36 19-Jun-15 1022.25 72.15 295.35 28.4 680.75 984.6 471 725.25 241.5 322.6 141.45 33196 333.55 166.1 60.55 10487.12 37 22-Jun-15 1040.2 74.55 295.35 29.5 683.95 982.55 470 745.85 246.5 323.4 143.45 33858 333.3 168.75 62.55 10643.69 38 23-Jun-15 1045.15 74.1 296.2 28.8 677.5 998.85 473 742.65 244.05 339.55 142.25 34260 321.95 169.75 62.85 10651.92 39 24-Jun-15 1035.55 73.65 301.35 28.55 694.95 980 471 760.25 253.95 341.9 141.35 33861 293.1 168.2 61.8 10617.38 171.7 62.55 10689.75 40 25-Jun-15 1045.7 74.85 308.85 27.85 721.9 984.6 469 745.25 256.25 342.75 149.4 33762 290.8 147.45 33782 290.05 171.35 62.25 10686.11 41 26-Jun-15 1042.65 73.8 308.95 27.75 722.1 982.5 464 748.4 250.75 338.35 165.6 60.2 10540.13 42 29-Jun-15 1022.5 72.85 294.9 27.85 710.6 972.85 449 734.85 247.3 334.9 147.35 33196 280.05 339.5 147.8 34197 282.05 169.7 61.3 10679.99 43 30-Jun-15 1056.65 74.05 299.7 28.1 709.7 993.5 447 741.5 247.85 01-Jul-15 1066.3 74.7 309.45 28.15 705 1018.2 450 746.4 256.95 339.6 150 34787 280.25 173 64.35 10819.31 44 45 02-Jul-15 1071.9 74.65 313.7 27.75 699.45 1019.85 454 750 255.55 346.55 153.8 34839 283.1 173.5 64.6 10871.84 170.65 63.15 10870 46 03-Jul-15 1083.3 74.2 319.3 27.95 690.9 1019.05 453 741.95 258.3 343.95 155.25 34882 282.45 737.9 259.4 341.4 155.95 34805 287.45 172.2 63.85 10962.77 47 06-Jul-15 1136.25 74.35 321.55 28.25 697.4 1018.45 450 286.6 177.85 63.25 11019.99 48 07-Jul-15 1160.2 73.7 317.95 28.35 696.8 1017.25 446 730.95 258.95 342.1 153.65 35135 75.65 34925 49 08-Jul-15 1142.65 311.5 27.95 686.6 1017.05 430 719.25 255.2 338.1 279.8 172.25 59.4 10877.11 72.5 in +
