
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.