By looking at the opening and closing prices of every single stock on the New York Stock Exchange on September 3rd, 2008 (3,243 current listings), I was able to determine the association that volume of a stock has with percentage change.
I had to locate every stock on the New York Stock Exchange for an assignment at school, and obviously with such a surplus of information, I did a lot of cool things with the Excel document that I found. One of them was to determine this correlation.
The best association between two variables equals 1.00 after performing a regression analysis that Microsoft Excel takes care of when adding a trend line for a given data set. 1.00 represents that the X and Y coordinates create a perfect line together. On the other hand, a regression analysis of 0 indicates that there is absolutely no association between the variables and is typically seen as a haphazard cloud of points completely in disarray.
Based on this information, we can analyze just how close the relationship is between the two variables.
- Results
This is a tiny number and unbelievably close to 0, which is indicative of little to no association between these two variables. As you can see, the points look like a cloud of information with some random outliers. If the correlation between these two were stronger, one would see the points follow the linear trend line inserted in the graph.
- Conclusion
A stock with high volume may have a low percentage change, while the exact opposite of a stock with low volume might have high percentage change. Both statements are unavoidably the case based on empirical research done on September 3rd, 2008 for the New York Stock Exchange.
No comments:
Post a Comment