peak to trough timeline

I have a list of dates (column A) and prices (column B) and % change (Column C). I need to calculate:

1. On average, how long does it take for Column B to change from peak to trough?
2. How long to reach average price of Column B from peak? From trough?
3. What is the average % change day after trough?
4. What days of the week are most volatile?

Project is due 14 Dec 2014. Please help.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

You can continue in Commercial Services subforum.

Thread Closed.