If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/ 3 Zscore rule and the ABS function. See how to do a box plot by hand and in Excel. For the Excel Box Plot see how to record MIN, QUARTILE 1, MEDAIN, QUARTILE 3, MAX, AVERAGE on a stacked bar Chart with the mean added as an XY scatter.
 Hot
 Latest

How To: Remember "greater than" & "less than" symbols

How To: Use ">" (greater than) and "<" (less than) symbols

How To: Find a number given Its percent

How To: Find the Percent Given Two Numbers

How To: Find extra points for a parabola (quadractic equation)

How To: Calculate Faster Than a Calculator

How To: Divide small numbers by big numbers

How To: Find and sketch the domain of a multivariable function

How To: Find the 100th term in a sequence

How To: Find the lowest common multiple/LCM with a factor tree

How To: Solve advanced ratio problems in algebra

How To: Quickly find the area of a trapezoid

How To: Perform an astonishing toothpick math trick

How To: Do long division without a calculator

How To: Find a missing coordinate given: coordinate & equation

How To: Do normal probability calculations on a calculator

How To: Determine the age of a fossil using carbon14

How To: Write a logarithm as a sum or difference of logarithms

How To: Find the standard deviation with the ZScore formula

How To: Calculate probability in "at least one" problems

How To: Remember "greater than" & "less than" symbols

How To: Use ">" (greater than) and "<" (less than) symbols

How To: Find a number given Its percent

How To: Find the Percent Given Two Numbers

How To: Find extra points for a parabola (quadractic equation)

How To: Calculate Faster Than a Calculator

How To: Divide small numbers by big numbers

How To: Find and sketch the domain of a multivariable function

How To: Find the 100th term in a sequence

How To: Find the lowest common multiple/LCM with a factor tree

How To: Solve advanced ratio problems in algebra

How To: Quickly find the area of a trapezoid

How To: Perform an astonishing toothpick math trick

How To: Do long division without a calculator

How To: Find a missing coordinate given: coordinate & equation

How To: Do normal probability calculations on a calculator

How To: Determine the age of a fossil using carbon14

How To: Write a logarithm as a sum or difference of logarithms

How To: Find the standard deviation with the ZScore formula

How To: Calculate probability in "at least one" problems
Be the First to Comment
Share Your Thoughts