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 include all the specialized trigonometric functions such as those that return the sine, cosine, or tangents of various angles and logarithmic functions (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.
The Statistical functions include the more common functions that return the average, highest, and lowest ...
Get Excel All-in-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
