The project statistically studies and compares the daily closing price movement of two investment options – real estate and gold represented by DLF stock and SBI Gold ETF respectively – over the past 3 years.| Comparative study of DLF Stock and Gold ETF price movement|
Linear Regression Analysis7
Regression Analysis: DLF Closing versus Gold Closing using Minitab7
In this stage, the daily closing values of DLF stock price and SBI Gold ETF are analyzed. These two are selected to study the two traditionally important investment vehicles in India – Real estate and Gold. DLF being the largest real estate company India and SBI Gold ETF being the largest ETF in India, they are assumed to represent their underlying sectors for this study. By studying the various statistical parameters such as mean, variance, standard deviation, and confidence interval through this project, one would be in a better position to compare the two investment options. Problem Statement
Any investment has a return component and a risk component. One measure of return is the % appreciation in value of the investment over a period of time. In case of our subjects, the % appreciation/depreciation of daily closing prices is an effective measure of return. The frequency distribution plot of the % change of closing price is a visual representation of the volatility – which is an important measure of risk.
The risk component can also be measured by calculating the mean value of the % change of the investment and the standard deviation, the range etc.., which represents the volatility of the value. % change - DLF|
Standard Error| 0.12|
Standard Deviation| 2.81|
Sample Variance| 7.90|
Confidence Level (95.0%)| 0.23|
| % change - gold|
Standard Error| 0.04|
Standard Deviation| 1.00|
Sample Variance| 1.01|
Confidence Level (95.0%)| 0.08|
The data for the calculations can be found in Appendix A.
A box plot of the % change in daily closing prices is another visual representation of the risk (volatility). The graph below is the box plot of the % change in daily closing price of both DLF stock and Gold ETF
1. From the frequency plot, it’s clear that the % change in daily closing price of DLF stock is more dispersed while that of Gold ETF is concentrated around the centre. This means that the volatility (risk) is more in case of DLF stock (real estate investment). 2. From the descriptive statistics table, DLF has a negative (-0.08) mean for %change of daily closing price, which means that, on an average the stock depreciated over the 3 year period per day. While the same measure of Gold ETF is positive (0.12) – which means the ETF appreciated by 0.12% per day on an average over the 3 year period. 3. From the descriptive statistics table, the standard deviation of DLF stock closing price change is almost 3 times that of the Gold ETF, which means it’s a riskier investment. 4. From the box plot and the descriptive statistics, the median value of % change in DLF stock closing price is negative whereas that of Gold ETF is positive; which means that 50% of the time, we can expect ETF to appreciate in value and DLF to depreciate. 5. The box plot also contrasts the variation in the % change in both investments; the DLF stock varies over a...