KEMBAR78
T8 Analysis | PDF | Coefficient Of Determination | Applied Mathematics
0% found this document useful (0 votes)
24 views12 pages

T8 Analysis

Uploaded by

pshethia09
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
24 views12 pages

T8 Analysis

Uploaded by

pshethia09
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Company Name EnvironmenSocial ScorGovernance

ESG Score Category


1 Bharat Petroleum 40 54 64 53 Adequate
2 Castrol India Limited 40 56 71 56 Adequate
3 GAIL 57 73 62 63 Strong
4 Hindustan Petroleum 40 55 59 51 Adequate
5 Indian Oil Corporation 50 60 64 58 Adequate
6 Linde India 38 37 66 49 Adequate
7 Mahanagar gas limited 29 48 67 49 Adequate
8 Oil and Natural Gas 29 47 62 47 Adequate
9 Oil India Limited 27 62 63 50 Adequate
10 Reliance Industries 41 46 68 53 Adequate

600+ KPIs

Score category: 0-
30: Weak, 31-45:
Below average, 46-
60: Adequate, 61-
70: Strong, 71-100:
Leadership
Adequate
Adequate

Adequate
Adequate
Adequate
Adequate
Adequate
Adequate
Adequate
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.075391
R Square 0.005684
Adjusted R-0.118606
Standard E 5.168154
Observatio 10

ANOVA
df SS MS F Significance F
Regression 1 1.221447 1.221447 0.04573 0.836016
Residual 8 213.6786 26.70982
Total 9 214.9

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 50.87038 9.630716 5.282097 0.000744 28.66191 73.07885 28.66191 73.07885
X Variable 18.36763 85.8917 0.213846 0.836016 -179.699 216.4342 -179.699 216.4342
Company name RoI=TI/TC Market CapitalisationRoA: NP/TA
1 Bharat Petroleum Corpn.252.154913241 746331.41 0.011393426893
2 Castrol India Ltd. 10.7808557101 109396.94 0.263952076419
3 G A I L (India) Ltd. 22.3956076714 692029.24 0.052979873682
4 Hindustan petroleum 332.347942831 335912.25 -0.056808991262
5 Indian Oil Corpn. Ltd. 69.6916304326 1100609.32 0.01866141648
6 Linde India Ltd. 38.0607410882 343814.82 0.104837305229
7 Mahanagar Gas Ltd. 71.1994330836 97231.91 0.129553985337
8 Oil & Natural Gas Corpn. 26.8327318629 1899622.16 0.09985819107
9 Oil India Ltd. 22.9294455049 272890.57 0.115150731232
10 Reliance Industries Ltd. 85.608040201 15772103.45 0.049537237816
Avg Price Environmental ScorSocial Score Governance ScESG Score Category Positive Sentiment
343.625 40 54 64 53 Adequate 0.09
111.3 40 56 71 56 Adequate 0.135
105.925 57 73 62 63 Strong 0.137
235.5 40 55 59 51 Adequate 0.1
77.76 50 60 64 58 Adequate 0.085
3995.025 38 37 66 49 Adequate 0.114
981.05 29 48 67 49 Adequate 0.118
151.4 29 47 62 47 Adequate 0.132
256.7 27 62 63 50 Adequate 0.108
2298.775 41 46 68 53 Adequate 0.086
Positive Sentiment
Dependent Variable Independent Variable Equation
RoI ESG Score y = 249.16 -2.95x
RoI Environment Score y = 0.69 + 66.24x
RoI Social Score y = 115.80 - 0.42x
RoI Governance Score y = 1067.39 - 15.08x

Dependent Variable Independent Variable Equation


Avg Stock Price ESG Score y = 5635.20 - 90.35x
Avg Stock Price Environment Score y = 1405.51 -14.06x
Avg Stock Price Social Score y = 6008.83 - 95.78x
Avg Stock Price Governance Score y = -7382.77 + 127.53x
p-value R-Square Comments Dependent Variable
0.716917703 0.017336479 Insignificant Governance Score
0.870732511 0.003516705 Insignificant
0.915986394 0.001479408 Insignificant
0.16197529 0.228805936 Insignificant

p-value R-Square Comments Dependent Variable


0.336455813 0.115587608 Insignificant ESG Score
0.779408033 0.010382255 Insignificant
0.01459429 0.546228563 Significant at 5%
0.335171124 0.116166156 Insignificant
Independent Variable Equation p-value R-Square
Market Capitalisation y = 64.14 + 2.14x 0.403082224931 0.088772539407

Independent Variable Equation p-value R-Square


Positive Reporting Senti y = 50.87 + 18.37x 0.000744316235 0.005683793922
Comments
Significant at 5%

Comments
Significant at 1%

You might also like