Add Title – Relationship with NTPC with Nifty Fifty
Author – Nikita Tripathi
Introduction –
NTPC Limited, formerly known as National Thermal Power Corporation Limited, is an Indian public sector undertaking. It engaged in generation of electricity and allied activities. It is a statutory corporation incorporated under the Companies Act 1956 and is under the ownership of Ministry of Power, Government of India. The headquarters of the company is situated at New Delhi. NTPC’s core function is the generation and distribution of electricity to State Electricity Boards in India. The body also undertakes consultancy and turnkey project contracts that involve engineering, project management, construction management, and operation and management of power plants.
Objective – Relationship with NTPC with Nifty Fifty
Data collection-
Closing Friday price were calculated by:
Data for this company NTPC has collected from NSE. Date and closing prices of NTPC has been downloaded from nseindia.com (Indices & Equity- Historical data)
Friday closing prices were calculated in week-returns.
Indices is taken as (X) and Equity is taken by (Y).
Insert one column in between the Date & Closing price column and write the formula for number ( weekday,2) then sort by A to Z and only take Friday values and insert the weekly return column with formula .(C3-C2)/C2*100
Then to put the regression from data analysis we will get the values of NTPC limited
Data Analysis-
Regression Statistics
Multiple R
0.041639
R Square
0.001734
Adjusted R Square
-0.02095
Standard Error
624.3478
Observations
46
ANOVA
df
SS
MS
F
Significance F
Regression
1
29789.5
29789.5
0.076421
0.783503
Residual
44
17151649
389810.2
Total
45
17181439
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
Intercept
913
570.28
1.602
0.12
-236
2063
-236
2063
X Variable 1
-0
0.0349
-0.28
0.78
-0.1
0.06
-0.08
0.061
Y= a+bx
A= 913
B=-0
Y=913+0
Tstat -0.28
Since P value is more than 0.05 the model is not significant @ 5%
for your Article from here.