Computing Value at Risk Using Descriptive Statistics
Essay by rupalm02 • November 15, 2015 • Research Paper • 945 Words (4 Pages) • 1,376 Views
Computing Value-at-Risk using
Statistical tools
And Descriptive statistics
Presented by:
- Rupal Mishra
Table of contents:
S.No. | Topic |
1.) | Objective |
2.) | Introduction |
3.) | Desctriptive_Statistics |
4.) | Inferences |
5.) | Probability_Distribution |
6.) | Value_at_Risk |
7.) | Correlation_Analysis |
8.) | Conclusion |
OBJECTIVE:
In the current project, we are computing value at risk for two securities. Both the securities are chosen from different industries and we are trying to understand there correlation. Value at Risk has been calculated using Normal Distribution curve drawn using one year data (From 1st April 2013 to 29th March 2014) of both securities.
We are also using descriptive statistic techniques to figure out the variability and average returns of both the stocks. The riskiness of stock will help us identify, which stock is better to invest for a risky investor and which one is better for risk averse investor.
At the end, we will be taking our decision based on value at risk computed and descriptive statistics done to find out, which stock has performed better and what does correlation between two suggests.
INTRODUCTION:
The project will be covered in two parts:
- In the first part, we will use descriptive statistics techniques to find out the to analyze the stocks selected.
- In the second part, we will do regression analysis of the stock with respect to indices and will use normal distribution probability curve to find out the value-at-risk
For our reference, we have chosen one automobile stock- TATA MOTORS and one oil stock-(ONGC), to analyze. As a general perception, we should think that as both the stocks are from opposing sectors, their correlation should be negative and adding an oil sector stock in automobile sector portfolio, should reduce the risk.At the end of project, we will prove through out statistical analysis of stocks over the year that they have not behaved in the similar fashion as we expected. This could be due to various other market factors.
The price data for those stocks have been taken from here:
https://in.finance.yahoo.com/q/hp?s=TATAMOTORS.BO
DESCRIPTIVE STATISTICS:
Following descriptive statistics data has been computed in Excel for Tata Motors stock. All data is with respect to returns for each stock.
TATA MOTORS Stock Analysis | |||||
No of observations | 259 | ||||
Mean | 0.18% | ||||
Sample Variance | 0.05% | ||||
Std. Dev. | 2.14% | ||||
Range | 16.01% | ||||
Median | 0.05% | ||||
Mode | 0.00% | ||||
Maximum | 9.88% | ||||
Minimum | -6.13% | ||||
Skewness | 59.33% | ||||
Kurtosis | 256.29% | ||||
Population variance | 0.05% | ||||
Sharpe Ratio | 0.08298 | ||||
Here is the descriptive statistics analysis for ONGC stock:
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
INFERENCES
- The mean returns of TATA MOTORS stock is more than ONGC, hence we can assume that returns from TATA Motors are more than ONGC for an investor.
- The Standard deviation of TATA MOTORS stock is more than that of ONGC, though comparable, from which we can predict that both stocks are almost same in riskiness.
PROBABILITY DISTRIBUTION
TATA Motors
[pic 1]
Data from table in page 9
Frequency Distribution Table of TATA Motors:
Frequency distribution |
|
Bins | Frequency |
-10 to -9 | 0 |
-9 to -8 | 0 |
-8 to -7 | 0 |
-7 to -6 | 1 |
-6 to -5 | 0 |
-5 to -4 | 4 |
-4 to -3 | 15 |
-3 to -2 | 16 |
-2 to -1 | 29 |
-1 to 0 | 47 |
0 to 1 | 72 |
1 to 2 | 28 |
2 to 3 | 29 |
3 to 4 | 8 |
4 to 5 | 7 |
5 to 6 | 1 |
6 to 7 | 0 |
7 to 8 | 0 |
8 to 9 | 0 |
9 to 10 | 2 |
...
...