Page 407 - Excel 2013 All-in-One For Dummies

Chapter 5: Math and Statistical Formulas
In This Chapter
✓ Rounding off numbers
✓ Raising numbers to powers and finding square roots
✓ Conditional summing
✓ Using basic statistical functions, such as AVERAGE, MIN, and MAX ✓ Building formulas that count
✓ Using specialized statistical functions
This chapter examines two larger categories of Excel functions: Math
& Trig and statistical functions. The Math & Trig functions are found
on the Math & Trig command button’s drop-down menu on the Ribbon’s Formulas tab (the button with the q on the book cover). This category includes all the specialized trigonometric functions such as those that return the sine, cosine, or tangents of various angles and logarithmic func- tions (for finding the base-10 and natural logarithms of a number), along with the more common math functions for summing numbers, rounding numbers up or down, raising a number to a certain power, and finding the square root of numbers. Foremost among the new Math & Trig functions in Excel 2013 is the Arabic function that converts any Roman numeral text in
a worksheet range into Arabic numerals (xxi to 21, for example). This new function compliments the older Roman function, which, you guessed it, con- verts Arabic numerals into Roman numeral text (16 into XVI, for instance).
The statistical functions are found on a continuation menu accessed from the More Functions command button’s drop-down menu on the Formulas tab (the button with the two books). Statistical functions include the more common functions that return the average, highest, and lowest values in a cell range
all the way to the very sophisticated and specialized functions that calculate such things as the chi-squared distribution, binomial distribution probability, frequency, standard deviation, variance, and — my personal favorite — the skewness of a distribution in a particular population.