Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Smiley
 
Posts: n/a
Default 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
  #2   Report Post  
Tourcat
 
Posts: n/a
Default

Here is a formula that might help.

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

  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I multiply rate per hour by hours worked. MAC Excel Worksheet Functions 1 December 22nd 04 03:29 PM
Formula between to numbers is true multiply pflynn Excel Worksheet Functions 4 December 22nd 04 02:22 AM
Multiply by a constant flotowntiger Excel Discussion (Misc queries) 3 December 6th 04 10:42 PM
How do I multiply Column G Totals by a number and display the res. wewgyro Excel Discussion (Misc queries) 2 December 5th 04 04:27 PM
multiply by actual number in cell CJ Cerezo Excel Worksheet Functions 3 November 29th 04 09:43 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"