ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to multiply 29,5 with sqrt of 12 (https://www.excelbanter.com/excel-worksheet-functions/12512-how-multiply-29-5-sqrt-12-a.html)

Smiley

how to multiply 29,5 with sqrt of 12
 
I have a row of percenteges (12) where I have to get the Standarddeviation
from,that number has to be multiplied with the root of 12

Tourcat

Here is a formula that might help.

=STDEV(A4:L4)*SQRT(12)


Peo Sjoblom

One way

=12^(1/2)*29.5

or

=STDEV(A1:A20)*12^(1/2)


--

Regards,

Peo Sjoblom


"Smiley" wrote in message
...
I have a row of percenteges (12) where I have to get the Standarddeviation
from,that number has to be multiplied with the root of 12





All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com