Look up Bank of Queensland stock price, put option data and daily implied volatility on refinitiv or yahoo finance for the last year. The question or problem in the assignment is this: For your allocated banking stock only (BOQ), calculate and plot annualized historical volatility with annual implied volatility in a graph (show calculations and workings). I want to know how to calculate and plot annualised historical volatility vs annual implied volatility on excel.