# Annualized ROR & Standard Deviation

#### Panayiotis

##### New Member
I have a certain number of yearly quarterly data and I would like to Annualize each year's ROR & Standard Deviation as well as Annualize the overall ROR and standard deviation. For example:
1. Years are listed in column A1:A5
2. Quarterly ROR are listed next to each yr so for example in yr 1 all 4 quarterly ROR's are listed in B1:E1

In F1 can I simply enter =product(1+B1:E1)-1 to find the annualized ROR?
Do I multiply the standard deviation of the 4 qtrly returns by sqrt(4) to annualize the yr 1 standard deviation?

Second, what if I want the annualized ror and standard deviation for all 20 quarters?

Many thanks.

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Replies
12
Views
814
Replies
4
Views
550
Replies
3
Views
906
Replies
3
Views
208
Replies
1
Views
512

1,191,696
Messages
5,988,162
Members
440,131
Latest member
EricMoz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back