Instruction on calculating Standard Deviation in Excel

Download Presentation

Instruction on calculating Standard Deviation in Excel

Loading in 2 Seconds...

- 91 Views
- Uploaded on
- Presentation posted in: General

Instruction on calculating Standard Deviation in Excel

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Instruction on calculating Standard Deviation in Excel

Standard Deviation:

= Probability

E( R )= Expected Return

= Variance

= Standard Deviation

To calculate the Expected Return, the return column should get multiplied by probability column:

Select a cell in excel

Enter the = sign in the cell

Select return cell, the * sign and then select the probability cell

Press Enter

Now we need the same formula for the rest of the cells, to do that we are going to drag:

Place your mouse in the lower right corner of the cell (in this case D3), once you see the filled in plus sign, left click and drag down

The next step in calculating the expected return is to add all the values in column “Return*Prop”

Select a cell in excel

Enter the = sign in the cell

Type in SUM

Double click on the formula and select the data

Close parenthesis

Press Enter

On the next column near the data

Enter the equal sign

Select the first return

Enter the minus sign

Select the expected return

Enter

- Next we want to copy the formula for the rest of the rows. To do this we need to make the expected returncell fixed
- For that select the cell
- Click next to the cell number (that contains the expected return) which in this example is D8
- Add $ next to cell column and row. i.e. $D$8

Now place your mouse in the lower right corner of the cell, once you see the filled in plus sign, left click and drag down

Go to the next column on the first row

Enter the equal sign

Select the R - ER cell, in this example E3

Then Shift + 6 ( to add ^ sign)

The number 2

Enter

Now we need the same formula for all the other values. So place your mouse in the lower right corner of the cell, once you see the filled in plus sign, left click and drag down

Select a cell in excel

Enter the = sign in the cell

Select probability cell, the * sign and then select the [R – E( R )]^2 cell

Press Enter

Now we need the same formula for the rest of the cells:

Place your mouse in the lower right corner of the cell once you see the filled in plus sign, left click and drag down

Select a cell

Enter the equal sign

Enter the word SUM

Double click on the formula

Select the data

Enter

This is the last step. We need to take the square root of the number we found in part 6. To do that follow the following steps:

Enter the equal sign into a cell

Then type SQRT and select Excel's formula

Select the cell from step 6

Enter