Business Research Methodology Research Assignment
SAP ID – 80012100423
Faculty In-Charge – Prof. J K Sachdeva
Problem Title:
To determine the relationship between Nifty and Vedanta Limited.
Author – Anubhuti Bhalotia
INTRODUCTION OF COMPANY
Archies Limited is India’s market leader in the social expression industry with over 60% market share in the organized sector. It has grown from a cards-only company to a complete social expressions company. This Company has grown with the spread of modern culture, increasing urbanization and improving standard of living. Adorability and sentiment drive its brand appeal to all age groups and demographics. Archies has enormous ranges which have established exemplary mastery over its large network of distributors, retailers and franchisees. This Company is consciously targeting malls and other prime retail space for opening its own stores. Archies Limited currently operates 230+ exclusive outlets in 15 states 66 cities and nearly 300 franchise outlets across India and neighboring countries.
OBJECTIVE
To calculate beta of company and find its significance
Data Collection:
Data was collected from the NSE Website which comprises of historic data for the past 1 year. The Friday of each week of the year was taken into consideration. The resultant was calculated, and regression was performed on the data.
Data Analysis:
We know Y= a +bx1 Where b is the beta value. H0 – Null Hypothesis
H1 – Alternate Hypothesis
If the beta coefficient is significant, the interpretation is that for every 1-unit increase in the predictor variable, the outcome variable will increase by the beta coefficient value.
It was found that R Square is 0.170859 regression Equation was found to be
Y= 0.762787+1.714164X
Here Beta value is +1.714164
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.413351
R Square 0.170859
Adjusted R Square 0.166472
Standard Error 10.15122
Observations 191
Interpretations:
We can see that the R square value is 0.170859, which means that Nifty can explain
1.7 % of the weekly returns of Archies. Because the proportion is low, we may deduce that Archies does not follows the Nifty trend to a certain extent.
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.762787 0.734598 1.038372 0.300423 -0.68628 2.211852 -0.68628 2.211852
WEEKLY RETURN NIFTY 1.714164 0.274674 6.240732 2.8E-09 1.172344 2.255984 1.172344 2.255984
We can observe here that the Beta value is 1.714164 meaning that 1 unit change in Nifty leads to 1.714164 change in weekly returns of Archies. We also need to note that the value is beta is positive indicating both of them are proportional to each other.
ANOVA
df SS MS F Significance F
Regression 5 67721202977 13544240595 579.3073 0
Residual 4993 1.16737E+11 23380062.17
Total 4998 1.84458E+11
H0: Nifty is not influencing the weekly returns of Archies.
H1: Nifty is influencing the weekly returns of Archies.
Here as the F value is 1.93086 which is less than 4, thus we can accept the null- hypothesis and reject the alternate hypothesis, concluding that nifty is not influencing the weekly returns of Vedanta.
Also, the Significance F value is 0.1716 which is more than .025 thus the model isn’t significant.