Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    Share Price of Adani Power Share Price of Torrent Power: Date Price Date Price X - (X-) X

    Uploaded by

    Vaibhav Singh
    The document compares the share prices of Adani Power and Torrent Power over a period of 30 days. It calculates the mean, standard deviation, and coefficient of variance for both companies. The coefficient of variance for Adani Power is 70.49739003, which is 2.40 times higher than Torrent Power's coefficient of variance of 29.506051. This means investing in Torrent Power is less risky than investing in Adani Power. Therefore, the document recommends investing in Torrent Power.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Share Price of Adani Power Share Price of Torrent Power: Date Price Date Price X - (X-) X

    Uploaded by

    Vaibhav Singh
    27 views3 pages
    The document compares the share prices of Adani Power and Torrent Power over a period of 30 days. It calculates the mean, standard deviation, and coefficient of variance for both companies. The coefficient of variance for Adani Power is 70.49739003, which is 2.40 times higher than Torrent Power's coefficient of variance of 29.506051. This means investing in Torrent Power is less risky than investing in Adani Power. Therefore, the document recommends investing in Torrent Power.

    Original Title

    SM ASSIGNMENT.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document compares the share prices of Adani Power and Torrent Power over a period of 30 days. It calculates the mean, standard deviation, and coefficient of variance for both companies. The coefficient of variance for Adani Power is 70.49739003, which is 2.40 times higher than Torrent Power's coefficient of variance of 29.506051. This means investing in Torrent Power is less risky than investing in Adani Power. Therefore, the document recommends investing in Torrent Power.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    27 views3 pages

    Share Price of Adani Power Share Price of Torrent Power: Date Price Date Price X - (X-) X

    Uploaded by

    Vaibhav Singh
    The document compares the share prices of Adani Power and Torrent Power over a period of 30 days. It calculates the mean, standard deviation, and coefficient of variance for both companies. The coefficient of variance for Adani Power is 70.49739003, which is 2.40 times higher than Torrent Power's coefficient of variance of 29.506051. This means investing in Torrent Power is less risky than investing in Adani Power. Therefore, the document recommends investing in Torrent Power.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    SHARE PRICE OF ADANI POWER SHARE PRICE OF TORRENT POWER

    DATE PRICE X- (X- )₂ DATE PRICE X-


    9/1/2018 33.65 4.41 19.4481 9/1/2018 258.1 19.92
    9/2/2018 32.55 3.31 10.9561 9/2/2018 251 12.82
    9/3/2018 31.9 2.66 7.0756 9/3/2018 248.65 10.47
    9/4/2018 32 2.76 7.6176 9/4/2018 264.15 25.97
    9/5/2018 32.55 3.31 10.9561 9/5/2018 269.2 31.02
    9/6/2018 31.25 2.01 4.0401 9/6/2018 253.1 14.92
    9/7/2018 30.35 1.11 1.2321 9/7/2018 245.35 7.17
    9/8/2018 30.05 0.81 0.6561 9/8/2018 243.25 5.07
    9/9/2018 31 1.76 3.0976 9/9/2018 248.95 10.77
    9/10/2018 30.06 0.82 0.6724 ### 249.3 11.12
    9/11/2018 29.55 0.31 0.0961 ### 242.8 4.62
    9/12/2018 29.25 0.01 0.0001 ### 241.7 3.52
    9/13/2018 26.15 -3.09 9.5481 ### 225.2 -12.98
    9/14/2018 24.65 -4.59 21.0681 ### 230.15 -8.03
    9/15/2018 24.9 -4.34 18.8356 ### 228.1 -10.08
    9/16/2018 25.9 -3.34 11.1556 ### 229.25 -8.93
    9/17/2018 25.7 -3.54 12.5316 ### 223.2 -14.98
    9/18/2018 23.85 -5.39 29.0521 ### 220.25 -17.93
    9/19/2018 26 -3.24 10.4976 ### 227.2 -10.98
    9/20/2018 24.4 -4.84 23.4256 ### 223.65 -14.53
    9/21/2018 23.4 -5.84 34.1056 ### 224.2 -13.98
    9/22/2018 23.5 -5.74 32.9476 ### 223 -15.18
    9/23/2018 24 -5.24 27.4576 ### 226.55 -11.63
    9/24/2018 29.95 0.71 0.5041 ### 233.3 -4.88
    9/25/2018 29.95 0.71 0.5041 ### 228.05 -10.13
    9/26/2018 32.6 3.36 11.2896 ### 235.55 -2.63
    9/27/2018 34.8 5.56 30.9136 ### 235.25 -2.93
    9/28/2018 35.75 6.51 42.3801 ### 245.1 6.92
    9/29/2018 34.35 5.11 26.1121 ### 234.25 -3.93
    9/30/2018 33.35 4.11 16.8921 ### 237.7 -0.48
    TORRENT POWER

    (X- )₂ ADANI POWER TORRENT POWER


    396.8064
    164.3524 SUM 877.36 SUM
    109.6209 N 30 N
    674.4409 MEAN 29.24533333 MEAN
    962.2404
    222.6064 SUM OF (X-)₂ 425.0688 SUM OF (X-)₂
    51.4089 SD 20.61719671 SD
    25.7049 CV 70.49739003 CV
    115.9929
    123.6544
    21.3444
    12.3904 INTERPRETATION
    168.4804
    64.4809
    101.6064 By comparing the coefficient of variance of both the companies, we can interpret tha
    79.7449
    would be viable to invest in Torrent Power as the risk of investing in Torrent Power is l
    than that of Adani Power . The risk of investing in Adani Power is 2.40 times higher th
    224.4004 Torrent Power. This means that the shares of Torrent Power has the besy yield ratio
    321.4849 Therefore, I would prefer to invest in Torrent Power.
    120.5604
    211.1209
    195.4404
    230.4324
    135.2569
    23.8144
    102.6169
    6.9169
    8.5849
    47.8864
    15.4449
    0.2304
    TORRENT POWER

    7145.5
    30
    238.18333

    4939.067
    70.278496
    29.506051

    anies, we can interpret that it


    esting in Torrent Power is less
    wer is 2.40 times higher than
    wer has the besy yield ratio.
    ent Power.

    You might also like