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 the Volume of Composite Figures (Also Called Composite Shapes)

How To: Subtract a mixed number from a proper fraction in basic math

How To: Calculate percent composition for chemistry

How To: Find a number given Its percent

How To: Find the standard deviation with the ZScore formula

How To: Find the formula of a piecewise function given a graph

How To: Translate a sentence into math symbols

How To: Find the slope of a line given 2 points with fractions

How To: Find the Percent Given Two Numbers

How To: Calculate the height and volume of a pyramid

How To: Convert Fahrenheit to Celsius with a formula

How To: Find how many toothpicks will be needed to form the nth figure in a sequence

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

How To: Convert between diameter and radius

How To: Find the area of a parallelogram using geometry

How To: Use a TI89 to calculate nCr

How To: Use derivatives to find slope in calculus

How To: Find the area of a triangle when given 2 sides & angle

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

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

How To: Find the Volume of Composite Figures (Also Called Composite Shapes)

How To: Subtract a mixed number from a proper fraction in basic math

How To: Calculate percent composition for chemistry

How To: Find a number given Its percent

How To: Find the standard deviation with the ZScore formula

How To: Find the formula of a piecewise function given a graph

How To: Translate a sentence into math symbols

How To: Find the slope of a line given 2 points with fractions

How To: Find the Percent Given Two Numbers

How To: Calculate the height and volume of a pyramid

How To: Convert Fahrenheit to Celsius with a formula

How To: Find how many toothpicks will be needed to form the nth figure in a sequence

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

How To: Convert between diameter and radius

How To: Find the area of a parallelogram using geometry

How To: Use a TI89 to calculate nCr

How To: Use derivatives to find slope in calculus

How To: Find the area of a triangle when given 2 sides & angle
Be the First to Comment
Share Your Thoughts