Explore BrainMass

Finding price variability and highest average price

Which stock showed the most price variability? Which stock had the highest average price?
Excel sheet is included with stock prices


Solution Preview

So for price variability, I will make an assumption - that variability is how much the stock changes price on a day to day basis.

So what we have to do is look at the differences at every date. We do that by calculating the 'delta' ...

Solution Summary

The solution determines how to find a price variability and highest average price. The most price variability is determined.