Friday, April 26, 2013

Skew Formula

=Skew(A2:A9)
Skews looks at the deviation of a value from the mean. If list of values are mostly above the average then the skew value will be negative. If the values are mostly below the mean then the skew value will be positive.
Read More..

Saturday, April 13, 2013

Avedev Formula

=AVEDEV(Range)
Example:
=AVEDEV(A2:A9)
The function above is short for average deviation. It calculates the mean of the range and also calculates its deviation altogether.
Read More..

Wednesday, April 3, 2013

SIN, COS and TAN Formulas

To use the SIN, COS and TAN to convert degree angles you also have to wrap the degree angle with the RADIANS formula. The SIN, COS and TAN formulas can only read RADIANS not Degrees. Examples are as follows:
=SIN(RADIANS(90))
=COS(RADIANS(9))
=TAN(RADIANS(9))
Read More..

Tuesday, April 2, 2013

Degrees and Radians

1 Radian = 57.3 degrees.
To convert degrees to radian
=RADIANS(Number of Degrees)
To convert radian to degrees
=DEGREES(Number of Radians)
Read More..

www.cineclouds.com. Powered by Blogger.